Free Access to Oracle.1Z0-182.v2025-06-10.q32 with Valid Practice Test (Page 4)

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

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

Which statement is true about database links?

A.A database link can be created only between two Oracle databases.
B.Private database link creation requires the same user to exist in both the local and the remote databases.
C.A public database link can be created only by SYS.
D.A database link created in a database allows a connection from that database's instance to the target database's instance for selecting schema data.
E.A public database link can be used by any user allowing remote database instance connection for selecting schema data.

Which two actions can you perform using DBCA for an existing database?

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

A.It is held inside an Oracle database schema.
B.The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set.
C.It supports diagnostics for Automatic Storage Management (ASM).
D.It supports diagnostics for Oracle Clusterware.
E.The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set.

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

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

Download PDF File