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

Question No: 1

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: 2

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: 3

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: 4

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: 5

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: 6

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: 7

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: 8

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.

Question No: 9

MultipleChoice

T 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 the databases are open. You execute the RMAN commands: RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c RMAN> IMPORT CATALOG rcll/pwdcatll@ractll Which two tasks are performed as part of the import?

Options

ADatabases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.

BRecovery catalog is resynchronized with the control files of the registered databases.

CImported databases are unregistered from the RC11 catalog.

DLocal and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

EAll databases registered in the RC11 catalog are registered in the RC12C catalog.

Question No: 10

MultipleChoice

Which two are true about the automatic execution of operating system scripts when performing silent mode

installation starting from Oracle Database 19c? (Choose two.)

Options

AThe response file can specify the root or sudo password.

BThe installer will prompt for the root or sudo password.

CSilent install always runs operating scripts automatically.

DThe response file must contain the root or sudo password.

EThe response file can specify the path of the sudo program.