[1Z0-052 Free Questions] 1Z0-052 Oracle Database 11g: Administrator I

Are you looking for Oracle Database 11g 1Z0-052 free questions? Get practice here online for 1Z0-052 Oracle Database 11g: Administrator I exam. They are just part of full version. ALL 1Z0-052 free questions are from Passquestion Oracle Database 11g 1Z0-052 full version of 109 Q&As.

We provide 20 free questions for 1Z0-052 Oracle Database 11g: Administrator I Exam. You will score 5 points after you answer each question correctly. If you want to get full version to study , please click the picture “Get Full Version“. If you have any questions, please contact us via Live Chat or email us [email protected].

Test Begin:

1. 1.You want to audit update statements that refer to USER1. DEPT. DNAME.

Which type of auditing must you use?

 
 
 
 

2. 2.Which three are true about dynamic performance views?

 
 
 
 
 

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

 
 
 
 

4. 4.Your database is configured in archivelog mode.

The USERS01 tablespace is currently online.

You are required to take the tablespace offline.

Which clause or clauses ensure that no media recovery is required when the tablespace is brought back online?

 
 
 
 
 

5. 5.Table EMP resides in the USERS tablespace.

Examine this command:

SQL> DROP TABLE emp PURGE;

Which two methods would you use to recover EMP?

 
 
 
 
 

6. 6.Which is true about enabling AUTOEXTEND for data files?

 
 
 
 
 

7. 7.In one of your databases:

  • The database default tablespace is EXAMPLE.
  • DEFERRED_SEGMENT_CREATION is FALSE.

Examine these commands:

SQL> CREATE USER user1 IDENTIFIED BY oracle_4U PASSWORD EXPIRE;

User created.

SQL> ALTER USER user1 ACCOUUNT UNLOCK;

User altered.

SQL> GRANT CREATE SESSION no user1;

Grant succeeded.

SQL> GRANT CREATE TABLE TO user1 WITH ADMIN OPTION;

Grant succeeded.

Which three are true?

 
 
 
 
 

8. 8.Which two can be exported by a non-administrative account by using Data Pump?

 
 
 
 
 

9. 9.Which two statements are true about tablespaces?

 
 
 
 
 

10. 10.Which two are true about the Fast Recovery Area (FRA)?

 
 
 
 
 

11. 11.Your database is using Automatic Memory Management.

Which two SGA components must be managed manually?

 
 
 
 
 

12. 12.A database instance was terminated due to a lost data file and has not been restarted.

You wish to restore database availability by using the Data Recovery Advisor.

Examine this list, of RMAN commands:

  1. startup
  2. list failure all;
  3. advise failure, all;
  4. repair failure noprompt;
  5. alter database open;

What are the minimum required commands and in what order must they be executed to achieve this?

 
 
 
 
 

13. 13.Which three can be used to schedule automated backups of the database?

 
 
 
 
 
 

14. 14.Where is backup metadata stored for use by Recovery Manager (RMAN)?

 
 
 
 
 

15. 15.Which is true about the Automatic Diagnostic Repository (ADR)?

 
 
 
 

16. 16.Which two are true about space management in tablespaces?

 
 
 
 
 

17. 17.Which two are true about transactions, UNDO segments, and UNDO tablespaces?

 
 
 
 
 

18. 18.Which four are true about the tools used to administer Oracle databases?

 
 
 
 
 
 

19. 19.Which is true about invalid PL/SQL objects?

 
 
 
 

20. 20.Which two are true about AWR snapshots?

 
 
 
 
 

Question 1 of 20

[1Z0-971 Free Questions] 1Z0-971 Oracle Incentive Compensation Cloud 2017 Implementation Essentials
[1Z0-808 Free Questions] 1Z0-808 Java SE 8 Programmer I

Leave a Reply

Your email address will not be published. Required fields are marked *