Skip to main content

1Z0-083 Real Exam Questions

Oracle Database Administration II

273 questions available · Page 1 of 28

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Multiple choice

Which three are true about an application seed pluggable database (PDB)? (Choose three.)

  1. A

    It is automatically synchronized with its application root PDB when an application is upgraded.

  2. B

    It cannot be added to an application container after the application container has already been created.

  3. C

    A new application PDB created by cloning an application seed PDB can have an old version of the
    application installed after cloning completes.

  4. D

    It is automatically synchronized with its application root PDB when an application is installed.

  5. E

    It cannot be dropped from its application container.

  6. F

    A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.

  7. G

    It is not required in an application container.

Show answer and explanation

Correct answers: C, F, G

Explanation

https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/creating-removing-application-containers-seeds-with-sql-plus.html#GUID-065649AC-18ED-4858-ACC5-36F011362A83

Question 2 Multiple choice

Which three are true about Oracle Restart? (Choose three).

  1. A

    It can be configured to automatically attempt to restart various components after a hardware or software failure.

  2. B

    While starting any components, it automatically attempts to start all dependencies first and in proper order.

  3. C

    It runs from the Oracle Grid Infrastructure home.

  4. D

    If you shut down a database instance with SQL*Plus, Oracle Restart interprets this as a database failure and attempts to restart the instance.

  5. E

    The Server Control (SRVCTL) utility can be used to start and stop Oracle Restart.

  6. F

    It runs periodic check operations to monitor the health of Oracle components.

Show answer and explanation

Correct answers: A, B, F

Question 3 Multiple choice

Which three are true? (Choose three.)

  1. A

    Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

  2. B

    Application-common TSDP policies are always container specific.

  3. C

    Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.

  4. D

    Application-common Oracle Label Security (OLS) policies cannot be created in an application root

    outside an install/patch BEGIN-END block.

  5. E

    Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

  6. F

    Application-common OLS policies can be created in an application root inside an install/patch BEGIN-
    END block.

  7. G

    Unified auditing can be automatically synchronized to all application PDBs in an application container.

Show answer and explanation

Correct answers: D, E, G

Question 4 Multiple choice

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

  1. A

    Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers
    object statistics in all open PDBs except PDB$SEED.

  2. B

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

  3. C

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

  4. D

    System statistics can be gathered only while connected to CDB$ROOT.

  5. E

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

Show answer and explanation

Correct answers: B, C

Explanation
BC test:
SQL> select count(*) from sys.dba_tab_statistics where last_analyzed is not null;
COUNT(*)
----------3610 SQL> EXEC DBMS_STATS.GATHER_DATABASE_STATS;
PL/SQL procedure successfully completed.
SQL> select count(*) from sys.dba_tab_statistics where last_analyzed is not null;
COUNT(*)
----------3649 SQL> alter session set container=ORCLPDB1;
Session altered.
SQL> select count(*) from sys.dba_tab_statistics where last_analyzed is not null;
COUNT(*)
----------3507 SQL> EXEC DBMS_STATS.GATHER_DATABASE_STATS;
PL/SQL procedure successfully completed.
SQL> select count(*) from sys.dba_tab_statistics where last_analyzed is not null;
COUNT(*)
----------
Question 5 Multiple choice

In which three situations can you use threshold server-generated alerts to help diagnose and fix problems? (Choose two).

  1. A

    when free space in a dictionary managed tablespace falls below a specified percentage

  2. B

    when free space in a locally managed tablespace falls below a specified percentage

  3. C

    when the total number of locked user account exceeds a specific value

  4. D

    when the number of logons per second exceeds a specific value

  5. E

    when a resumable statement is suspended

  6. F

    when the total number of logons exceeds a specific value

Show answer and explanation

Correct answers: A, B, F

Question 6 Multiple choice

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

  1. A

    A PDB snapshot can be a sparse copy of a source PDB.

  2. B

    A PDB snapshot depends on an existing storage snapshot of the source PDB.

  3. C

    A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.

  4. D

    A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.

  5. E

    A PDB snapshot can be a full copy of a source PDB.

  6. F

    A snapshot copy PDB can be a full copy of a source PDB.

  7. G

    A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

Show answer and explanation

Correct answers: A, D, E

Explanation

References:
https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-05702CEB-A43C-452C-8081-4CA68DDA8007

Question 7 Multiple choice

Which two are true about RMAN virtual private catalogs (VPCs)? (Choose two.)

  1. A

    RMAN uses Oracle Virtual Private Database (VPD) to implement VPCs

  2. B

    Each VPC is owned by the recovery catalog schema owner

  3. C

    VPC functionality is enabled by default

  4. D

    The RMAN catalog owner can grant access for an already registered database to a new virtual catalog owner

  5. E

    Only one target database can be registered in a VPC

Show answer and explanation

Correct answers: A, D

Explanation

A:
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery-catalog.html#GUID-DA362C55-5B94-4AB8-A8A1-163BF08FE594
D:
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery-catalog.html#GUID-3910031C-2CEE-4A19-B96B-9281C57D2B5B

Question 8 Single choice

On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days.

Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0 backups.

Today is the 26th of August.

Which backups will be obsolete?

  1. A

    all backups prior to 10th of August

  2. B

    all backups prior to 22nd of August

  3. C

    all backups prior to 24th of August

  4. D

    all backups prior to 20th of August

  5. E

    all backups prior to 17th of August

Show answer and explanation

Correct answer: A

Question 9 Single choice

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.

Which method or feature should you use?

  1. A

    Compare Period ADDM report

  2. B

    AWR Compare Period report

  3. C

    Active Session History (ASH) report

  4. D

    Taking a new snapshot and comparing it with a preserved snapshot.

Show answer and explanation

Correct answer: A

Explanation

Comparing Current System Performance to a Baseline Period
You may have noticed a performance change on a production system and would like to know why, or you may have implemented a change to a production system and want to know the effect of the change, such as increased concurrency waits.

The Compare Period ADDM compares the performance of the database server in two time periods, and returns a report describing the performance changes and the root origin of the changes.
https://docs.oracle.com/database/121/TDPPT/tdppt_degrade.htm#TDPPT525

Question 10 Multiple choice

You take your database backups by using the RMAN media management interface (MMI).

Which two are true about the use of the RMAN MMI? (Choose two.)

  1. A

    You can use it to create image copies for entire file systems.

  2. B

    You can use it to create image copies for database files.

  3. C

    You can use it to create backup sets for database files.

  4. D

    You can use it to create proxy copies for database files.

  5. E

    You can use it to create proxy copies for entire file systems.

Show answer and explanation

Correct answers: B, C