oracle 1z0-083 practice test

Question 1

Choose three. Which three actions will add a resource to an Oracle Restart configuration?

• A. creating a disk group using the CREATE DISKGROUP SQL statement
• B. creating a database service using DBMS_SERVICE.CREATE_SERVICE
• C. creating a database service using Oracle Database Configuration Assistant (DBCA)
• D. creating a database using the CREATE DATABASE SQL statement
• E. creating an Oracle Database service by modifying the SERVICE_NAMES parameter
• F. creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)

Answer:

A, C, F

Explanation:
101/101

Question 2

Choose two. You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle
Universal Installer (OUI). There is no existing Oracle installation on the server. Which two are
prerequisites?

• A. an operating system user to own this installation
• B. the Oracle Inventory group oinstall
• C. an operating system account called grid
• D. a group called dba
• E. the installation of Oracle ASMLIB

Answer:

A, B

Question 3

Which three are true about Oracle Grid Infrastructure for a Standalone Server?

• A. It requires Oracle ASMLib to manage Automatic Storage Managerment (ASMl) disks.
• B. It creates one disk group during installation. 100/101 Questions & Answers PDF P-
• C. It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.
• D. Automatic Storage Management (ASM requires that ars groups OSASM and OSDBA be assigned assecondary groups for its installation owner.
• E. It requires the operating system ORACLE_BASDE environment variable to be predefined before installation.
• F. It requires Oracle ASM Filter Drver (ASMFD) to manage Automatic Storage Managemernt (AsM) disks.

Answer:

B, C, D

Question 4

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and
no application seed have yet been created in HR_ROOT. An application PDB, PDB1,must be created
so that the HR_APP application's common objects are accessible to it. Which two methods can be
used?

• A. Create the PDB1 application PDB and synchronize it with poB$SEED.
• B. Create the PDB1 application PDB and synchronize it with HR_ROOT.
• C. Create the PDB1 application PDB and install HR_APP in it.
• D. Create an application seed, and install HR_APP in it.
• E. Create an application seed, synchronize it with HR_ROOT, and then create the PDB1.application PDB.

Answer:

B, E

Question 5

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

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

Answer:

C

Question 6

Choose two. For which two tasks can you use the DBMS_PDB.DESCRIBE procedure?

• A. to generate an XML metadata file that describes a non-CDB Oracle 12c database so that it can be plugged in as a PDB 99/101
• B. to generate an XML metadata file from any unplugged PDB
• C. to determine whether an XML file describes a PDB that can be plugged into the CDB in which you run the procedure
• D. to generate a . pdb archive file for any PDB in the current CDB
• E. to generate an XML metadata file that describes the current plugged-in PDB

Answer:

A, E

Question 7

Choose three. Which three are true about Audit policies in container databases (CDBs)?

• A. All audit records are written to the audit trail in CDB$ROOT .
• B. Application-common unified audit policies defined in an application root must be manually synchronized by each application PDB contained in the application root.
• C. Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.
• D. A common unified audit policy can be created at the CDB level.
• E. A common unified audit policy can be created at the application root level.
• F. An application PDB cannot have a local audit policy.

Answer:

B, D, E

Question 8

Choose three. Which three are true about backing up the control file?

• A. It cannot be backed up manually as a binary copy.
• B. It gets backed up automatically by RMAN as a trace file containing SQL statements for control file recreation when a database backup occurs.
• C. It can be backed up manually as a binary copy.
• D. It can get backed up automatically as a binary copy.
• E. It gets backed up automatically by RMAN when the BACKUP SPFILE command is used.
• F. It can be backed up manually as a trace file containing SQL statements for control file recreation.

Answer:

C, D, F

Question 9

Choose the best answer. 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?
98/101

• A. seven
• B. five
• C. eight
• D. three
• E. six

Answer:

A

Question 10

Choose two. Some archived log backups have been accidentally deleted from storage. Which two
commands should be used to update the status of backups in the recovery catalog to display only the
missing backups?

• A. RESYNC CATALOG
• B. CROSSCHECK BACKUP OF ARCHIVELOG ALL
• C. LIST ARCHIVELOG ALL
• D. LIST EXPIRED
• E. LIST ARCHIVELOG
• F. REPORT OBSOLETE

Answer:

B, D