Free Oracle 1Z0-083 Exam Dumps and 1Z0-083 Exam Questions

Question No: 1

MultipleChoice

You want to transport the UNIVERSITY tablespace from one database to another.

The UNIVERSITY tablespace is currently open read/write.

The source and destination platforms have the same endian format.

Examine this list of steps:

1. Make the UNIVERSITY tablespace read-only on the source system.

2. Export the UNIVERSITY tablespace metadata using EXPDP.

3. Create a cross-platform backup set from the UNIVERSITY tablespace on the source system, using an

RMAN command that includes the DATAPUMP clause.

4. Copy the cross-platform backup sets to the destination system.

5. Copy the Data Pump dump set from the source to the destination system.

6. Restore the cross-platform backup set on the destination system using an RMAN command that includes

the DATAPUMP clause.

7. Import the UNIVERSITY tablespace metadata using IMPDP.

8. Make the UNIVERSITY tablespace read/write on the destination system.

Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY

tablespace?

Options

A1, 3, 4, 6, 8

B3, 4, 6

C1, 2, 3, 4, 5, 6, 7, 8

D2, 3, 4, 5, 6, 7

Question No: 2

MultipleChoice

Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)

Options

AA table's constraints must be disabled before issuing the flashback.

BThe FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the
user performing the flashback.

CA table's indexes must be set to unusable before issuing the flashback.

DRow Movement must be enabled on the table being flashed back.

EThe FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the
table owner.

Question No: 3

MultipleChoice

Which two are true about RMAN Multisection backups when a very large data file is divided into four sections?

(Choose two.)

Options

AEach of the file sections must be processed serially.

BThe four sections can be created serially.

CThe four sections must be image copies.

DThe four sections can be created in parallel.

EThe four sections must be contained in backup sets.

Question No: 4

MultipleChoice

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of

the SALES_APP application.

Examine these steps:

1. Install the SALES_APP application, including the common tables, in the application root.

2. Install the SALES_APP application in the application root and the common tables in both the CDB root and

the application root.

3. Create an application seed.

4. Install the SALES_APP application in the application seed.

5. Create the SALES_APP1 and SALES_APP2 application PDBs.

6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.

7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.

8. Sync the application seed with the application root.

Which are the minimum required steps in the correct sequence?

Options

A3, 4, 1, 6, 8

B2, 5, 6

C1, 5, 6

D1, 3, 5, 6, 7

E1, 3, 5, 7

Question No: 5

MultipleChoice

Your CDB has two regular PDBs as well as one application container with two application PDBs and an

application seed.

No changes have been made to the standard PDB$SEED.

How many default temporary tablespaces can be assigned in the CDB?

Options

Asix

Bseven

Cfive

Deight

Ethree

Question No: 6

MultipleChoice

Which three are performed by Oracle Automatic Storage Management (ASM) instances? (Choose three.)

Options

Amounting disk groups

Bmanaging Allocation Units (AUs) for disk group content

Cmanaging extent allocation for Oracle database segments

Dacting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes
(DBWn)

Emanaging space allocation for Oracle ASM files

Facting as an I/O server to read data file blocks from ASM disks on behalf of database server processes

Question No: 7

MultipleChoice

Which two are true about Oracle Database Configuration Assistant (DBCA)? (Choose two.)

Options

AIt can be launched from both the command line and the Universal Installer (OUI) interfaces.

BIt can be used to change the character set of an existing database.

CIt can be used to convert a non-container database to a container database.

DIt can be used to create container databases and non-container databases.

EIt can only be launched from the command line interface.

Question No: 8

MultipleChoice

Which two are true about Rapid Home Provisioning of Oracle software? (Choose two.)

Options

AIt can be used for applications and middleware.

BIt can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.

CIt can be used only for Oracle Grid Infrastructure, including Oracle Restart.

DIt can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.

EIt can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.
Reference https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwadd/rapid-homeprovisioning.
html#GUID-CCEC5960-EDA4-4A3F-9643-0CA308EA49AA

Question No: 9

MultipleChoice

Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?

(Choose two.)

Options

ASQL statements performing many physical I/Os can always have their performance improved by creating
indexes.

BSQL statements doing only logical reads never require tuning because they do no physical I/O.

CThe solution that best optimizes one SQL statement can degrade the performance of others.

DSQL statements doing joins always do more physical I/O than single table queries.

EPoorly performing SQL statements can be tuned automatically by the Oracle server.

Question No: 10

MultipleChoice

The HR_ROOT application container must support the execution of a query on a table shared by application

local PDBs PDB1 and PDB2, and remote PDB PDB3.

Which three are true? (Choose three.)

Options

AA proxy PDB must exist in the application root in the remote CDB.

BA database link must exist in the local CDB root referring to the remote CDB.

CPDB3's application root replica must exist in the local CDB.

DA database link must exist in the remote CDB referring to the local CDB.

EThe HR_ROOT replica must exist in the remote CDB.

FA proxy PDB must exist in the application root in the local CDB.