Question 1

You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle /sales01.dbf' SIZE 5G SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES tablespace?

Options :

A : Free space is managed using freelists.

B : It uses the database default block size.

C : It must be smaller than the smallest BIGFILE tablespace.

D : It is a locally managed tablespace.

E : Any data files added to the tablespace must have a size of 5 gigabytes.

Answer: B,D

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

Question 5

Which two statements are true about the tools used to configure Oracle Net Services?

Options :

A : The lsnrctl utility requires a listener.ora file to exist before it is started.

B : Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.

C : The Oracle Net Configuration Assistant is only used when running the Oracle installer.

D : Oracle Net Manager can be used to locally configure naming methods on a database server.

E : Oracle Net Manager can be used to centrally configure listeners on any database server target.

Answer: B,D

Confidently Practice Online with Free 1Z0-182 Exam Cram

Buying Options: