Oracle Database 11g: Administration I - 1Z0-052 Exam Practice Test

Question 1

In which three situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose three.)

A. If a table has an encrypted column

B. If a table is not in a cluster

C. If a table has a VARCHAR2 column in it

D. If a table has a referential integrity constraint defined on it

E. If a table has an active trigger

Correct Answer: A,D,E

Question 2

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

A. AWR data is stored in the SYSAUX tablespace.

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. By default, AWR data is retained for eight days.

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

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

Correct Answer: A,D,E

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered.
Which two statements are true regarding the MRKT tablespace? (Choose two.)

A. A user created without being assigned a default tablespace uses this tablespace.

B. The tablespace can be dropped with the current setting with segments present in it.

C. No more data files can be added to the tablespace.

D. Segment space is managed by free lists in the tablespace.

Correct Answer: A,C

Question 4

Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true in this scenario?

A. The minimum memory size allocated for a server process in the database buffer cache in dedicated mode is set to 100 MB.

B. The minimum memory size for the database buffer cache is set to 100 MB.

C. The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100 MB.

D. The maximum memory size from the database buffer cache that can be released for dynamic distribution during ASMM is set to 100 MB.

Correct Answer: B

Question 5

The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:
SQL> INSERT INTO cust VALUES(101, 'JACK');
1 row created.
SQL> INSERT INTO cust VALUES(102, 'SMITH');
1 row created.
As a DBA, you execute the following command from another session:
ALTER TABLESPACE sales READ ONLY;
Which statement is true regarding the effect of this command on the transaction in Scott's session?

A. The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.

B. The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.

C. The transaction in Scott's session is rolled back and the tablespace becomes readonly.

D. The command fails as a transaction is still pending.

Correct Answer: B

Question 6

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 session of any other user in which a table owned by SCOTT is dropped successfully

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

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

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

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

Correct Answer: D

Question 7

Given below is a list of scenarios:
1. A user terminates his session abnormally.
2. The connection between the server and the client application terminates because of a network failure.
3 . A schema is accidentally dropped.
4 . The tablespace is accidentally dropped from the database.
5 . The hard disk gets corrupted and the data files in the disk are lost.
6 . The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery?

A. 1, 2, and 6

B. 3, 4, and 5

C. 1, 3, and 6

D. 4, 5, and 6

Correct Answer: B

Question 8

Which command is used to display files that no longer conform to the backup retention policy?

A. LIST EXPIRED BACKUP

B. REPORT OBSOLETE

C. SHOW DATAFILE BACKUP COPIES

D. CROSSCHECK BACKUP

Correct Answer: C

Question 9

Which two are true about external tables? (Choose two.)

A. They have extents

B. They can always be updated using SQL

C. They support the ORACLE_DATAPUMP access driver.

D. They can be stored in Oracle Automatic Storage Management File System (Oracle ACFS)

E. They support all DML operations.

Correct Answer: B,C

Oracle Database 11g: Administration I - 1Z0-052 Exam Practice Test

Latest Update

Useful Links

Contact Us