1Z0-083 Online Practice Questions and Answers

Automatic Shared Memory Management is disabled for one of your database instances.

Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.

What would be your next step?

A. Run the SQL Access Advisor.

B. Run the Memory Advisor for the shared pool.

C. Run the SQL Tunning Advisor.

D. Run the Memory Advisor for the Program Global Area.

E. Run the Memory Advisor for the System Global Area.

Which three are true about Optimizer Statistics Advisor? (Choose three.)

A. It can be run only manually.

B. It is part of the DBMS_ADVISOR package.

C. It can recommend changes to improve the statistics gathering process.

D. It always analyzes all schemas in the database.

E. It runs automatically every night by default.

F. It is part of the DBMS_STATS package.

Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

A. Media Management messages for SBT devices are always written to sbtio.log.

B. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.

C. RMAN error stacks should be read from the top down as that is the order in which errors are generated.

D. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.

E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.

F. Media Management messages for SBT devices are written to an Oracle trace file.

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

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 ARCHIVELOG 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.

Examine these RMAN commands:

RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP";

RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";

RMAN> DUPLICATE TARGET DATABASE TO dup_db

FROM ACTIVE DATABASE

PASSWORD FILE

SECTION SIZE 400M;

Which statement is true about the DUPLICATE command?

A. It succeeds.

B. It fails because no parallel channels are allocated for the auxiliary database.

C. It fails because connection to the AUXILIARY instance must be as SYSDBA.

D. It succeeds only if the target database is greater than 400M.

E. No catalogued backup of the TARGET is used to duplicate the database.

Examine the RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M;

Which statement is true about the DUPLICATE command?

A. It succeeds and creates multisection backup sets that are used for active database duplication.

B. It fails because there is no connection to a recovery catalog.

C. It succeeds only if the target database is in MOUNT state.

D. It fails because no parallel channels are allocated for the auxiliary database.

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? (Choose two).

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

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

B. In a PDB plan, subplans may be used with up to eight consumer groups.

C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Which three statements are true about Flashback Database?

A. Flashback logs are written sequentially, and are archived.

B. Flashback Database uses a restored control file to recover a database.

C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

D. Flashback Database can recover a database to the state that it was in before a reset logs operation.

E. Flashback Database can recover a data file that was dropped during the span of time of the flashback.

F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

A. It is a set of recommendations by the optimizer to create new indexes.

B. It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.

C. It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.

D. It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.

E. It is a set of recommendations by the optimizer to change the access methods used.