网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）
A
The STATISTICS_LEVEL initialization parameter is set to BASIC
B
The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
C
The SGA_MAX_SIZE initialization parameter is set to less than 20 GB
D
The DB_CACHE_SIZE initialization parameter is set to less than 5 GB
E
The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.
参考答案
参考解析
解析：
暂无解析
更多 “单选题In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）A The STATISTICS_LEVEL initialization parameter is set to BASICB The PGA_AGGREGATE_TARGET initialization parameter is set to zero.C The SGA_MAX_SIZE initialization parameter is set to less than 20 GBD The DB_CACHE_SIZE initialization parameter is set to less than 5 GBE The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.” 相关考题
考题
It is very kind ( ) you to let us use your running machine.Actually, it is good ( ) us to do some physical exercise every day.
A、of/ ofB、of/ forC、for/ ofD、for/ for
考题
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
考题
You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）A、The instance would normally abort.B、The instance would not be affected.C、The instance would be invalid， so would have to be aborted.D、The instance would remain open， but the LGWR process would fail.E、The instance would remain open and would automatically create the missing file
考题
Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、the retention period to support flashbackB、the expected length of the longest-running queryC、the number of undo tablespaces in the databaseD、the size of the Flash Recovery Area for the database instance
考题
You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true？（）A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC、 The database instance starts，but Automatic Memory Management is disabledD、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
考题
Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup？（） A、 ASM_DISKMOUNTB、 ASM_DISKGROUPC、 ASM_DISKSTRINGD、 ASM_MOUNTGROUP
考题
You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）A、 INSTANCE_TYPEB、 DB_UNIQUE_NAMEC、 ASM_DISKSTRINGD、 ASM_POWER_LIMIT
考题
What effect should the loss of an index tablespace have on an Oracle instance that is running？（）A、 instance hangsB、 instance gets abortedC、 instance continues runningD、 instance gets restarted automatically
考题
You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file： INSTANCE_TYPE = ASM ASM_POWER_LIMIT = 11 LARGE_POOL_SIZE = 4M ASM_DISKGROUPS = DG1， DG2 DB_UNIQUE_NAME = +ASM You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）A、 only the INSTANCE_TYPE initialization parameter is set to an invalid valueB、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values
考题
单选题Your company has a server that runs Windows Server 2008 R2. The server runs an instance of Active Directory Lightweight Directory Services （AD LDS）. You need to replicate the AD LDS instance on a test computer that is located on the network. What should you do（）A
Run the repadmin /kcc command on the test computer.B
Create a naming context by running the Dsmgmt command on the test computer.C
Create a new directory partition by running the Dsmgmt command on the test computer.D
Create and install a replica by running the AD LDS Setup wizard on the test computer.
考题
单选题A line of position is（）.A
a line connecting two charted objectsB
a line on some point of which the vessel may be presumed to be locatedC
the position of your vesselD
not used in a running fix
考题
单选题Your database is running on the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）A
modify the HASH_AREA_SIZE initialization parameterB
modify the PGA_AGGREGATE_TARGET initialization parameterC
modify the WORK_AREASIZE_POLICY initialization parameterD
increase the value of the SGA_TARGET initialization parameterE
increase the value of the SGA_MAX_SIZE initialization parameterF
increase the value of the SORT_AREA_SIZE initialization parameter
考题
单选题Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）A
any control fileB
any archive log fileC
one of the redo log membersD
loss of the initialization parameter fileE
any data file belonging to the default permanent tablespac
考题
单选题You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file： INSTANCE_TYPE = ASM ASM_POWER_LIMIT = 11 LARGE_POOL_SIZE = 4M ASM_DISKGROUPS = DG1， DG2 DB_UNIQUE_NAME = +ASM You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）A
only the INSTANCE_TYPE initialization parameter is set to an invalid valueB
only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC
only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD
both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values
考题
单选题What effect should the loss of an index tablespace have on an Oracle instance that is running？（）A
instance hangsB
instance gets abortedC
instance continues runningD
instance gets restarted automatically
考题
单选题Your database is running in the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）A
modify the HASH_AREA_SIZE initialization parameterB
modify the PGA_AGGREGATE_TARGET initialization parameterC
modify the WORK_AREASIZE_POLICY initialization parameterD
increase the value of the SGA_TARGET initialization parameterE
increase the value of the SGA_MAX_SIZE initialization parameterF
increase the value of the SORT_AREA_SIZE initialization parameter
考题
单选题You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）A
Place each database in a separate instance running on SQL2.B
Place each database in a separate instance running on SQL3.C
Place both databases in a single instance running on SQL2.D
Place both databases in a single instance running on SQL3.
考题
单选题You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?（）A
The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB
The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC
The database instance starts, but Automatic Memory Management is disabledD
The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
考题
单选题You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）A
The instance would normally abort.B
The instance would not be affected.C
The instance would be invalid， so would have to be aborted.D
The instance would remain open， but the LGWR process would fail.E
The instance would remain open and would automatically create the missing file
考题
单选题You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）A
INSTANCE_TYPEB
DB_UNIQUE_NAMEC
ASM_DISKSTRINGD
ASM_POWER_LIMIT
考题
多选题Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）AThe retention period to support flashbackBThe expected length of the longest-running queryCThe number of undo tablespaces in the databaseDThe size of the Flash Recovery Area for the database instance
考题
多选题You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective？（）ASet the ASM compatibility attribute for the ASM disk group to 11.1.0.BSet the RDBMS compatibility attribute for the ASM disk group to 11.1.0.CSet the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.DSet the COMPATIBLE initialization parameter for the database instance to 11.1.0.
考题
单选题You want to enable archiving on your database. Presently， the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order： 1：Shut down the instance. 2：Execute the ALTER DATABASE ARCHIVELOG command. 3：Start up the instance and mount the database. 4：Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5： Open the database. Which is the correct sequence of steps for accomplishing the task（）A
4，1，3，2，5B
1，3，4，5，2C
1，3，2，5；4 not requiredD
4，1，5，2；3 not requiredE
1，3，4，5；2 not required
考题
多选题You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？（）AThe WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.BThe Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.CSetting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.DThe SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
热门标签
最新试卷
