You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session： ALTER SESSION ENABLE RESUMABLE； Which command could you issue to enable the resumable sp

题目

You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session： ALTER SESSION ENABLE RESUMABLE； Which command could you issue to enable the resumable space allocation feature at the session level？（）

A、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5；
B、 ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5；
C、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300；
D、 ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300；

参考答案和解析

正确答案:C

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

You enable the Windows Sidebar feature on your computer. You discover that you are unable to access the desktop icons that appear beneath the Windows Sidebar feature. You need to access these desktop icons.What are two possible ways to achieve this goal?（）

A.A

B.B

C.C

D.D

E.E

参考答案：A, C

第2题：

You connect your computer to a wireless network. You discover that this new connection fails to show in the Connect to a network window.You need to view this connection in the Connect to a network window.What should you do?（）

A.A

B.B

C.C

D.D

参考答案：D

第3题：

The questions will help you to discover whether the interviewee( 被接见者) has all the necessary abilities and qualities to match your____ picture of the ideal person for the job.

A、mental

B、local

C、station

D、asleep

正确答案：A

第4题：

Talk to anyone in the drug industry, you’ll soon discover that the science of genetics is the biggest thing to hit drug research since penicillin was discovered.

[A] or

[B] so

[C] for

[D] and

正确答案：D

第5题：

You install Windows Vista on a new computer by using the retail installation media.You install a new hardware device. You are not prompted for any drivers and the installation completes successfully.You discover that an updated driver is available for the hardware device.You need to install the updated driver.What should you do?（）

A.A

B.B

C.C

D.D

参考答案：C

第6题：

You share your computer with other users. You install a new Microsoft add-on to view videos on the computer. You discover that this add-on conflicts with existing add-ons that other users frequently require.You need to ensure that you are able to view videos without affecting other users.What should you do?（）

A.A

B.B

C.C

D.D

参考答案：C

第7题：

You install a new hardware router that provides wireless network connectivity between your computer and the Internet. You connect to the router by using a wireless network adapter.Your computer is able to access the Internet but is unable to discover other computers in the local wireless network.You need to configure the wireless connection to allow your computer to discover other computers.What should you do?（）

A.A

B.B

C.C

D.D

参考答案：A

第8题：

You are the administrator of a SQL Server computer. Users report that the database times out when they attempt to modify data. You use the Current Activity window to examine locks held in the database as shown in the following screenshot.

You need to discover why users cannot modify data in the database, but you do not want to disrupt normal database activities. What should you do?

A．Use the spid 52 icon in the Current Activity window to discover which SQL statement is being executed

B．Use the sp_who stored procedure to discover who is logged in as spid 52

C．Use SQL Profiler to capture the activity of the user who is logged in as spid 52

D．Use System Monitor to log the locks that are granted in the database

正确答案：A
解析：Explanation: The current activity window in SQL Server Enterprise Manager can be used to perform. ad hoc monitoring of an instance of SQL Server. This allows for the quick analysis of the volume and general types of activity on the system and can indicate current blocked and blocking transactions, currently connected users on an instance of SQL Server and the last statement executed and locks that are in effect on the database.

In the screen shot of current activity window the icon, labeled spid 51, indicates that a database lock is in place; the second icon, labeled spid 52, can be used to identify the process that is blocking one or more connections; and the third icon, labeled spid 53, can be used to identify the process that is being blocked by another connection

Incorrect Answers:
B: The system stored procedure sp_lock can be used to return a result set that contains information about resources that are locked and the sp_who stored procedure provides information about current SQL Server 2000 users and processes. The information returned by the sp_who procedure can be filtered to return only current non-idle processes. This makes it possible to identify which resources are being locked and which processes are responsible for creating those locks. These stored procedures require more resources and more administrative effort than the Current Activity window. It is therefore not the best answer.

C: The SQL profiler is not the best tool to immediately solve the locking problem. It could be used at a later moment if a long-term solution to the problem is required. SQL profiler would require more system resources and might impact normal database activities.

Note: SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of SQL Server. Data pertaining to an event can be captured and saved to a file or SQL Server table to be analyzed at a later date. It can be is used to step through problem queries to find the cause of the problem; to find and diagnose slow-running queries; to capture the series of SQL statements that led to a problem; and to monitor the performance of SQL Server to tune workloads.

D: SQL Server provides objects and counters that can be used by System Monitor in a Windows 2000 or by Performance Monitor in Windows NT 4.0 to monitor the system performance of computers running an instance of SQL Server. However, these counters are used for statistics and alerts and they cannot, in a direct way, be used to track down the cause of the locking problem.

第9题：

You are the administrator of an Active Directory domain named Auser reports that he cannot log on to a Windows Server 2003 computer that containsa critical application.You discover that the organizational unit (OU) in which the server is located wasdeleted. You discover that the user rights for this server are controlled by GroupPolicy.You need to restore access to the server. You need to achieve this goal by using theminimum amount of administrative effort.What should you do?（）

A. Perform a normal restoration of the System State data for the domain controller. Force replication.

B. Perform an authoritative restoration of the System State data for the domain controller. Mark the OU for replication.

C. Re-create the OU that was deleted. Reapply Group Policy, and then add the computer account and any necessary users or groups.

D. Perform an Automated System Recovery (ASR) restoration on the domain controller.

参考答案：B

第10题：

You have a print server named Server1 that runs Windows Server 2012 R2. You discover that when there are many pending print jobs， the system drive occasionally runs out of free space. You add a new hard disk to Server1. You create a new NTFS volume. You need to prevent the print jobs from consuming disk space on the system volume. What should you modify？（）

A、the properties of the Print Spooler service
B、the Print Server Properties
C、the properties of each shared printer
D、the properties on the new volume

正确答案:B

You discover an

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容