A. Data files are closed normally.
B. Uncommitted transactions are not rolled back by the shutdown.
C. A checkpoint is written.
D. Subsequent instance startup performs instance recovery.
E. Subsequent instance startup performs media recovery.
A. PDB1 is reverted to its default properties, which includes automatic opening after a CDB restart.
B. It should be used whenever PDB1 open mode needs to be changed.
C. PDB1 is reverted to its default properties, which includes not to automatically open after a CDB restart.
D. It is unnecessary if the PDB is in the process of being upgraded.
A. Automatic Application Tracing used to collect High-Load SQL statements and statistics.
B. ADDM, a server-based expert that reviews database performance statistics captured by Snapshots to identify potential problems before system performance degrades noticeably.
C. Automatic population of performance views (V$ views) from statistical data stored in AWR repository and using Automatic Database Diagnostic.
D. Automatic capture of statistical information from the SGA and storing it in the AWR using Automatic Database Diagnostic.
E. Automatic Application Tracing used to collect High-Load SQL statements and statistics.
F. Automatic Diagnostic Collector used to capture and store database errors and hung analysis.
A. Private database link creation requires the same user to exist in both the local and the remote databases.
B. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.
C. A database link can be created only between two Oracle databases.
D. A public database link can be created only by SYS.
E. A database link created in a database allows a connection from that database's instance to the target database's instance, but not vice versa.
A. Writing dirty database block images from the buffer cache.
B. Writing redo to log files.
C. Registering services with Oracle Net listeners.
D. Reading database blocks into the buffer cache.
E. Reading database blocks into the buffer cache.
F. Creating dedicated server connections.
A. Trace file names are based on the database name concatenated with a sequential number.
B. All trace files contain error information that requires contacting Oracle Support.
C. They can be written by server processes to a file system.
D. They can be written by background processes to a file system.
E. They can be written by server processes to the Fast Recovery Area (FRA).
A. It can be accessed only by the SYS user.
B. It can be used to display only constants or pseudo columns.
C. It can be accessed by any user who has the SELECT privilege in any schema.
D. It can display multiple rows and columns.
E. It consists of a single row and single column of VARCHAR2 data type.
F. It can display multiple rows but only a single column.
A. At the Application Root level of an Application Container.
B. At the PDB level if the policy is created by a COMMON user.
C. COMMON Unified Audit Policies can only be created at CDB level to monitor DBA operation at any level.
D. At the CDB level.
E. At any level by using the COMMON option in the policy.
A. It can run Recovery Manager (RMAN) commands.
B. It has both command-line and graphical user interfaces (GUI).
C. It can run scripts entered at the SQL prompt.
D. It has its own commands that are separate from any SQL statements.
E. It can run scripts passed to it by a shell script.
F. It must be downloaded from the Oracle Technology Network (OTN).
A. DBA_ALL_USER_EXTERNAL_TABLES
B. DBA_ALL_USER_EXTERNAL_LOCATIONS
C. DBA_ALL_USER_TABLES
D. DBA_ALL_USER_TAB_COLUMNS
