單項(xiàng)選擇題

You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）

A. Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
B. Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
C. Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
D. Increase the value of the SGA_TARGET initialization parameter.

你可能感興趣的試題

單項(xiàng)選擇題

You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files？（）

A. ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ；
B. ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH；
C. ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’；
D. ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’；

單項(xiàng)選擇題

You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required？（）

A. V$DATABASE
B. V$FLASHBACK_DATABASE_STAT
C. V$FLASHBACK_DATABASE_LOG
D. V$RECOVERY_FILE_DEST

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）

你可能感興趣的試題

You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required？（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精