1Z0-052 - Oracle Database 11g Certification Exam Guide and Questions Make 1Z0-052 Certification Exam Easy with DBexam.com
Oracle 1Z0-052 Exam Detail Exam Code
1Z0-052
Full Exam Name
Oracle Database 11g - Administration I
Number of Questions
70
Practice Exams
Click Here
Passing Score
66%
Time Limit
90 minutes
Recommended Training
Oracle Database 11g: Administration Workshop I
Enjoy success with DBexam.com
How to Prepare for Oracle 1Z0-052 •
Perform enough practice with Oracle system with related Oracle 1Z0-052 certification subjects
•
Identify the key configuration, workflow and data flow
•
Understand the all Syllabus Topics of Exam which are Given in Description.
•
Identify your weak areas from practice test and do more practice with system
•
Repeat practice exams and try to score 100% on www.DBexam.com
Enjoy success with DBexam.com
Oracle 1Z0-052 Exam Questions
Enjoy success with DBexam.com
Q 1) You notice that the database instance takes a long time to start up after the instance crash. How will you resolve the problem? Option a) Increase the size of the redo log files b) Decrease the number of redo log members
c) Set LOG_CHECKPOINT_TO_ALERT to TRUE d) Decrease the value for the FAST_START_MTTR_TARGET initialization parameter Enjoy success with DBexam.com
ANSWER d) Decrease the value for the FAST_START_MTTR_TARGET initialization parameter
Enjoy success with DBexam.com
Q 2) Which two statements are true regarding undo management? (Choose two) Option a) The database can have more than one undo tablespaces
b) The undo data must be purged manually when the transaction is over c) The UNDO_TABLESPACE parameter is valid only if the UNDO_MANAGEMENT parameter is set to AUTO d) Undo management is automatic by default even if the UNDO_MANAGEMENT initialization parameter is set to NULL Enjoy success with DBexam.com
ANSWER a) The database can have more than one undo tablespaces c) The UNDO_TABLESPACE parameter is valid only if the UNDO_MANAGEMENT parameter is set to AUTO Enjoy success with DBexam.com
Q 3) You want to be warned automatically when more than 100 sessions are opened with your database instance. Identify the action that would help you achieve this. Option a) Set the TRACE_ENABLED parameter to TRUE
b) Set the threshold for the Current Logons Count metric c) Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE d) Set the SESSIONS_PER_USER limit in the profiles used by users
Enjoy success with DBexam.com
ANSWER b) Set the threshold for the Current Logons Count metric
Enjoy success with DBexam.com
Q 4) Which operations can be performed using the Data Recovery Advisor? (Choose all that apply) Option
a) Diagnosing data failure b) It is a percentage of rows in which the statistics are collected incrementally for partitions c) Presenting appropriate repair options d) Generating reports for possible causes of failure Enjoy success with DBexam.com
ANSWER a) Diagnosing data failure c) Presenting appropriate repair options
Enjoy success with DBexam.com
Q 5) A user receives the following error while executing a query: ORA-01555: snapshot too old Identify two solutions to avoid such errors in future. (Choose two) Option
a) Increase the size of redo log files b) Increase the size of the undo tablespace c) Increase the size of the Database Buffer Cache
d) Increase the size of the default temporary tablespace e) Enable the retention guarantee for the undo tablespace Enjoy success with DBexam.com
ANSWER b) Increase the size of the undo tablespace e) Enable the retention guarantee for the undo tablespace
Enjoy success with DBexam.com
More Info on Oracle Certification ●
For more information on Oracle Certification please refer to FAQs
●
A Oracle certification is increasingly becoming important for the career of employees
●
The fees information are for the informative purposes and do not serve as an official offering and are subject to change
●
Focus on the guide for online registration and you will very soon find it out
Enjoy success with DBexam.com
More Info on Oracle Certification VISIT WWW.DBEXAM.COM