1Z0-083 Exam Questions

Which two are true about the Oracle database methodology? (Choose two.)

Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5; Which two statements are true about the DUPLICATE command?

RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database: RMAN> DUPLICATE TARGET DATABASE TO du...

Which two are prerequisites for creating a backup-based duplicate database?

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recove...

You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

Which two statements are true about the Database Configuration Assistant (DBCA)?

You plan to create a database by using the Database Configuration Assistant (DBCA), with t he following specifications: Applications will connect to the database via a middle tier....

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

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

Which three statements are true about Automatic Workload Repository (AWR)?

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with f...

Which two statements are true about encrypted backups performed by using RMAN?

Which three are true about Transparent Data Encryption (TDE)?

Which two are true about RMAN image copies?

Examine the RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?

Which three statements are true about the keystore storage framework for transparent data encryption?

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command: SQL>CREATE AUDIT POLICY table_aud PR...

In one of your databases, unified auditing is enabled and an SH.SALES table exists. You successfully execute these commands: SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh...

Which three are true about unified auditing in full mode?

Which two are benefits of unified auditing in full mode?

Identify three benefits of Unified Auditing.

Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)

In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?

Which two are true about a read-only Oracle home?

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

Which two are true about the Optimizer Statistics Advisor?

Which two are true in Oracle 19c and later releases?

Which two are true about monitoring waits for sessions and services?

Which two are true about various Oracle security and auditing capabilities?

Which two are true about the SQL Tuning Advisor?

Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

You plan to perform cross-platform PDB transport using XTTS. Which two are true?

Which three are true about OPatch?

Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)?

You are working on an Oracle Database 19c database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.)

You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which t...

Which three statements are true about Flashback Database?

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

Which two statements are true when row archival management is enabled?

Which two statements are true when row-archival management is enabled?

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using infor...

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: create table employees (empno...

After implementing full Oracle Data Redaction, you change the default value for the number data type as follows: SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBE...

You execute the following piece of code with appropriate privileges: User SCOTT has been granted the CREATE SESSION privilege and the MGR role. Which two statements are true when a...

A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?...

Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice. SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; SQL> SELECT ENAME, SAL, C...

You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privil...