1Z0-083試験無料問題集「Oracle Database Administration II 認定」

A. By default, they are automatically gathered by a maintenance job.

B. They provide real-time data about schema objects.

C. They are gathered by the SQL Tuning Advisor.

D. They are ignored by Optimizer if they are stale.

E. They can be gathered by the DBMS_STATS package.

A. It can be used to patch Grid Infrastructure homes containing Oracle Restart.

B. It cannot be used to upgrade Oracle Database homes.

C. It can be used to provision middleware.

D. It is an Oracle Database service

E. It can be used to provision applications.

A. A new DBID is automatically created for the transported database.

B. The password file is automatically converted by RMAN.

C. Data files can be converted on the destination system.

D. Data files can be converted on the source system.

E. By default, the transported database will use Oracle Managed Files (OMF)

F. Databases can be transported between systems with different endian formats.

A. the number of data files containing extents belonging to tables updated by a transaction

B. issuing multiple savepoints during a transaction

C. poorly trained users who do not commit transactions

D. poorly written SQL

E. the number of tablespaces containing tables updated by a transaction

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

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

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. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.

A. It requires system statistics when generating SQL execution plans.

B. It always generates an index access operation when a statement filters on an indexed column with an equality operator.

C. It can re-write a statement internally in order to generate a more optimal plan.

D. It ignores stale object statistics in the Data Dictionary.

E. It can automatically re-optimize execution plans that were detected to be sub-optimal when executing.

A. It creates a full export of only the used while connected to the root container and PDB1.

B. It creates a full export of the root container and all open PDBs.

C. It fails because Data Pump cannot be container.

D. It creates a full export of the root container and all PDBs.

A. It creates a copy of the control file in the fast recovery area (FRA).

B. It creates a file that contains RMAN scripts to create a duplicate database.

C. It creates a binary backup of the control file.

D. It creates a file that contains SQL statements to re-create the control file.

E. It updates the alert log with the location and contents of the control file

A. 1, 3, 5, 6, 9

B. 1, 3, 5, 6, 10

C. 1, 3, 5, 8, 6, 10

D. 1, 2, 5, 7, 4, 10

E. 1, 3, 5, 7, 10

A. It enables a keystore to be stored only in a file on a file system.

B. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

C. It facilitates and helps to enforce keystore backup requirements.

D. It enables separation of duties between the database administrator and the security administrator.

E. It transparently decrypts data for the database users and applications that access this data.

F. It handles encrypted data without modifying applications.

A. They can be retained forever.

B. They are always created manually.

C. They are always created automatically.

D. They are generated if STATISTICS_LEVEL is set to ALL.

E. They are generated if STATISTICS_LEVEL is set to TYPICAL.

F. They are generated if STATISTICS_LEVEL is set to BASIC.

A. It is enabled for all users having SELECT privilege on SH.SALES.

B. It is only enabled for user SH.

C. Audit records are always stored in an external audit file.

D. Only successful queries of SH.SALES are written to the audit trail.

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

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

C. Data file 24 must be recovered while PDB2 is closed.

D. Data file 24 can be recovered while PDB2 is opened.

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

A. Audit records are created for non-sys users.

B. Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.

C. Audit records are created for SYS.

D. The unified audit trail is written to a read-only external file.

E. The unified audit trail is written to a read-only table.