1Z0-083 Practice Questions

Question 1

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 link in CDB2 referring to PDB1.

5. CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service.

You execute these commands successfully:

$ sqlplus sys/oracle_4U@cdb2 as sysdba

SQL> CREATE PLUGGABLE DATABASE PDB1

FROM PDB1@CDB1_LINK

SERVICE_NAME_CONVERT=('PDB1_C1_SRV','PDB1_C2_SRV');

Which two are true? (Choose two.)

Answer Options

APDB1 will be created in CDB2 and automatically opened.

BPDB1 will be created in CDB2 and left in MOUNT state.

CPDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.

DPDB1_C2_SRV will be created and started automatically.

EPDB1_C2_SRV will be created but not started.

Correct Answer: A, C

Accepted Answer

PDB1 will be created in CDB2 and automatically opened.

Accepted Answer

PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.

Answer

PDB1 will be created in CDB2 and left in MOUNT state.

Answer

PDB1_C2_SRV will be created and started automatically.

Answer

PDB1_C2_SRV will be created but not started.

Question 2

Which three are true In Oracle 19c and later releases?

Accepted Answer

Tablespaces always remain In read/write mode during transportable tablespace operations.

Accepted Answer

An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

Accepted Answer

A transportable data pump import can leave a plugged-in tablespace in read-only mode.

Answer

Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.

Answer

Tablespaces never remain In read/write mode during transportable tablespace operations.

Answer

A transportable data pump import can leave a plugged-in tablespace In read/write mode.

Question 3

Which three are true about Audit policies In container databases (CDBs)?

Accepted Answer

An application PDB cannot have a local audit policy.

Accepted Answer

Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.

Accepted Answer

Application-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.

Answer

All audit records are written to the audit trail in CDB$ROOT

Answer

A common unified audit policy can be created at the application root level.

Answer

A common unified audit policy can be created at the CDB level.

Question 4

Which three true about recovering tables using RMAN? (Choose three.)

Accepted Answer

RMAN can recover tables in the SYSAUX tablespace.

Accepted Answer

RMAN can recover tables in the SYSTEM tablespace.

Accepted Answer

RMAN always uses an auxiliary instance.

Answer

RMAN can recover tables owned by the SYS user.

Answer

RMAN can recover tables in a standby database.

Answer

RMAN can recover a table after a DDL operation has altered the table structure.

Answer

RMAN can recover tables owed by the SYSTEM user.

Question 5

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

Accepted Answer

FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.

Accepted Answer

FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

Accepted Answer

FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

Answer

FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.

Answer

FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

Answer

FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.

Free Oracle 1Z0-083 Exam Practice Questions & Explanations