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

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

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

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

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

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

A.The online data files are opened

B.The alert log records the execution details

C.The initialization parameter file is read

D.The online redo logs are opened

E.The control file is read

F.The Oracle background processes are started

A.Data block headers contain their own Data Block Address (DBA)

B.A table row piece can be chained across several database blocks

C.Multiple row pieces from the same row may be stored in different database blocks

D.Multiple row pieces from the same row may be stored in the same block

E.Data block free space is always contiguous in the middle of the block

F.Index block free space is always contiguous in the middle of the block

A.It is not possible to shrink either indexes or Index Organized Tables (IOTs)

B.It always eliminates all migrated rows if any exist in the table

C.To shrink a table it must have a PRIMARY KEY constraint

D.To shrink a table it must have a UNIQUE KEY constraint

E.To shrink a table it must have row movement enabled

F.It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

A.Set OS_AUTHENT_PREFIX to OPS$

B.Have the OS administrator add KING to the OSDBA group

C.Grant DBA to KING

D.Unset REMOTE_LOGIN_PASSWORDFILE

E.Alter user KING to be IDENTIFIED EXTERNALLY