 Related Questions A schema is collection of database objects of a User. Latest Answer : Schema is a Collection of Database objects of a user.Example: Tables, Views, Synonyms, Sequences, Clusters, Triggers, Procedures, Packages. ... A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns. Latest Answer : Table is data base object which stores the data in the logical representatiom in form of rows n coluns which is existing in two dimension form... and is stored in the databse. ... Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.Hide data complexity.Simplify commands for the user.Present the data in a different Public synonyms can be accessed by any user on the database. Synonyms are used to : Mask the real name and owner of an object.Provide public access to an objectProvide location transparency for tables, views or program units of a remote database.Simplify the SQL Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global object name in a SQL statement or object Latest Answer : A database link is a pointer that defines a one-way communication path from an Oracle Database server to another database server. The link pointer is actually defined as an entry in a data dictionary table. To access the link, you must be connected to ... Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement The condition must be a Boolean expression evaluated using the values in the row being inserted or updated and can't contain sub queries, sequence, the SYSDATE,UID,USER or USERENV SQL functions, or Latest Answer : A check constraint allows you to specify a condition on each row in a table. Note: A check constraint can NOT be defined on a VIEW. The check constraint defined on a table must refer to only columns in that table. It can not refer to columns in other ... what is remote login user and local user in database?And sid is used when user want to login as local user and Glodal database name is used when user wants to login as remote user..What does it mean ? Latest Answer : When you have distributed environment,you may access one database from other.This is normally done via db link.So lets say you have flight database and customer dabatabase.Now from customer database you intend to access flight database then you ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0