1Z0-083 Exam Questions

Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

A container database called CDB1 is OMF-enabled. PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will...

Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

Examine this command: $ rhpctl move database -sourcehome Oracle_home_path -destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

An Oracle Database server session has an uncommitted transaction in progress which updated 5000 rows in one table. In which two situations does the transaction complete, thereby co...

Which two statements are true about indexes and their administration in an Oracle database?

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

A user complains about poor database performance. You want to verify if the user's session has waited for certain types of I/O activity. Which view displays all waits waited on by...

Which two are true about gathering optimizer statistics? (Choose two.)

Examine this output: Which two are true? (Choose two.)

Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)

Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading perfor...

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

Examine these queries and their output: After a system crash, an instance restart and an attempted opening of the PDBs result in: Which two are true? (Choose two.)

Which two statements are true about sequences in a single instance Oracle database?

Which two are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases?

Which two are true about RMAN duplexed backup sets? (Choose two.)

Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

Which three are true about Optimizer Statistics Advisor? (Choose three.)

You issued this command: RMAN> BACKUP RECOVERY FILES; Which two are true? (Choose two.)

Which three are true about backing up the control file?

While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck. Which three are true about diagnosing an...

You are managing this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are two pluggable databases in CDB1. 3. USER1.EMP is a table in PDB1 and USER2.DEPT is a tabl...

Examine the description of the SALES table: Examine this statement: CREATE TABLE mysales (prod_id, cust_id, quantity_sold, price) AS SELECT product_id, customer_id, quantity_sold,...

Which three are true about an application container?

Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is o...

Which two are true about Oracle Flashback features? (Choose two.)

Which three are true about an application seed pluggable database (PDB)? (Choose three.)

Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. 3. PDB1 and PDB2 are OPEN in READ WRITE mode. You execute these comma...

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three...

Examine the command for creating pluggable database PDB2 in container database CDB2. Select three options, any one of which is required for it to execute successfully. (Choose thre...

Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

A database is configured in ARCHIVELOG mode. Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred. In which two scena...

Which three are true about Database Point-in-Time Recovery? (Choose three.)

RMAN has just been connected to a target database and the recovery catalog database. In which two cases would an automatic partial resynchronization occur between this target datab...

Which two are true about Oracle Grid Infrastructure for a Standalone Server?

Which three are true about the SQL Tuning Advisor? (Choose three.)

Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c? (Choose two.)

Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is C##. 3. PDB1 is a pluggable database contained in CDB1. 4. APP1_ROOT is an application contain...

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server. Examine this command and its outcome: Which two are true?...

Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

Which two are true about unplugging an application container from a container database and plugging it into a different container database?

Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Choose three.)