1z0-236 Oracle 11i Braindump
ExamSoon 1z0-236 Exams
Oracle 11i Applications DBA Fundamentals II
O rder : 1z0-236 Exam
Practice Exam: 1z0-236
Exam Number/Code: 1z0-236
Exam Name: 11i Applications DBA Fundamentals II
Questions and Answers: 132 Q&As
Free 1z0-236 Braindumps
Exam : Oracle 1Z0-236
Title : 11i applications DBA:fundamentals II
1. Which type of lock is held by SQL statements and PL/SQL objects in the Library Cache?
A. breakable parse locks
B. row-level (TX type) lock
C. table-level manual locks
D. table-level (TM type) locks
Answer: A
2. In the parameter file of your production database, the LOG_CHECKPOINT_INTERVAL parameter is set to 3600.
When does the checkpoint occur due to this setting?
A. when the number of transactions exceeds the specified value
B. when the specified number of database blocks are written to the data files
C. when a specified amount of time (in seconds) is exceeded after the last checkpoint
D. when the number of dirty buffers in the database buffer cache exceeds the specified value
E. when the number of operating system blocks between an incremental checkpoint and the last block written to the
redo log is equal to or greater than the specified value
Answer: E
3. What action can you take to reduce the recovery time in case of instance failures?
A. use an SPFILE
B. multiplex the control files
C. reduce the number of data files used by the database
D. reduce the number of redo log members in each group
E. configure database parameters to increase the frequency of checkpoints
Answer: E
4. You are working in an OLTP environment. You wish to reduce the virtual memory requirements for the Oracle
instance due to Operating system paging or swap overheads. You need to determine whether the buffer cache is
oversized and could tolerate being reduced. In which two cases can you afford to reduce the buffer cache size?
(Choose two.)
A. if the cache hit ratio is very high
B. if there are no waits for free buffers
C. if the rate of physical I/O is very high
D. if the number