單項選擇題

Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）

A. The parameter DB_CACHE_SIZE must be a multiple of 8.
B. The value of the parameter SGA_MAX_SIZE must be increased.
C. The tablespace must be created with a uniform extent size of 8 KB
D. The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.

你可能感興趣的試題

單項選擇題

You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

A. You must enable the block change tracking feature.
B. You must have enable the flashback feature.
C. You must use the OMF in your database.
D. You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

單項選擇題

You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）

A. the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
B. the column of the V$INSTANCE_RECOVERY view
C. the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
D. the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）

你可能感興趣的試題

You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）

You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）