网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.()
A
The PGA_AGGREGATE_TARGET parameter is set to zero.
B
The STATISTICS_LEVEL parameter is setto basic.
C
Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.
D
The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
参考答案
参考解析
解析:
暂无解析
更多 “单选题To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.()A The PGA_AGGREGATE_TARGET parameter is set to zero.B The STATISTICS_LEVEL parameter is setto basic.C Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.D The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.” 相关考题
考题
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()
A. Set MEMORY_TARGET to zeroB. Set the STATISTICS_LEVEL parameter to BASICC. Set the WORKAREA_SIZE_POLICY parameter to MANUALD. Set the PGA_AGGREGATE_TARGET parameter to nonzero value
考题
Which two initialization parameters would you set to enable Automatic Shared Memory Management?()
A. set SHARED_POOL_SIZE to zeroB. set STATISTICS_LEVEL to BASICC. set SGA_TARGET to a non-zero valueD. set DB_CACHE_SIZE to a non-zero valueE. set STATISTICS_LEVEL to TYPICAL or ALL
考题
Which statement about Automatic Memory Management with Oracle 11g is true?()
A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.B. Oracle can reallocate memory between the SGA and PGA automatically as needed.C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
考题
You need to implement a high availability design in the Company routed network. Which protocol allows for the automatic selection and simultaneous use of multiple available gateways as well as automatic failover between those gateways?()A、 VRRPB、 GLBPC、 IRDPD、 HSRPE、 None of the other alternatives apply
考题
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 plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?()A、Set metric thresholdB、Implement Database Resource ManagerC、Enable resumable timeout for user sessionsD、Add directives to Automatic Database Diagnostic Monitor (ADDM)
考题
To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.()A、The PGA_AGGREGATE_TARGET parameter is set to zero.B、The STATISTICS_LEVEL parameter is setto basic.C、Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.D、The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
考题
Which two initialization parameters would you set to enable Automatic Shared Memory Management?()A、 set SHARED_POOL_SIZE to zeroB、 set STATISTICS_LEVEL to BASICC、 set SGA_TARGET to a non-zero valueD、 set DB_CACHE_SIZE to a non-zero valueE、 set STATISTICS_LEVEL to TYPICAL or ALL
考题
You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()A、Set the UNDO_RETENTION parameter to AUTO.B、Create an initial undo segment in undotablespace.C、Set the UNDO_RETENTION parameter to 900 or moreD、Set the initialization parameter UNDO_MANAGEMENT to AUTOE、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
考题
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?() A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
考题
Which of the following would you use to enable automatic media recovery for a database?()A、SET AUTORECOVERY ONB、SET RECOVERY ONC、SET AUTO OND、You cannot enable automatic media recovery.
考题
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()A、 Set MEMORY_TARGET to zeroB、 Set the STATISTICS_LEVEL parameter to BASICC、 Set the WORKAREA_SIZE_POLICY parameter to MANUALD、 Set the PGA_AGGREGATE_TARGET parameter to nonzero value
考题
You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? ()A、ALTER DATABASE B、SET TRANSACTION C、ALTER ROLLBACK SEGMENT D、ALTER TABLE
考题
You are employed as the exchange administrator at TestKing.com. You are in the process of installing anew Exchange Server 2010 Organization. Outlook Web App is used throughout the organization by usersto access their e-mail. TestKing.com wants you to implement a new compliance policy that states that e-mail messaging containing client contracts be kept for two years. Management also wants users to classify e-mails relatingto client contracts as well as moving e-mail messages to other folders. You are instructed a solution thatwill comply with the set criteria. What should you do?()A、You should recommend Retention Policy Tags as well as a Retention Policy to management.B、You should recommend an OWA mailbox policy to management.C、You should recommend Managed Folder mailbox policies to management.D、You should recommend Personal Archives and an Archive policy to management.
考题
You have a computer that runs Windows 7. You need to install the Exchange 2010 management tools on the computer. What should you do first()? A、Install Telnet Client.B、Run the Exchange Best Practices Analyzer.C、Set the Net.TCP Port Sharing service to Automatic.D、Install Microsoft .NET Framework 3.5.1 and the Internet Information Services (IIS) 6.0 Management console.
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules. What process should you implement?() A、You should create a cached data collectionB、You should create an on-demand non-cached data collection C、You should create a scheduled non-cached data collection D、You should create two different SQL Agent jobs that are scheduled stimultaneously
考题
You work as the enterprise exchange administrator at Xxx .The Xxx network consists of a domain named xxx .What actions must you take to use administrative delegation on a series of cmdlets?()A、You must implement log transactionsB、You must set up new management roleC、You must implement Mailbox journalingD、You must set up a Role Based Access Control (RBAC) role
考题
You configured automatic archive logging for the database. On the next startup the database runs for a while, but then hangs. After checking the alert log, you determine that all the online redo logs need archiving. Which step was skipped when you set up automatic archive log?()A、LOG_ARCHIVE_DEST was not set in the parameter file.B、LOG_ARCHIVE_START was not set in the parameter file.C、alter database archivelog; was not executed in MOUNT mode.D、LOG_ARCHIVE_MAX processes were not set in the parameter file.
考题
单选题You configured automatic archive logging for the database. On the next startup the database runs for a while, but then hangs. After checking the alert log, you determine that all the online redo logs need archiving. Which step was skipped when you set up automatic archive log?()A
LOG_ARCHIVE_DEST was not set in the parameter file.B
LOG_ARCHIVE_START was not set in the parameter file.C
alter database archivelog; was not executed in MOUNT mode.D
LOG_ARCHIVE_MAX processes were not set in the parameter file.
考题
单选题Which statement about Automatic Memory Management with Oracle 11g is true?()A
You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.B
Oracle can reallocate memory between the SGA and PGA automatically as needed.C
To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D
You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
考题
单选题You are employed as the exchange administrator at TestKing.com. You are in the process of installing anew Exchange Server 2010 Organization. Outlook Web App is used throughout the organization by usersto access their e-mail. TestKing.com wants you to implement a new compliance policy that states that e-mail messaging containing client contracts be kept for two years. Management also wants users to classify e-mails relatingto client contracts as well as moving e-mail messages to other folders. You are instructed a solution thatwill comply with the set criteria. What should you do?()A
You should recommend Retention Policy Tags as well as a Retention Policy to management.B
You should recommend an OWA mailbox policy to management.C
You should recommend Managed Folder mailbox policies to management.D
You should recommend Personal Archives and an Archive policy to management.
考题
单选题You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?()A
Set metric thresholdB
Implement Database Resource ManagerC
Enable resumable timeout for user sessionsD
Add directives to Automatic Database Diagnostic Monitor (ADDM)
考题
单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()A
Set MEMORY_TARGET to zeroB
Set the STATISTICS_LEVEL parameter to BASICC
Set the WORKAREA_SIZE_POLICY parameter to MANUALD
Set the PGA_AGGREGATE_TARGET parameter to nonzero value
考题
单选题Which statement about Automatic Memory Management with Oracle 11g is true?()A
You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.B
Oracle can reallocate memory between the SGA and PGA automatically as needed.C
To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D
You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
考题
多选题Which two initialization parameters would you set to enable Automatic Shared Memory Management?()Aset SHARED_POOL_SIZE to zeroBset STATISTICS_LEVEL to BASICCset SGA_TARGET to a non-zero valueDset DB_CACHE_SIZE to a non-zero valueEset STATISTICS_LEVEL to TYPICAL or ALL
考题
单选题To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.()A
The PGA_AGGREGATE_TARGET parameter is set to zero.B
The STATISTICS_LEVEL parameter is setto basic.C
Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.D
The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
考题
多选题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.
考题
单选题You work as the enterprise exchange administrator at Xxx .The Xxx network consists of a domain named xxx .What actions must you take to use administrative delegation on a series of cmdlets?()A
You must implement log transactionsB
You must set up new management roleC
You must implement Mailbox journalingD
You must set up a Role Based Access Control (RBAC) role
热门标签
最新试卷
![瑞牛题库 章节练习 历年真题 模拟试卷](http://assets.51tk.com/51_sidebar_right_index.jpg)