1z0-082 Exam Dumps : Oracle Database Administration I

Add the SEGMENT SPACE MANAGEMENT AUTO clause

Set UNDO_TABLESPACE to UNDOTBS01

Add the NOLOGGING clause

Make certain that the database operates in automatic undo management mode

Add the ONLINE clause

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 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.