1Z0-083 Exam Questions

Which three are true about Automatic Workload Repository (AWR) snapshots? (Choose three.)

Which three are true about using Database Resource Manager in an Oracle multitenant environment? (Choose three.)

You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?

Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases? (Choose three.)

Which three activities are possible for PDBs? (Choose three.)

Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege? (Choose three.)

Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose three.)

Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED...

Examine this configuration: 1. CDB1 and CDB2 are two container databases. 2. PDB1 is a pluggable database in CDB1. 3. PDB1_C1_SRV is a service for PDB1. 4. CDB1_LINK is a database...

Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an applicatio...

Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

Examine this configuration: 1. CDB1 is a container database running in ARCHIVELOG mode. 2. Multiple uncommitted transactions are running in CDB1. 3. Redo log groups 1 and 2 are INA...

Which three are true about an application container? (Choose three.)

Which three are true about the FLASHBACK DATABASE feature? (Choose three.)

Which three are true about patchsets? (Choose three.)

Which two are true about backup set compression using RMAN default compression? (Choose two.)

Which two are true about memory advisors? (Choose two.)

PDB1 and PBD2 are pluggable databases in CDB1. Examine these commands: CDB1 is then restarted. Which three are true? (Choose three.)

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)

Which two are true about Optimizer Statistics? (Choose two.)

Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)? (Choose three.)

Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PBD) starting from Oracle 19c? (Choose three.)

A schema owner truncated a table in error and must recover the data. Which Oracle Flashback feature could be used to recover the data?

A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2. You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time. Whi...

In which three situations can you use threshold server-generated alerts to help diagnose and fix problems? (Choose three.)

Which two are prerequisites for performing Flashback Transaction?

You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transaction...

Which three statements are true about Flashback Data Archive?

Examine the statements that use flashback technologies: 1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (2013-02-04 09:30:00, YYYY-MM-DD HH:MI:SS); 2. SELECT * FROM customer...

You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command. Which two statements are true about the dependent objects of the CUSTOMERS tabl...

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?

You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You...

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it h...

Which four are true about performance-related Oracle tools?

Examine these RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE...

RMAN is connected to a target database instance and an auxilary instance. You execute 3625the command: RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G...

You want to duplicate one of your databases when connected to the target database and to the recovery catalog. Which three are true about this type of database duplication?

For which two tasks can you use the DBMS_PDB.DESCRIBE procedure?

Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular b...

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

Which three are true about RMAN duplexed backup sets or image copies?

Which two statements are true about RMAN duplexed backups?

Which three RMAN persistent settings can be set explicitly?

Which three RMAN persistent settings can be set for a database?

The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL...

To schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both...

Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle. SQL> col name for a10 SQL> select name, open_mode from v$pdbs;...

You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in fu...