数据库原理与应用

在SQL SERVER中可以使用SET TRANSACTION ISOLATION语句设置事务的隔离级别，SQL SERVER的默认隔离级别是（）。

题目

在SQL SERVER中可以使用SET TRANSACTION ISOLATION语句设置事务的隔离级别，SQL SERVER的默认隔离级别是（）。

如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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.


正确答案：B
解析：Explanation: SQL Server 2000 permits the creation of links to OLE DB data sources called linked servers. After linking to an OLE DB data source, it is possible to reference rowsets from the OLE DB data sources as tables in Transact-SQL statements and to pass commands to the OLE DB data sources and include the resulting rowsets as tables in Transact-SQL statements.

Each distributed query can reference multiple linked servers and can perform. either update or read operations against each individual linked server. A single distributed query can perform. read operations against some linked servers and update operations against other linked servers. The Microsoft OLE DB Provider for Oracle allows distributed queries to query data in Oracle databases.

Incorrect Answers:
A: Replication allows for the coping, distribution, and modification of data across an enterprise. This involves the copying of database data from one server to another. This is not the best solution in this scenario as this will require frequent replication because the reports must be updated several times a day.

C: Data Transformation Services is a set of graphical tools and programmable objects that allows for the extraction, transformation, and consolidation of data from disparate sources into single or multiple destinations. In this scenario, however, the Oracle database needs to be included in a query. Hence, Data Transformation Services are inappropriate.

D: Microsoft ActiveX scripts can be used to add functionality to Data Transformation Services packages, which is a set of graphical tools and programmable objects that allows for the extraction, transformation, and consolidation of data from disparate sources into single or multiple destinations. In this scenario, however, the Oracle database needs to be included in a query. Hence, Data Transformation Services are inappropriate.

第2题：

在SQL*PLUS环境中可以利用DBMS_OUTPUT包中的PUT_LINE方法来回显服务器端变量的值,但在此之前要利用一个命令打开服务器的回显功能,这一命令是()

A. set server on

B. set serverecho on

C. set servershow on

D. set serveroutput on

E. set serverdisplay on


参考答案：D

第3题：

在SQL Server系统中，前后相邻的语句之间可以使用____、____或换行符

分开。


参考答案空格　分号(次序无先后)

第4题：

在SQL SERVER中隐式事务默认是（），要想使用隐式事务可使用SET IMPLICIT_TRANSACTIONS ON，将其切换隐式事务模式。


正确答案:关闭

第5题：

在SQL SERVER2000中，模糊查询可以使用匹配符（）代表任意个字符。

  • A、-
  • B、*
  • C、%
  • D、#

正确答案:C

第6题：

在SQL*PLUS环境中,若想通过执行PL／SQL代码来显示指定的字符串,应该首先做哪项设置()

A.set echo on

B.set output on

C.set serveroutput on

D.set dbms_output on

E.set server_output on


参考答案：C

第7题：

在SQL SERVER中，从游标中读取记录使用（）语句。


正确答案:FETCH

第8题：

在哪里可以查看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中的管理——维护计划


参考答案：C

第9题：

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 syntax
  • B、The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE
  • C、The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value" command
  • D、The server's SQL mode, when globally set on a slave server, applies to events sent from the master

正确答案:A,C

第10题：

在SQL Server2000系统中，每条SELECT语句能够同时为多个变量赋值，每条SET语句只能为一个变量赋值。


正确答案:正确

更多相关问题
相关内容