1z0-236 Exam

免费下载 1z0-236 认证考题Demo

下载 1z0-236 PDF 认证考试题库
下载 1z0-236 测试版考试题库

选择 pass4side 1z0-236 题库

1z0-236 考试是 Oracle 公司的 11i Applications DBA Fundamentals II 认证考试官方代号，pass4side 的 1z0-236 权威考试题库软件是 Oracle 认证厂商的授权产品，pass4side 绝对保证第一次参加 1z0-236 考试的考生即可顺利通过，否则承诺全额退款！

1、Pass4Side考题大师1z0-236试题都是考试原题的完美组合，覆盖率95％以上，答案由多位专业资深讲师原版破解得出，正确率100％，只要您使用本站的考试题库参加1z0-236 考试，我们保证您一次轻松通过考试；

2、售后服务第一！我们相信要想在当今时代取得成功，必须为广大用户提供全套的周到细致的全程优质售后服务，只有客户满意了，我们才能发展。客户至上是我们Pass4Side考题大师的一贯宗旨；

3、Pass4Side实行“一次不过全额退款”承诺。如果您购买我们1z0-236的考题，只要不是首次通过，凭盖有PROMETRIC或VUE考试中心钢印的考试成绩单，我们将退还您购买1z0-236考题大师的全部费用，绝对保证您的利益不受到任何的损失；

4、本站1z0-236题库根据1z0-236考试的变化动态更新，在厂家考题每次发生变化后，我们承诺2天内更新1z0-236题库。在您购买我们的产品之后，我们将提供90天的免费更新。确保1z0-236考题的覆盖率始终都在95％以上；我们提供2种 1z0-236 考题大师版本供你选择。

5、软件版本1z0-236 考试题库
优点：具有学习模式，测试模式，线上自动升级
缺点：仅限固定电脑使用，不可打印为文本，只能PC阅读

6、PDF 格式1z0-236 考试题库(部分最新更新科目已不提供PDF)
优点：不需下载安装软件，方便用户打印和携带，但也带来了可随意制的弊端，因此我们提醒用户不得随意公开或出售本站的1z0-236题库，一经发现立即取消其升级资格，且不予退款。
缺点：不具备测试模式，通过查看 pass4side.cn网站及查收我们的更新E-MAIL获取更新信息。
　
　
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. Users complain of slow response time in your online transaction processing (OLTP) system. You compare current statistics with baseline statistics. You notice that in the current statistics library cache, the hit ratio has decreased and there are request misses for shared pool reserved area. Given below are the sizes of shared pool and shared pool reserved area:
SHARED_POOL_SIZE = 500 MB
SHARED_POOL_RESERVED_SIZE = 50 MB
What kind of strategy would you suggest for performance tuning?
A. increase the size of only the shared pool
B. decrease the size of the shared pool reserved area
C. increase the size of only the shared pool reserved area
D. increase the sizes of both the shared pool and the shared pool reserved area
E. increase the size of the shared pool and decrease the size of the shared pool reserved area
Answer: D

3. What provides the information about the free extents in a temporary tablespace before a sort operation?
A. LRU chain
B. sort extent pool
C. resource free list
D. free extent table (FET$)
E. used extent table (UET$)
Answer: B

4. You plan to perform a backup of the control file in your database. Which two statements regarding the control file backup are true? (Choose two.)
A. You can back up the control file to a binary file.
B. You must bring the database to the NOMOUNT state to perform the control file backup.
C. You must store all types of control file backups in the location defined by USER_DUMP_DEST.
D. You can back up the control file by generating a script that can be used to re-create the control file.
Answer: AD

5. 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

6. In an online transaction processing (OLTP) system, which is configured in shared server mode, you execute the following query to examine the sort performance:
SQL> SELECT d.value "Disk", m.value "Mem", (d.value/m.value)*100 "Ratio"
FROM v$sysstat m, v$sysstat d
WHERE m.name='sorts (memory)' and d.name='sorts (disk)';
Disk Mem Ratio
---------- ---------- -------------
23 206 11.165049
What action would you take after observing the output?
A. increase the value of SORT_AREA_SIZE
B. increase the size of the temporary tablespace
C. increase the value of PGA_AGGREGATE_TARGET
D. no action required because the ratio is perfect for an OLTP system
Answer: A

7. 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 of full table scans is very low
E. if the number of index accesses is very high
Answer: AB

8. When starting up the test database, you encounter the following error after mounting the database:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/oracle/app/oradata/log2.log'
ORA-27037: unable to obtain file status
While investigating the reason, you find that the status of the redo log group 2 is CURRENT. Which type of recovery would you perform to ensure that the database is functional?
A. Open Database recovery
B. Time-Based incomplete recovery
C. recovery using the backup control file
D. Cancel-Based incomplete recovery
E. Change-Based incomplete recovery
Answer: D