Free Oracle 1Z0-182 Exam Dumps Questions & Answers

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?

• A.The PDB archive file must be copied to the target CDB.
• B.PDB archive file and only the user-defined tablespaces must be copied to the target CDB.
• C.The PDB manifest and all the datafiles 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.

What is the result of the following command? ALTER PLUGGABLE DATABASE PDB1 DISCARD STATE;

• A.PDB1 is reverted to its default properties, which includes not to automatically open after a CDB restart.
• B.It should be used whenever PDB1 open mode needs to be changed.
• C.It is unnecessary if the PDB is in the process of being upgraded.
• D.PDB1 is reverted to its default properties, which includes automatic opening after a CDB restart.

How do you validate that the database was migrated to Unified Auditing?

• A.By using the LSINVENTORY Command to query the Oracle Database Software Library.
• B.By querying the DBA_UNIFIED_AUDIT_OPTION view.
• C.By querying V$OPTION for parameter Unified Auditing.
• D.By executing DBMS_AUDIT_MGMT PL/SQL package in Verify mode.

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

• A.Row pieces of a chained row must always reside in different blocks.
• B.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.
• C.Update statements can result in one or more chained rows.
• D.Update statements can result in one or more migrated rows.
• E.Insert statements can result in a migrated row.

Which two statements are true about views used for viewing tablespace and datafile information?

• A.Tablespace free space can be viewed in DBA_TABLESPACES.
• B.Tablespace free space can be viewed in V$TABLESPACE.
• C.A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened.
• D.V$TABLESPACE displays information that is contained in the control file about tablespaces.
• E.V$TABLESPACE displays information about tablespaces contained in the data dictionary.