Oracle Database 11g: Administration I (1Z0-052) Free Practice Test

Question 1

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 maximum memory size from the database buffer cache that can be released for dynamic distribution during ASMM 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 minimum memory size allocated for a server process in the database buffer cache in dedicated mode is set to 100 MB.

Correct Answer: B

Question 2

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

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

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

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

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

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

Correct Answer: E

Question 3

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

A. They support the ORACLE_DATAPUMP access driver.

B. They support all DML operations.

C. They can always be updated using SQL

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

E. They have extents

Correct Answer: A,C

Question 4

You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)

A. User managed backups of the data files and control files

B. Archived redo log files that have multiple copies in a different archive location and not backed up

C. Backups that have become obsolete

D. Flashback log files

Correct Answer: C,D

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

Question 5

View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table:
SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code='C005';
Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table:
SQL> ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));
What would happen in this scenario?
Exhibit:

A. The DDL operation gets higher priority and transaction for user A is rolled back

B. The ALETER TABLE command waits indefinitely until user A ends the transaction

C. The ALTER TABLE command modifies the column successfully

D. The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy

Correct Answer: D

Question 6

View the Exhibit and examine the PL/SQL package and procedure. You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body. Which statement is true after you recompile the EMP_ADMIN package body?
Exhibit:

A. The USE_P procedure becomes invalid.

B. The SHOW_DETAIL procedure becomes invalid.

C. The EMP_ADMIN package specification becomes invalid and needs to be recompiled.

D. The USE_P procedure remains valid.

Correct Answer: D

Question 7

Examine the following steps performed on a database instance:
1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION
2 . The SKD user creates a table
3 . The SKD user grants the CREATE TABLE system privilege to the HR user
4 . The HR user creates a table
5 . The DBA revokes the CREATE TABLE system privilege from SKD
Which statement is true after step 5 is performed?

A. The tables created by SKD and HR remain, but both cannot create new tables

B. The table created by SKD is not accessible and SKD cannot create new tables

C. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users

D. The table created by HR remains and HR still has the CREATE TABLE system privilege

Correct Answer: D

Question 8

Examine these SQL statements and their output:

Which two are true? (Choose two.)

A. Active UNDO will be retained as long as needed by the transactions

B. Transactions will wait until free space becomes available in the UNDO tablespace when they have failed to allocate space

C. The UNDO tablespace will grow automatically if there is not enough space to retain active UNDO

D. Expired UNDO will be retained as long as possible within the limits of the current size of the UNDO tablespace

E. Inactive UNDO will be retained for at least 15 minutes

Correct Answer: A,B

Question 9

You want to use the ALTER SYSTEM statement with SCOPE=MEMORY to change an initialization parameter value.
Which is true?

A. The change occurs immediately in memory for dynamic parameters but it is not persistent after instance restart

B. The change occurs immediately in memory for static parameters but it is not persistent after instance restart

C. It can be used only if an spfile is used

D. It can be used only if a pfile is used

Correct Answer: A

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

Question 10

You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:
SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;
Which two statements are true about the effect of the command? (Choose two.)

A. The table definition of the ITEM table and associated indexes are placed in the recycle bin.

B. The ORDERS table is dropped along with the ITEM table.

C. The dependent referential integrity constraints in the ORDERS table are removed.

D. No flashback is possible to bring back the ITEM table.

E. The dependent referential integrity constraints in the ORDERS table are disabled.

Correct Answer: C,D

Question 11

Note the following structures in your database server:
1 . Extents
2 . OS Blocks
3 . Tablespace
4 . Segments
5 . Oracle Data Block
Which option has the correct arrangement of these structures from the smallest to the largest?

A. 2, 5, 1, 4, 3

B. 1, 2, 3, 4, 5

C. 2, 1, 5, 4, 3

D. 5, 2, 1, 3, 4

Correct Answer: A

Question 12

You are using Enterprise Manager to schedule backups for your database.
Which type of script would be generated by the backup scheduler?

A. PL/SQL script

B. Recovery Manager (RMAN) script

C. Operating system script

D. XML script

Correct Answer: B

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

Question 13

You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days of statistics collection. The optimizer statistics retention period is set to its default value.
Which action would help to use the previous set of statistics on the objects?

A. Reduce the optimizer statistics retention period by 2 days.

B. Set the OPTIMIZER_PENDING_STATISTICS parameter to TRUE.

C. Reduce the Automatic Workload Repository (AWR) retention period by 2 days.

D. Restore statistics from statistics history.

Correct Answer: D

Welcome to TestSimulate

Oracle Database 11g: Administration I (1Z0-052) Free Practice Test