单选题Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?（）AIt will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamicallyBIt will be successful only if the memory is available from the auto tuned componentsCIt will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGETDIt will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
单选题
Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?（）
A
It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
B
It will be successful only if the memory is available from the auto tuned components
C
It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
D
It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
参考解析
解析：
暂无解析
相关考题：
多选题Which two are the uses of the ASM metadata backup and restore （AMBR） feature？（）AIt can be used to back up all data on ASM disks.BIt can be used to recover the damaged ASM disk group along with the data.CIt can be used to gather information about a preexisting ASM disk group with disk paths，disk name，failure groups，attributes templates，and alias directory structure.DIt can be used to re-create the ASM disk group with its attributes.
多选题What recommendations does the SQL Access Advisor provide for optimizing SQL queries?（） (Choose all that apply.)Aselection of SQL plan baselinesBpartitioning of tables and indexesCcreation of index-organized tablesDcreation of bitmap, function-based, and B-tree indexesEoptimization of materialized views for maximum query usage and fast refresh
多选题Which operation requires that you create an auxiliary instance manually before executing the operation？（）ABackup-based database duplication.BActive database duplication.CTablespace point-in-time recovery.DNo operation requires the creation of an auxiliary instance.
多选题Which statements are true regarding the Query Result Cache？（）AIt can be set at the system， session， or table level.BIt is used only across statements in the same session.CIt can store the results from normal as well as flashback queries.DIt can store the results of queries based on normal，temporary，and dictionary tables.
单选题You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?（）AIt will display a list of files that need incremental backupBIt will display a list of files that need backup after five daysCIt will display a list of files that were backed up in the last five daysDIt will display a list of files that have not been backed up in the last five daysEIt will apply the current retention policy to determine the files that need to be backed up
单选题Which of the following is not an advantage of block media recovery （BMR）？（）A Reduced MTTR.B Datafiles remain offline while corrupt blocks are repaired.C Datafiles remain online while corrupt blocks are repaired.D A and C
多选题Which are the prerequisites for performing flashback transactions on your database？（）AUndo retention guarantee for the database must be configured.BSupplemental log must be enabled for the primary key.CSupplemental log must be enabled.DExecute permission on the DBMS_FLASHBACK package must be granted to the user.
单选题You issue the following command： RMANCONFIGURE BACKUP OPTIMIZATION ON； What is the result of this command on your backups？（）A An incremental backup strategy will be used automatically.B Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.C RMAN will configure itself for maximum performance at the cost of CPU.D RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.E RMAN will automatically compress backups.
多选题What information does the report schema command not provide？（）ASize of the datafilesBSize of the tempfilesCDate of last backup for datafiles and tempfilesDFilenames for each datafileECheckpoint SCN associated with the last RMAN backup