Authentic Oracle Certification Exam 1z0-082 Questions Answers

Private database link creation requires the same user to exist in both the local and the remote databases.

A public database link can be created only by sys.

A database link can be created only between two Oracle databases.

A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.

A database link created in a database allows a connection from that database's instance to the target database's Instance, but not vice versa.

The concatenation operator | | is always evaluated before addition and subtraction in an expression

NULLS influence the precedence of operators in an expression

The + binary operator has the highest precedence in an expression in a SQL statement

Arithmetic operators with equal precedence are evaluated from left to right within an expression

Multiple parentheses can be used to override the default precedence of operators in an expression

A table can have only one primary key but multiple foreign keys

A table can have only one primary key and one foreign key

The foreign key columns and parent table primary key columns must have the same names

It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

Only the primary key can be defined at the column and table level

Primary key and foreign key constraints can be defined at both the column and table level