练习题(三)
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: