网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
在SQL SERVER中可以使用SET TRANSACTION ISOLATION语句设置事务的隔离级别，SQL SERVER的默认隔离级别是（）。
参考答案
更多 “在SQL SERVER中可以使用SET TRANSACTION ISOLATION语句设置事务的隔离级别，SQL SERVER的默认隔离级别是（）。” 相关考题
考题
在哪里可以查看SQL Server 2008中的当前日志()。
A.SQL Server Management Studio中的安全性——SQL Server日志B.SQL Server Management Studio中的数据库——SQL Server日志C.SQL Server Management Studio中的管理——SQL Server日志D.SQL Server Management Studio中的管理——维护计划
考题
在SQL server 2000中，小王可以正常地使用某一表上的索引，但却无法使用该表某一列上的全文索引，则在下列选项中最有可能导致这种情况的原因是（）服务没有启动.A、Microsoft searchB、SQL server AgentC、MS SQL SERVERD、Distribute Transaction coordinator
考题
Which two statements describe the behavior of the server's SQL mode?（）A、The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntaxB、The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATEC、The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value" commandD、The server's SQL mode, when globally set on a slave server, applies to events sent from the master
考题
SQL Server 2000提供的服务中，管理SQL Server周期性行为的安排，并在发生错误时通知系统管理员的是（）A、MS SQL ServerB、SQL Server AgentC、MS DTC（Distributed Transaction Coordinator）D、Microsoft Server Service
考题
在SQL*PLUS环境中，若想通过执行PL/SQL代码来显示指定的字符串，应该首先做哪项设置（）A、set echo onB、set output onC、set serveroutput onD、set dbms_output onE、set server_output on
考题
You need to resolve the blocking issue that is affecting the performance of the CRM system. What should you do?（）A、Replace the named query with an SQL view.B、Set the transaction isolation level to serializable in the named query.C、Set the source database to use snapshot isolation.D、Set the transaction isolation level to repeatable read in the named query.
考题
公司A有两台SQL SERVER 2005服务器，分别名为SQL1和SQL2。从SQL1到SQL2正在利用SQL SERVER Agent缺省计划设置进行着事务日志传送。你需要重新配置一下事务日志传送作业的设置，以使传送滞后时间达到最小，你应该怎么做？（）A、在SQL1上，设置事务日志备份作业的执行计划为每分钟执行一次。在SQL2上 ，日志传送的复制作业和还原作业维持默认的计划设置不变。B、在SQL1上，设置事务日志备份作业的执行计划为SQL Server Agent 启动时自动启动执行。在SQL2上，设置日志传送的复制作业和还原作业的执行计划为SQL Server Agent 启动时自动启动执行。C、在SQL1上，维持事务日志备份作业为缺省设置不变。在SQL2上，设置日志传送的复制作业和还原作业的执行计划为SQL Server Agent 启动时自动启动执行。D、在SQL1上，设置事务日志备份作业的执行计划为每分钟执行一次。在SQL2上，设置日志传送的复制作业和还原作业的执行计划为每分钟执行一次。
考题
TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings. You need to reconfigure transaction log shipping to provide minimum latency on SQL2. What should you do？（）A、On SQL1， reschedule the transaction log backup job so that it occurs every minute. On SQL2， maintain default schedule settings for both the log shipping copy and the restore jobs.B、On SQL1，change the schedule type for the transaction log backup to Start automatically when SQL server Agent starts. On SQL2， change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server gent starts.C、On SQL1， maintain default schedule settings for the transaction log backup job. On SQL2， change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL server Agent starts.D、On SQL1， reschedule the transaction log backup job so that it occurs every minute. On SQL2， reschedule both the log shipping copy and the restore jobs so that they occur every minute.
考题
You need to ensure that the company’s standard password policy is enforced for all logins that areused to access SQL Server 2005.Which two actions should you perform？（）A、Set the appropriate local password policies for all computers on which SQL Server is installed.B、Set the server authentication mode of all SQL Server instances to Windows Authentication mode.C、Install all instances of SQL Server 2005 on computers that run Windows Server 2003 or later.D、Create SQL Server logins that have CHECK_POLICY enabled.
考题
单选题SQL Server 2000提供的服务中，管理SQL Server周期性行为的安排，并在发生错误时通知系统管理员的是（）A
MS SQL ServerB
SQL Server AgentC
MS DTC（Distributed Transaction Coordinator）D
Microsoft Server Service
考题
多选题Which two statements describe the behavior of the server's SQL mode?（）AThe server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntaxBThe server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATECThe server's SQL mode can be changed at the session level with a SET SESSION sql_mode=new_value commandDThe server's SQL mode, when globally set on a slave server, applies to events sent from the master
考题
填空题在SQL Server中主要是通过使用（）运行Transact-SQL语句。
热门标签
最新试卷