Online Access Free 1Z1-052 Practice Test

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 the whole session if user SCOTT successfully drops one or more tables in his session
• C.One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully
• D.One audit record is created for every successful DROP TABLE command executed in the session of SCOTT
• E.One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT

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 table created by HR remains and HR can grant the CREATE TABLE system privilege to other users
• B.The table created by HR remains and HR still has the CREATE TABLE system privilege
• C.The table created by SKD is not accessible and SKD cannot create new tables
• D.The tables created by SKD and HR remain, but both cannot create new tables

Which two types of information can be found in the alert log? (Choose two.)

• A.values of all initialization parameters whenever an instance is restarted
• B.instance recovery details
• C.critical errors encountered by background processes
• D.a record of all DDL statements performed by non-DBA users
• E.a record of all actions performed by SYS and SYSTEM

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.
What would you do to recover the data file?

• A.Take the USERS tablespace offline and re-create the lost data file
• B.Shutdown the instance, restore the data file from the last consistent backup and restart the database instance
• C.Shutdown the instance, restores all the database files from the last consistent backup and restart the database instance
• D.Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the last consistent backup and make the tablespace online

Examine these SQL statements and their output:

Which two are true? (Choose two.)

• A.Inactive UNDO will be retained for at least 15 minutes
• B.Transactions will wait until free space becomes available in the UNDO tablespace when they have failed to allocate space
• C.Expired UNDO will be retained as long as possible within the limits of the current size of the UNDO tablespace
• D.The UNDO tablespace will grow automatically if there is not enough space to retain active UNDO
• E.Active UNDO will be retained as long as needed by the transactions