单选题By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value， you will enable which of the following memory-management options？（）A Automatic PGA Memory ManagementB Automatic SGA Memory ManagementC Automatic Shared Memory ManagementD Automatic Memory ManagementE Manual SGA Memory ManagementF None of the above
单选题
By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value， you will enable which of the following memory-management options？（）
A
Automatic PGA Memory Management
B
Automatic SGA Memory Management
C
Automatic Shared Memory Management
D
Automatic Memory Management
E
Manual SGA Memory Management
F
None of the above
参考解析
解析：
暂无解析
相关考题：
单选题Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（） 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.A1，3，6，7B2，3，6，8C1，2，3，6，7D1，2，3，6，，7，8E2，3，6，5，7
多选题Which of these represent the main components of Database Resource Manager？（）AResource consumer groupsBResource plansCResource-plan groupsDResource-plan directivesEAll of the above
单选题Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）ASegment AdvisorBSQL Access AdvisorCUndo AdvisorDSQL Tuning Advisor
单选题If a log file becomes corrupted， it may cause the database to stall. How would you correct such a situation？（）A Recover the online redo log from backup.B Delete and re-create the log file.C Use the alter database clear logfile command to clear the log file.D Shut down the database and restart it.E Shut down the database and then mount it. Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs.
多选题Which three functions are performed by the SQL Tuning Advisor？（）ABuilding the SQL profileBRecommending optimization of materialized viewsCChecking query objects for missing and stale statisticsDRecommending bitmap， function-based， and B-tree indexesERecommending restructuring SQL queries that are using bad plans
多选题You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process？（）Athe SQL textBthe execution planCthe execution contextDthe execution frequencyEthe system change number （SCN）
多选题What is the purpose of the RMAN recovery catalog？（）AMake backups fasterBStore RMAN metadataCStore RMAN scriptsDProvide the ability to do centralized backup reportingEMake recovery faster
多选题When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? （）(Choose two.)AIt produces less accurate results of the comparison analysis.BIt automatically calls the SQL Tuning Advisor for recommendations.CIt shortens the time of execution and reduces the impact on system resources.DOnly the changes in the execution plan, and not performance regression, are detected.
单选题View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?（）ABecause the progress is reported for each data fileBBecause the progress is reported for each backup setCBecause other RMAN sessions have issued the same BACKUP commandDBecause new data files have been added to the database while the RMAN backup is in progress
单选题Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）A Yes， if the database is in ARCHIVELOG modeB Yes， if the database is in NOARCHIVELOG modeC No， the backup is not usable in any wayD Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE
单选题You want to create the Recovery Manager （RMAN） Virtual Private Catalog （VPC） to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC？（）A A base catalog existsB The recovery catalog is emptyC The base recovery catalog must be droppedD A target database is registered in the recovery catalog