1Z0-052 Online Practice Questions and Answers

Which three are true about dynamic performance views? (Choose three.)

A. Read consistency is not guaranteed for these views

B. Some of them display data that is useful for SQL statement tuning

C. They display selected data from data dictionary base tables

D. They can be queried only by SYS even when the database is open

E. They contain information that is not available in data dictionary views

Which three are true about the Automatic Workload Repository (AWR)? (Choose three.)

A. It is maintained by executing the PL/SQL procedures in the DBMS_STATS package.

B. It includes statistics that contain the number of distinct values per table column.

C. It includes statistics that contain the number of rows per table.

D. AWR data is stored in the SYSAUX tablespace.

E. Automatic AWR snapshots are created by the Manageability Monitor (MMON) background process.

F. By default, AWR data is retained for eight days.

Which two are true about AWR snapshots? (Choose two.)

A. They are always created automatically.

B. They can be modified by using DMLs.

C. They are not generated if STATISTICS_LEVEL is set to TYPICAL.

D. They are stored in the SYSAUX tablespace.

E. They can be retained forever.

Which four are true about transaction, table, and row locks in an Oracle Database? (Choose four.)

A. Transaction locks are released when that transaction executes a COMMIT statement

B. DML statements lock modified tables in exclusive mode

C. Transaction locks are released when that transaction executes a ROLLBACK statement

D. DDL statements never lock the objects that they modify

E. A table's row-level locks escalate to table locks when a majority of rows in that table are locked in exclusive mode

F. SELECT statements are never blocked by row-level locks

G. DML statements lock modified rows in exclusive mode

Which three are true about the Automatic Workload Repository (AWR)? (Choose three.)

A. AWR data is stored in the SYSTEM tablespace

B. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter

C. It is the foundation for the self-managing infrastructure

D. The taking of AWR snapshots cannot be disabled

E. By default, AWR snapshots are taken every 60 minutes

Identify the memory component from which memory may be allocated for:

Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations

A. Large Pool

B. Redo Log Buffer

C. Database Buffer Cache

D. Program Global Area (PGA)

SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command?

A. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT

B. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users

C. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session

D. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully

E. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT

In which situation would you use static database registration for a listener?

A. When multiple databases are to be registered with the listener

B. When DBAs need to connect remotely to start up the database instance

C. When users need to connect the database instance using the host naming method

D. When the database instance that is to be registered with the listener is configured in shared server mode

User SCOTT executes the following command on the EMP table but has not issued COMMIT,

ROLLBACK, or any data definition language (DDL) command:

SQL> SELECT ename FROM emp

2 WHERE job='CLERK' FOR UPDATE OF empno;

SCOTT has opened another session to work with the database instance.

Which three operations would wait when issued in SCOTT's second session? (Choose three.)

A. LOCK TABLE emp IN SHARE MODE;

B. LOCK TABLE emp IN EXCLUSIVE MODE;

C. UPDATE emp SET sal=sal*1.2 WHERE job='MANAGER'

D. INSERT INTO emp(empno,ename) VALUES (1289,'Harry');

E. SELECT ename FROM emp WHERE job='CLERK' FOR UPDATE OF empno;

You suspect unauthorized data manipulation language (DML) operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. You also plan to transfer these values to another table for analysis. How would you achieve this?

A. by using triggers

B. by using Data Pump

C. by using external tables

D. by using anonymous PL/SQL blocks