It is useful and valuable for you to choose testpassport Oracle 1Z0-052 practice test, which can provide you all that you need. such as the study materials, practice questions and answers, exam dumps, exam PDF free download and so on, try to visit testpassport now, and you will pass your Oracle 1Z0-052 by your first try and get the Oracle Certification without any effort.
VUE/Prometric Code: 1Z0-052
Exam Name: Oracle Database 11g: Administrator I : 1z1-052 Exam
Questions and Answers: 188 Q&As
Free practice exam questions sharing :
1.Note the functionalities of various background processes:
1: Perform recovery at instance startup.
2: Free the resources used by a user process when it fails.
3: Cleanup the database buffer cache when a process fails.
4: Dynamically register database services with listeners.
5: Monitor sessions for idle session timeout.
6: Cleanup unused temporary segments.
7: Record the checkpoint information in control file.
Which option has the correct functionalities listed for a background process?
A.Checkpoint (CKPT): 1, 2, 5
B.System Monitor (SMON): 1, 6
C.Process Monitor (PMON): 4, 6, 7
D.Database Writer (DBWR): 1, 3, 4
Answer: B
2.Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)
A.Shared SQL Area will be allocated in the shared pool.
B.Shared SQL Area will be allocated when a session starts.
C.Shared SQL Area will be allocated in the large pool always.
D.Private SQL Area will be allocated in the Program Global Area (PGA) always.
E.Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
F.The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.
Answer: AF
More real questions and answers for oracle 1z0-052 exam just visit testpassport for help.