当前位置:1z0-043题库

问题:

[单选]

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 groups
B . set the resource plan for the instance
C . configure a simple resource plan and specify plan directives
D . configure a complex resource plan and specify plan directive

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. Your job is to manage a SQL Server 2005 database, and there are several indexes in the SQL Server 2005. A stored procedure should be written, and the procedure should be utilized to check the indexes for fragmentation.  From the following four Transact-SQL statements, which one should be utilized achieve the goal?() To achieve the goal, DBCC DBREINDEX should be utilized.。 To achieve the goal, SELECT * FROM sys.indexes should be utilized.。 To achieve the goal, SELECT * FROM sys.dm_db_index_physical_stats should be utilized.。 To achieve the goal, DBCC INDEXDEFRAG should be utilized.。 锅炉水循环的常见的故障有()、()、()、()。 Which is an iSQL*Plus command? () INSERT。 UPDATE。 SELECT。 DESCRIBE。 DELETE。 RENAME。 Which one of the following best describes LTO-5 specifications for native cartridge capacity andthroughput?() 800 GB / 120 MB/sec 。 2.5 TB / 180 MB/sec 。 1.5 TB / 140 MB/sec 。 400 GB / 100 MB/sec。 什么是体育情境中的攻击行为它产生的原因是什么

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?()

参考答案:

  参考解析

本题暂无解析

在线 客服