Oracle Database Administration II - 1Z1-083 Exam Practice Test

A. It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated. B. It obeys all hints. C. It can re-optimize execution plans after previous executions detect suboptimal plans. D. It considers the filters in WHERE clauses when generating execution plans for SQL statements. E. It considers object statistics when generating execution plans for SQL statements. F. It updates stale object statistics in the Data Dictionary.

A. image copy duplexing B. control file auto backup formats C. archive log deletion policy D. SPFILE backup duplexing E. redo log backup duplexing F. archive log backup duplexing

A. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded. B. It fails because PDB$SEED is in MIGRATE state. C. It fails because PDB2 is not in UPGRADE state. D. Only CDB$ROOT and PDB$SEED are upgraded. E. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded. F. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.

A. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump. B. Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location. C. Create the database by using the CREATE DATABASE . . . command and manually import data by using Data Pump. D. Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.

A. It includes the Oracle Preinstallation RPM. B. From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance. C. It uses a service configuration script to create a single-instance database as part of the installation. D. It performs a software-only Oracle Database installation. E. It requires an Unbreakable Linux Network (ULN) subscription.

A. The SHARED_POOL_SIZE setting for a PDB can be up to 80%of the SHARED_POOL_SIZE setting of the root container. B. SGA_MIN_SIZE cannot be set for a PDB. C. The SGA_TARGET setting for a PDB cannot exceed 50%of the SGA_TARGET value of the root container. D. Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB. E. Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB. F. Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.

A. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output. B. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only. C. Media Management messages for SBT devices are always written to sbtio.log. D. Media Management messages for SBT devices are written to an Oracle trace file. E. RMAN error stacks should be read from the top down as that is the order in which errors are generated. F. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.

A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time. B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON. C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON. D. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time. E. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time. F. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM. B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users. C. Re-createthepasswordfileintheOracleDatabase12cformat. Correct D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No. E. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

A. Stateless alerts are automatically cleared. B. Stateless alerts can be purged manually from the alert history. C. Stateless alerts can be cleared manually. D. Stateful alerts must be created by a DBA after resolving the problem. E. Stateful alerts are purged automatically from the alert history.

A. It can be used to clone a CDB. B. It can be used to transport data from a non-CDB to a PDB. C. It can be used to transport data from a PDB to a non-CDB. D. It can be used to create a new PDB. E. It can be used to transport data between PDBs.