网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
在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中的管理——维护计划
考题
You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers.You are also the administrator of Oracle relational database management system (RDBMS) server.This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create reports on the SQL Server computer by using the minimum amount of disk space.What should you do?A．Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.B．Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.C．Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.D．Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.
考题
在SQL*PLUS环境中,若想通过执行PL／SQL代码来显示指定的字符串,应该首先做哪项设置()
A.set echo onB.set output onC.set serveroutput onD.set dbms_output onE.set server_output on
考题
在SQL*PLUS环境中可以利用DBMS_OUTPUT包中的PUT_LINE方法来回显服务器端变量的值,但在此之前要利用一个命令打开服务器的回显功能,这一命令是()
A. set server onB. set serverecho onC. set servershow onD. set serveroutput onE. set serverdisplay on
考题
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
考题
下列关于MS SQL Server2000的叙述中，正确的是（）。A、在MS SQL Server2000中不能够处理XML数据B、在MS SQL Server2000中可以方便安全地通过Web访问数据C、在MS SQL Server2000中并没有使现有的OLAP多维数据集在Web上链接和分析D、在MS SQL Server2000中不提供多实例支持，不允许在单个机器上安装多个孤立的SQL Server
考题
假设一系统原来使用Access数据库，现要使用sql server数据库，采用（）方法可以完成两个数据库之间的数据转换工作。A、Sql server的附加数据库功能B、Sql server的还原数据库功能C、在Sql server中可直接打开Access数据库，另存即可。D、Sql server的导入导出功能
考题
假设某一系统，原来使用Access数据库，现在改用SQL server数据库，采用（）方法可以快速完成两个数据库之间的数据转换动作。A、SQL server的附加数据库功能B、SQL server的还原数据库功能C、在SQL server中直接打开Access数据库，另存即可D、使用SQL server的的导入/导出功能
考题
关于SQL Server配置管理器，下面描述错误的是（）A、SQL Server配置管理器用于管理与SQL Server相关联的服务B、SQL Server配置管理器包括：SQL Server服务、SQLServer网络配置、对象资源管理器C、SQL Server配置管理器可以配置SQL Server使用的网络协议D、SQL Server配置管理器可以从客户端计算机管理网络连接配置
考题
用户在连接SQL Server时，既可以使用Windows身份验证也可以使用SQL Server身份验证登录，则SQL Server的验证模式是（）。A、Windows身份验证模式SQLB、Server身份验证模式C、混合身份验证模式D、数据库身份验证模式
考题
在哪里可以查看SQL Server 2008中的当前日志（）。A、SQL Server Management Studio中的安全性——SQLServer日志B、SQL Server Management Studio中的数据库——SQLServer日志C、SQL Server Management Studio中的管理——SQLServer日志D、SQL Server Management Studio中的管理——维护计划
考题
在SQL*PLUS环境中可以利用DBMS_OUTPUT包中的PUT_LINE方法来回显服务器端变量的值，但在此之前要利用一个命令打开服务器的回显功能，这一命令是（）A、set server onB、set serverecho onC、set servershow onD、set serveroutput onE、set serverdisplay on
考题
在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 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时，既可以使用Windows身份验证也可以使用SQL Server身份验证登录，则SQL Server的验证模式是（）。A
Windows身份验证模式SQLB
Server身份验证模式C
混合身份验证模式D
数据库身份验证模式
考题
多选题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
考题
单选题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 a financial services company. Replication is configured between two SQL Server 2005 computers， and the servers are respectively named SQL1 and SQL2. Real-time transactional data is stored by the SQL1. And SQL2 is utilized for reporting. The data on SQL01 should not be changed by SQL2. The publication contains a large amount of data. Since you are the database administrator， you need to make sure that data is replicated from SQL1 to SQL2 in as near real-time as possible to confirm accurate reporting during replication. In addition， you need to make sure that this data is replicated securely. Which action should be performed？（）A
Snapshot replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for a standard subscription.B
Transactional replication should be set on SQL1. And then， SQL2 should be set as a standard subscriber for a standard subscription.C
Merge replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for an updateable subscription.D
Transactional replication should be set on SQL1. And then， SQL2 should be set as a standard subscriber for an updateable subscription.
热门标签
最新试卷
