A.DML modifies Oracle database objects and only generates UNDO

B.The generation of REDO generates UNDO

C.The generation of UNDO generates REDO

D.DML modifies Oracle database objects and only generates REDO

A.UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

B.Unexpired UNDO is always retained.

C.Active UNDO is always retained.

D.UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.

E.UNDO_RETENTION specifies how long all types of UNDO are retained.

A.Employee 100 will have SALARY set to the same value as the SALARY of employee 200

B.Employees 100 and 200 will have the same SALARY as before the update command

C.Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

D.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

E.Employee 200 will have SALARY set to the same value as the SALARY of employee 100

F.Employees 100 and 200 will have the same JOB_ID as before the update command

A.It appends data from EMP.DAT TO EMP.

B.It overwrites all data in emp with data from emp.dat.

C.It generates a sqi script that it uses to load data from EMP.DAT TO EMP.

D.It generates a log that contains control file entries, which can be used with normal SQL'Loader operations.

E.It overwrites the data for Alan and adds data for Curl and Bob

A.The foreign key constraint will be disabled.

B.The primary key constraint will be enabled and deferred.

C.The primary key constraint will be enabled and immediate.

D.The foreign key constraint will be enabled and immediate.

E.The foreign key constraint will be enabled and deferred.