网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement： SQL>EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE （PLAN => ’SALES_PLAN’， GROUP_OR_SUBPLAN => ’MANAGERS’， CPU_P1 => 100， CPU_P2 =>0， SWITCH_GROUP => ’CLERKS’， SWITCH_TIME_IN_CALL => 600）； A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）
A
The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.
B
The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.
C
The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.
D
The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement： SQLEXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE （PLAN = ’SALES_PLAN’， GROUP_OR_SUBPLAN = ’MANAGERS’， CPU_P1 = 100， CPU_P2 =0， SWITCH_GROUP = ’CLERKS’， SWITCH_TIME_IN_CALL = 600）； A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）A The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.B The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.C The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.D The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.” 相关考题
考题
For which two situations would you use functionality provided by the Resource Manager?()
A. setting idle timeout limits on resource plansB. saving storage space by using compressed backup setsC. creating jobs that will run automatically at a scheduled timeD. assigning priorities to jobs to manage access to system resourcesE. creating alerts to perform notification when tablespaces are low on available space resources
考题
For which two situations would you use functionality provided by the Resource Manager? ()(Choose two.)
A. setting idle timeout limits on resource plansB. saving storage space by using compressed backup setsC. creating jobs that will run automatically at a scheduled timeD. assigning priorities to jobs to manage access to system resourcesE. creating alerts to perform notification when tablespaces are low on available space resources
考题
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?()
A. By default, EM express is available for a database after database creation.B. You can use EM express to manage multiple databases running on the same server.C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.D. You cannot start up or shut down a database Instance by using EM express.E. You can create and configure pluggable databases by using EM express.
考题
You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（） A、 V$SYSSTATB、 V$SESSSTATC、 V$RSRC_PLAND、 V$RSRC_CONSUMER_GROUP
考题
You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group？（） A、 CPU_MTHB、 NEW_CPU_MTHC、 CPU_P1D、 CPU_P2
考题
You disabled the Flashback Database feature by using the following command： SQL ALTER DATABASE FLASHBACK OFF； What would be the effect of this command on the existing flashback logs？（）A、 Flashback logs are not deleted.B、 Flashback logs are deleted automatically.C、 Flashback logs are deleted only if you are using Recovery Manager （RMAN）D、 Flashback logs are deleted only if you are using Oracle Manager Files （OFM）E、 Flashback logs are deleted only if you are using Automatic Storage Management （ASM）
考题
You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page. Which two links should you click to go to the Memory Advisor page？（） A、 Advisor CentralB、 Global AttributesC、 Resource MonitorsD、 Memory ParametersE、 Database Usage StatisticsF、 All Initialization ParametersG、 Automatic Workload Repository
考题
It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）A、cannot be used in RMANB、by starting up the database againC、by using the CATALOG command of RMAND、by using the RECOVER CATALOG command in RMANE、by re-creating the target control file to rebuild the RMAN repository
考题
You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（） A、 RATIOB、 EMPHASISC、 ACTIVE_SESS_POOL_MTHD、 RESOURCE_DEGREE_LIMIT_ABSOLUTE
考题
In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？（）A、CPU usageB、degree of parallelismC、number of open cursorsD、number of sorts performedE、idle time for blocking sessionsF、number of disk I/O operations performedG、number of memory I/O operations performed
考题
For which two situations would you use functionality provided by the Resource Manager？（）A、 setting idle timeout limits on resource plansB、 saving storage space by using compressed backup setsC、 creating jobs that will run automatically at a scheduled timeD、 assigning priorities to jobs to manage access to system resourcesE、 creating alerts to perform notification when tablespaces are low on available space resources
考题
Your company has an Active Directory Domain Services （AD DS） domain. You have a Windows Server 2008 R2 Hyper-V server. You manage the virtual environment by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2. You need to ensure that a user can create new virtual machines （VMs） on only a specific set of servers . The user must not be able to see or manage servers outside of that set within VMM . Which two actions should you perform？（）A、Create a host group. Add the host servers that the user will manage to the host group.B、Create a failover cluster. Join the host servers that the user will manage to the failover cluster.C、Using Authorization Manager， assign the user to a role with the necessary permission to manage the servers by using VMM.D、Using Authorization Manager， assign the user to a role with the necessary permission to manage the servers by using the VMM Self-Service Portal.
考题
单选题You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（）A
RATIOB
EMPHASISC
ACTIVE_SESS_POOL_MTHD
RESOURCE_DEGREE_LIMIT_ABSOLUTE
考题
多选题For which two situations would you use functionality provided by the Resource Manager? （）(Choose two.)Asetting idle timeout limits on resource plansBsaving storage space by using compressed backup setsCcreating jobs that will run automatically at a scheduled timeDassigning priorities to jobs to manage access to system resourcesEcreating alerts to perform notification when tablespaces are low on available space resources
考题
单选题You have a Windows Server 2008 R2 Hyper-V failover cluster. You manage the cluster by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2. You plan to monitor the environment by using Microsoft System Center Operations Manager 2007. You need to identify when Hyper-V server load exceeds specific CPU and memory thresholds， and you must rebalance the environment accordingly. What should you do？（）A
Configure the Placement settings to maximize resources for each of the Hyper-V serversB
Configure Performance and Resource Optimization （PRO） to automatically implement PRO tipsC
Configure the Placement settings for CPU and Memory as Very Important for each of the Hyper-V serversD
Install the Windows Server Operating System Management Pack for Operations Manager 2007， and set the thresholds
考题
单选题You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement： SQLEXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE （PLAN = ’SALES_PLAN’， GROUP_OR_SUBPLAN = ’MANAGERS’， CPU_P1 = 100， CPU_P2 =0， SWITCH_GROUP = ’CLERKS’， SWITCH_TIME_IN_CALL = 600）； A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）A
The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.B
The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.C
The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.D
The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.
考题
单选题You want to enable the user， Scott， to change to the GRP1 consumer group by issuing the following code： SQL EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP （’SCOTT’， ’GRP1’， FALSE）； How will you grant the switch privilege to the user， Scott？（）A
by using the DBMS_SESSION packageB
by granting the DBA roleC
by using the DBMS_RESOURCE_MANAGER packageD
by using the DBMS_RESOURCE_MANAGER_PRIVS package
考题
单选题You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）A
V$SYSSTATB
V$SESSSTATC
V$RSRC_PLAND
V$RSRC_CONSUMER_GROUP
考题
单选题You disabled the Flashback Database feature by using the following command： SQL ALTER DATABASE FLASHBACK OFF； What would be the effect of this command on the existing flashback logs？（）A
Flashback logs are not deleted.B
Flashback logs are deleted automatically.C
Flashback logs are deleted only if you are using Recovery Manager （RMAN）D
Flashback logs are deleted only if you are using Oracle Manager Files （OFM）E
Flashback logs are deleted only if you are using Automatic Storage Management （ASM）
考题
多选题For which two situations would you use functionality provided by the Resource Manager?（）Asetting idle timeout limits on resource plansBsaving storage space by using compressed backup setsCcreating jobs that will run automatically at a scheduled timeDassigning priorities to jobs to manage access to system resourcesEcreating alerts to perform notification when tablespaces are low on available space resources
考题
单选题Your network consists of a single Active Directory domain. Users access and share documents by using a DFS namespace. You need to recommend a solution to manage user access to documents. The solution must meet the following requirements： èAllow for document versioning èAllow for online collaboration What should you recommend？（）A
File Server Resource Manager （FSRM）B
Volume Shadow Copy Service （VSS）C
Microsoft SharePoint Foundation 2010D
Windows System Resource Manager （WSRM）
考题
单选题You have a Windows Server 2008 R2 Hyper-V failover cluster with a single iSCSI logical unit number （LUN） and one highly available virtual machine （HAVM）. You manage the virtual environment by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2. You monitor the environment by using Microsoft System Center Operations Manager 2007 R2. You configure a new virtual machine （VM） by deploying a VHD from the VMM library and placing the VHD on the existing iSCSI LUN. You create a HAVM configuration， and you attach the VHD to the configuration. VMM reports the status of the VMs as Unsupported Cluster Configuration. You need to be able to manage the VMs by using VMM. What should you do？（）A
Move the VHD of one HAVM to a new iSCSI LUN.B
Move the VHD of one HAVM to the system volume of a cluster node.C
Configure Performance and Resource Optimization （PRO） on the Windows Server 2008 R2 cluster nodes.D
Configure Windows System Resource Manager （WSRM） on the Windows Server 2008 R2 cluster nodes.
考题
单选题You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）A
assign users to consumer groupsB
set the resource plan for the instanceC
configure a simple resource plan and specify plan directivesD
configure a complex resource plan and specify plan directives
考题
多选题In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）ACPU usageBdegree of parallelismCnumber of open cursorsDnumber of sorts performedEidle time for blocking sessionsFnumber of disk I/O operations performedGnumber of memory I/O operations performed
考题
多选题Your company has an Active Directory Domain Services （AD DS） domain. You have a Windows Server 2008 R2 Hyper-V server. You manage the virtual environment by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2. You need to ensure that a user can create new virtual machines （VMs） on only a specific set of servers . The user must not be able to see or manage servers outside of that set within VMM . Which two actions should you perform？（）ACreate a host group. Add the host servers that the user will manage to the host group.BCreate a failover cluster. Join the host servers that the user will manage to the failover cluster.CUsing Authorization Manager， assign the user to a role with the necessary permission to manage the servers by using VMM.DUsing Authorization Manager， assign the user to a role with the necessary permission to manage the servers by using the VMM Self-Service Portal.
考题
单选题You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）A
assign users to consumer groupsB
set the resource plan for the instanceC
configure a simple resource plan and specify plan directivesD
configure a complex resource plan and specify plan directives
考题
多选题You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）ACPU usageBdegree of parallelismCnumber of open cursorsDnumber of sorts performedEidle time for blocking sessionsFnumber of disk I/O operations performedGnumber of memory I/O operations performed
考题
单选题You are using Resource Manager to manage system resources. While creating a new database user， you observe that the user is a member of DEFAULT_CONSUMER_GROUP by default. What would be the implications of this？（）A
The Resource Manager plan does not affect the user.B
There must be a plan directive in any of the plans of the group to control the resources.C
The members of the group DEFAULT_CONSUMER_GROUP always have resource restrictions.D
The members of DEFAULT_CONSUMER_GROUP are restrained from accessing the system tables.E
The members of this group can change their group without the database administrator’s intervention.
热门标签
最新试卷