Free Oracle 1Z0-083 Exam Dumps Questions & Answers

Which three are true in Oracle 19c and later releases? (Choose three.)

• A.  Tablespaces never remain in read/write mode during transportable tablespace operations.
• B.  An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.
• C.  Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.
• D.  A transportable data pump import can leave a plugged-in tablespace in read-only mode.
• E.  A transportable data pump import can leave a plugged-in tablespace in read/write mode.
• F.  Tablespaces always remain in read/write mode during transportable tablespace operations.

Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases? (Choose two.)

• A.  It can only install and configure Oracle Database software. The database has to be created separately.
• B.  It can be used for both Oracle Database and Oracle Grid Infrastructure installation.
• C.  It uses a single RPM that automatically extracts and installs the Oracle Database software.
• D.  It does not require the setup wizard.
• E.  It can be used to install and upgrade Oracle Database for single-instance and cluster configurations.

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

• A.  It updates the alert log with the location and contents of the control file
• B.  It creates a file that contains RMAN scripts to create a duplicate database.
• C.  It creates a file that contains SQL statements to re-create the control file.
• D.  It creates a copy of the control file in the fast recovery area (FRA).
• E.  It creates a binary backup of the control file.

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;
NAME OPEN_MODE
---------------------------------------
PDB$SEED READ ONLY
PDB1 READ WRITE PDB2 MOUNTED
SQL> exit
Next you execute: $ expdp system/oracle full=y
What is the outcome?

• A.  It creates a full export of only the used while connected to the root container and PDB1.
• B.  It creates a full export of the root container and all PDBs.
• C.  It creates a full export of the root container and all open PDBs.
• D.  It fails because Data Pump cannot be container.

Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

• A.  when you perform active database duplication on a database that has readonly tablespaces
• B.  when the number of auxiliary channels allocated is equal to or greater than the number of target channels
• C.  when you perform active database duplication on a database with flashback disabled
• D.  when the duplicate ... from active database command contains the section size clause
• E.  when you specify set encryption before the duplicate ... from active database command