oracle 1z0-083 practice test

Oracle Database Administration II Exam

Last exam update: Aug 27 ,2025
Page 1 out of 19. Viewing questions 1-15 out of 282

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)
Mark Question:
Answer:

A, C, F


Explanation:

User Votes:
A 7 votes
50%
B 1 votes
50%
C 8 votes
50%
D 2 votes
50%
E 4 votes
50%
F 8 votes
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

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
Mark Question:
Answer:

A, B


User Votes:
A 8 votes
50%
B 7 votes
50%
C 3 votes
50%
D 3 votes
50%
E 1 votes
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

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.
  • 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.
Mark Question:
Answer:

B, C, D


User Votes:
A 3 votes
50%
B 8 votes
50%
C 7 votes
50%
D 6 votes
50%
E 1 votes
50%
F 1 votes
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000
jxh
1 month, 2 weeks ago

Automatic Storage Management (ASM requires that ars groups OSASM and OSDBA be assigned assecondary groups for its installation owner.

0

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.
Mark Question:
Answer:

B, E


User Votes:
A 2 votes
50%
B 6 votes
50%
C 2 votes
50%
D
50%
E 5 votes
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

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).
Mark Question:
Answer:

C


User Votes:
A 1 votes
50%
B 3 votes
50%
C 7 votes
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000
ace03
1 year, 2 months ago

The ALTER DATABASE BACKUP CONTROLFILE TO TRACE command is one way to back up the control file. It produces a SQL script that you can use to re-create the database control file in case all multiplexed binary versions of the control file are lost due to a catastrophic failure.

0

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
  • 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
Mark Question:
Answer:

A, E


User Votes:
A 5 votes
50%
B 1 votes
50%
C 2 votes
50%
D 2 votes
50%
E 7 votes
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

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.
Mark Question:
Answer:

B, D, E


User Votes:
A 4 votes
50%
B 3 votes
50%
C 4 votes
50%
D 5 votes
50%
E 4 votes
50%
F
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

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.
Mark Question:
Answer:

C, D, F


User Votes:
A
50%
B 2 votes
50%
C 7 votes
50%
D 6 votes
50%
E 3 votes
50%
F 5 votes
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

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?

  • A. seven
  • B. five
  • C. eight
  • D. three
  • E. six
Mark Question:
Answer:

A


User Votes:
A 4 votes
50%
B 1 votes
50%
C 6 votes
50%
D 2 votes
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000
ace03
1 year, 2 months ago

The right answer is C. eight

1
kirion
9 months ago

The right answer is A. seven

Explanation:
In a multitenant container database (CDB) with pluggable databases (PDBs), each container can have its own default temporary tablespace. Here's the breakdown:

CDB$ROOT: The root container has one default temporary tablespace.
PDB$SEED: The seed PDB has its own default temporary tablespace.
Two regular PDBs: Each regular PDB has its own default temporary tablespace (2 total).
Application Root: The application root container has its own default temporary tablespace.
Two application PDBs: Each application PDB can have its own default temporary tablespace (2 total).
Application Seed: The application seed has its own default temporary tablespace.
Adding these together:

CDB$ROOT = 1
PDB$SEED = 1
Regular PDBs = 2
Application Root = 1
Application PDBs = 2
Total = 7

0

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
Mark Question:
Answer:

B, D


User Votes:
A 3 votes
50%
B 7 votes
50%
C 1 votes
50%
D 3 votes
50%
E
50%
F 1 votes
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 11

Choose three. Which three actions are mandatory post database upgrade?

  • A. Updating client scripts with the new Oracle home.
  • B. Resetting passwords to enforce case-sensitivity.
  • C. Run OPatch commands from the new Oracle home.
  • D. Setting threshold values for tablespace alerts.
  • E. Migration to unified auditing.
  • F. Upgrading user tables that depend on Oracle-maintained abstract data types.
Mark Question:
Answer:

A, C, F


User Votes:
A 4 votes
50%
B 4 votes
50%
C 4 votes
50%
D
50%
E 3 votes
50%
F 5 votes
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000
kirion
9 months ago

Correct Answers:
A. Updating client scripts with the new Oracle home.

After upgrading a database, client scripts that reference the Oracle home directory must be updated to point to the new Oracle home to ensure compatibility.
F. Upgrading user tables that depend on Oracle-maintained abstract data types.

If user tables rely on Oracle-maintained abstract data types (such as XMLType or Spatial data types), they must be upgraded to remain consistent with the new database version.
B. Resetting passwords to enforce case-sensitivity.

Starting with Oracle 12c, password case-sensitivity is enabled by default. After an upgrade, passwords may need to be reset to comply with this requirement if they were created in a version without enforced case-sensitivity.

0

Question 12

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

  • A. A table's constraints must be disabled before issuing the flashback.
  • B. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.
  • C. Row Movement must be enabled on the table being flashed back.
  • D. A table's indexes must be set to unusable before issuing the flashback.
  • E. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.
Mark Question:
Answer:

B, C


User Votes:
A
50%
B 6 votes
50%
C 5 votes
50%
D 1 votes
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 13

Choose three. Which three are true about a container database (CDB)?

  • A. It can be created from a non-CDB.
  • B. It can contain only one PDB$SEED, which is created when the CDB is created.
  • C. It can have local users with the same name in different PDBs.
  • D. It can contain only one Application Container seed, which is created when the Application Container is created.
  • E. It can be created by cloning an existing CDB.
  • F. It can have any number of pluggable databases (PDBs) limited only by space availability.
  • G. It contains predefined common roles in both the root and the seed.
Mark Question:
Answer:

B, E, G


User Votes:
A 1 votes
50%
B 6 votes
50%
C 4 votes
50%
D 2 votes
50%
E 3 votes
50%
F 1 votes
50%
G 3 votes
50%
Discussions
vote your answer:
A
B
C
D
E
F
G
0 / 1000

Question 14

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

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

C, E


User Votes:
A
50%
B 2 votes
50%
C 5 votes
50%
D 1 votes
50%
E 4 votes
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 15

Choose two. Which two are true about an RPM-based Oracle Database installation?

  • A. It includes the Oracle Preinstallation RPM.
  • B. From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.
  • C. It requires an Unbreakable Linux Network (ULN) subscription.
  • D. It performs a software-only Oracle Database installation.
  • E. It uses a service configuration script to create a single-instance database as part of the installation.
Mark Question:
Answer:

B, D


User Votes:
A 1 votes
50%
B 4 votes
50%
C
50%
D 4 votes
50%
E 1 votes
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000
To page 2