1z0-082 Exam Dumps - Oracle Database 19c Questions and Answers

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

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

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 primary key constraint will be enabled and deferred.

The foreign key constraint will be enabled and deferred.

The foreign key constraint will be disabled.

The foreign key constraint will be enabled and immediate.

The primary key constraint will be enabled and immediate.