您在这里:首页 > 技术沙龙&教程 > 资源共享
Oracle视频
Oracle
CUUG课程

练习题(三)

 1.Which two parameters significantly impact the manual stripe size of data files? (Choose two.)

        A. DB_BLOCK_SIZE
        B. REDO_LOG_BUFFERS
        C. DB_BLOCK_BUFFERS
        D. DB_BLOCK_MAX_DIRT_TARGET
        E. DB_FILE_MULTIBLOCK_READ_COUNT
Answer:

2.Which component will NEVER allocate memory from the large pool?

        A. Oracle Library Cache
        B. Oracle Parallel Query
        C. Oracle Recovery Manager
        D. Oracle Multithreaded Server
Answer:

3.Which two statements about database blocks are true? (Choose two.)

        A. DSS environments prefer a large block size.
        B. Small block sizes result in more block contention.
        C. Random access to large objects favors a large block size.
        D. You can reduce the number of block visits by packing rows as closely as posibble into blocks.
        E. To change the database block size, you must shut down the instance and perform a STARTUP RESERLOGS after you make the change.
Answer:

4.Which two parameters could result in problems when starting more shared servers? (Choose two.)

        A. PROCESSES       
        B. MTS_MAX_SERVERS
        C. MTS_MAX_PROCESSES
        D. MTS_MAX_DISPATCHERS
        E. PARALLEL_MAX_SERVERS
Answer:

5. You want to reduce the amount of redo generated for your database. What are three ways to achieve this goal? (Choose three.)

        A. Use NOLOGGING mode in SQL statements.
        B. Use direct load UPDATE in NOLOGGING mode.
        C. Use direct path loading without archiving.
        D. Use direct path loading with archiving using NOLOGGING mode.
        E. Start your instance with the NOLOGGING initialization parameter.
Answer:

6.Which type of transactions should you assign to a specific large rollback segment?

        A. batch jobs that modify many rows
        B. long running serializable transactions
        C. long running reports, to avoid "snapshot too old" errors
        D. discrete transactions that modify many rows in the same block
Answer:
相关文章 [上一篇] 练习题(二)
010-88589926(88587026)
CUUG热门培训课程
Oracle DBA就业培训
CUUG名师
网络课程
技术沙龙
最新动态

总机:(010)-88589926,88589826,88587026 QQ讨论群:243729577 182441349 邮箱:cuug_bj@cuug.com
通信地址:北京市海淀区紫竹院路98号北京化工大学科技园609室(CUUG)邮政编码:100089 
中国UNIX用户协会 Copyright 2010  ALL Rights Reserved 北京神脑资讯技术有限公司
京ICP备11008061号  京公网安备110108006275号