1. Home
  2. Oracle
  3. Oracle Database 19c
  4. 1z0-083
  5. Oracle Database Administration II Questions and Answers

Pass the Oracle Oracle Database 19c 1z0-083 Questions and answers with CertsForce

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 3 out of 8 pages
Viewing questions 21-30 out of questions
Questions # 21:

Choose two. Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance?

Options:
A.

The entire PGA is located in the System Global Area (SGA) when using shared servers.

B.

PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.

C.

The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.

D.

The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.

E.

Sorts and Hash Joins use PGA memory.

Expert Solution
Questions # 22:

Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE 4. PDB2 is MOUNTED. 5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. You execute these commands before upgrading the database to the current release: For which databases will fixup scripts be created?

Options:
A.

CDB1, PDB$SEED, PDB1, and PDB2

B.

PDB$SEED, PDB1, and PDB2 only

C.

CDB1 and PDB$SEED only

D.

CDB1, PDB1, and PDB2 only

E.

CDB1, PDB$SEED, and PDB1 only

Expert Solution
Questions # 23:

choose three Which three are true about RMAN duplexed backup sets or image copies?

Options:
A.

A backup set may be duplexed with both copies written to disk.

B.

An image copy on disk can be copied to disk.

C.

A backup set may be duplexed with both copies written to sbt.

D.

A backup set may be duplexed so that one copy is written to sbt and the other to disk.

E.

An image copy on disk can be copied to sbt.

F.

An image copy on sbt can be copied to disk.

Expert Solution
Questions # 24:

Choose two. Which two are true about gathering optimizer statistics?

Options:
A.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in PDB$SEED.

B.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.

C.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs).

D.

System statistics can be gathered only while the CDB is in MOUNT state.

E.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/ write mode gathers object statistics for that PDB.

Expert Solution
Questions # 25:

Choose three. Which three are true about Oracle pluggable databases (PDBs)?

Options:
A.

A PDB can be plugged into a CDB only if both are of the same Oracle Database release.

B.

An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files.

C.

A PDB unplugged from a container database (CDB) can be plugged into a different CDB without altering any of its schemas.

D.

A non-CDB can be converted into a PDB.

E.

A PDB in a remote CDB can be accessed transparently thereby aggregating results from local and remote PDBs.

F.

A PDB created from PDB$SEED must be set to READ WRITE after loading data.

G.

A PDB created from PDB$SEED must be set to READ ONLY after loading data.

Expert Solution
Questions # 26:

Which three are true about Database Point-in-Time Recovery? (Choose three.)

Options:
A.

The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.

B.

The database must be in MOUNT state when performing Database Point-in-Time Recovery.

C.

Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)

D.

The Database must be in ARCHIVE LOG mode.

E.

The target point for the recovery must be specified as a stime or System Change Number (SCN).

F.

The database must be open RESETLOGS after Database Point-in-Time Recovery.

Expert Solution
Questions # 27:

choose one You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

Options:
A.

The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

B.

The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

C.

The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

D.

The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

Expert Solution
Questions # 28:

Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

Options:
A.

Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be started and the databased be in the MOUNT state.

B.

Backing up a database in ARCHIVE LOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.

C.

An Oracle database can be restored from backup files copied using O/S utilities.

D.

Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.

E.

Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.

F.

Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.

G.

Backing up a database in ARCHIVE LOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.

Expert Solution
Questions # 29:

Choose three. Which three are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c?

Options:
A.

It can be used to deploy Grid Infrastructure homes, including Oracle Restart.

B.

It can be used to deploy Oracle Database homes.

C.

It is an Oracle Database service.

D.

It cannot be used to provision applications.

E.

It cannot be used to provision middleware.

F.

It is an Oracle Grid Infrastructure service.

Expert Solution
Questions # 30:

Examine these queries and their output: After a system crash, an instance restart and an attempted opening of the PDBs result in: Which two are true? (Choose two.)

Options:
A.

Data file 24 can be recovered while PDB2 is opened.

B.

Data file 24 must be recovered while the CDB is opened.

C.

Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.

D.

Data file 24 cannot be recovered while the CDB is opened.

E.

Data file 24 must be recovered while PDB2 is closed.

Expert Solution
Viewing page 3 out of 8 pages
Viewing questions 21-30 out of questions