1Z0-052 Free Questions – Oracle Database 11g: Administrator I V17.02

1Z0-052 Oracle Database 11g: Administrator I exam is for Oracle Database 11g Administrator Certified Associate Certification. Becoming Oracle Database certified broadens your knowledge and skills by exposing you to a wide array of important database features, functions and tasks. Today, we released Oracle 1Z0-052 exam questions V17.02 online with 285 real questions and accurate answers. You can use 1Z0-052 Oracle practice questions as the preparation materials to pass Oracle Database 11g: Administrator I exam in the first try. We recommend you take 1Z0-052 exam for your certification as soon as possible. Both 1Z0-052 exam and Oracle Database 11g Administrator Certified Associate certification retire on 31, Dec 2019. 1Z0-052 exam is replaced by 1Z0-082.

1Z0-052 Free Questions – Oracle Database 11g: Administrator I V17.02

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

 
 
 
 
 

2. Which two affect the time taken for instance recovery? (Choose two.)

 
 
 
 
 
 

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

 
 
 
 
 

4. You have decided to implement the principle of least privilege and separation of duties.
Which two actions must you take? (Choose two.)

 
 
 
 
 

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

 
 
 
 
 

6. USER1 grants SELECT, INSERT, and UPDATE privileges on USER1, EMP to USER2.
SYS executes this command:
SQL>REVOKE UPDATE ON user1.emp FROM user1;
What will be the outcome?

 
 
 
 
 

7. Which two are true about roles? (Choose two.)

 
 
 
 
 

8. Which two are true about consistent database backups? (Choose two.)

 
 
 
 
 

9. Your database is using Automatic Memory Management.
Which two SGA components must be managed manually? (Choose two)

 
 
 
 
 

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

 
 
 
 
 

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

 
 
 
 

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

 
 
 
 
 

13. Which two can be exported by a non-administrative account by using Data Pump? (Choose two.)

 
 
 
 
 

14. Which two are true about Optimizer Statistics? (Choose two.)

 
 
 
 
 
 

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

 
 
 
 
 
 

16. When would you use memory advisors?

 
 
 
 
 

17. You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI).
You select the “Install and Configure Grid Infrastructure for a Standalone Server’ option.
Which task is performed by OUI as part of this installation?

 
 
 
 

18. Which three are true about auditing? (Choose three.)

 
 
 
 
 
 

19. Which is true about the Database Configuration Assistant (DBCA)?

 
 
 
 

20. Which two are true about server-generated alerts? (Choose two.)

 
 
 
 
 

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

 
 
 
 
 

22. Which two are true about roles? (Choose two.)

 
 
 
 
 

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

 
 
 
 
 

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

 
 
 
 

25. Which are three of the various resources that must be accessible to keep a database open?

 
 
 
 
 

1Z0-958 Free Questions - Oracle Risk Management Cloud 2018 Implementation Essentials

Leave a Reply

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