Question 1

Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statements are true?

Options :

A : Dependent indexes become UNUSABLE.

B :

The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.

C : Only queries are allowed on ORDERS while SHRINK is executing.

D : The high-water mark (HWM) of ORDERS is adjusted.

E : Queries and DML statements are allowed on ORDERS while the SHRINK is executing.

F :

The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.

Answer: E,F

Question 2

You unplugged a PDB to plug it into another CDB with the following command: SQL> ALTER PLUGGABLE DATABASE pdb1 UNPLUG INTO '/tmp/pdb1.pdb'; Which statement is true prior to plugging the PDB into the other CDB?

Options :

A : The PDB archive file must be copied to the target CDB.

B : The PDB manifest and all the datafiles must be copied to the target CDB.

C : PDB archive file and only the user-defined tablespaces must be copied to the target CDB.

D : The PDB manifest, the data files, and the PDB archive file must be copied to the target CDB.

Answer: D

Question 3

Which two statements are true about the configuration and use of UNDO?

Options :

A : Active UNDO is always retained.

B : Unexpired UNDO is always retained.

C : UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO.

D : UNDO_RETENTION specifies how long all types of UNDO are retained.

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

Answer: A,E

Question 4

Which two statements are true about advanced connection options supported by Oracle Net for connection to Oracle?

Options :

A : Connect Time Failover requires the use of Transparent Application Failover (TAF).

B : Source Routing requires the use of encrypted connections.

C : Connect Time Failover requires the connect string to have two or more listener addresses configured.

D : Load Balancing requires the use of a name server.

E :

Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration.

Answer: C,E

Question 5

Which three statements are true about row chaining and row migration done by Oracle database block space management?

Options :

A :

A migrated row results in an update to any index on the table to point the row ID in the index to the row’s new location.

B : Update statements can result in one or more migrated rows.

C : Update statements can result in one or more chained rows.

D : Row pieces of a chained row must always reside in different blocks.

E : Insert statements can result in a migrated row.

Answer: A,B,C

Higher Test Marks with Free Online 1Z0-182 Exam Practice

Buying Options: