sql2005en.txt

本实验利用C语言提供的通用软件包

WEBMETHOD 'getOrderDetails' 
(name='AdventureWorks.dbo.getOrderDetails',FORMAT = ALL_RESULTS),   
WSDL =
	A

18.The database of a car manufacturing company contains large amount of data. The data is stored in 
tables having a very complex structure. 
In addition, lot of data is stored in many tables thereby leading to redundancy in the database. 
How will you reduce redundancy in the tables and 
make the data consistent?

-3
	1.Denormalizing the tables
	2.Normalizing the tables
	3.Creating specific data models
	4.Creating the primary and foreign keys in the tables
	B

19.To store the details of shoppers, a Shopper table has been created using the following CREATE 
TABLE statement.
Create table Shopper
(
 cShopperId char(6) not null,
cPassword char(20) not null,
vFirstName varchar(20) not null,
vLastName varchar(20) not null,
vEmailId varchar(20) not null,
vAddress null
)
Some of the shoppers' email id is not available at the time of entering data. 
What should you do so that the message  'NOT AVAILABLE' should be entered when the email 
id of the shopper is not provided?

-2
	1.Use ALTER TABLE command and add a check constraint for the vEmailId attribute.
	2.Use ALTER TABLE command and add a default constraint for the vEmailId attribute.
	3.Use sp_addtype statement to add the user-defined datatype for the vEmailId attribute.
	4.Use sp_bindrule statement to bind a rule to the vEmailId attribute.
	B

20.To check the performance of the system, you require information about each transaction that is 
executing within SQL Server. You need the list and 
the status of all the transactions currently running on the server. Which database object stores this 
information?
-2
	1.sys.dm_exec_requests view
	2.syscomments table
	3.sys.exec_requests view
	4.sysobjects table 
	A

21.You have created a stored procedure named prcDisplayEmpDetails in the AdventureWorks 
database. This procedure displays the Employee Id, and 
Login Id of all the employees. You are also required to display the Manager id and title of the 
employees along with the existing employee details. 
What will you do to implement this in the existing stored procedure?

-2
	1.Delete the prcDisplayEmpDetails stored procedure and create a new one.
	2.Create another procedure displaying the employee id, login id, manager id and title of all 
the employees without deleting the first one.
	3.Alter the prcDisplayEmpDetails stored procedure to display the employee id, login id, 
manager id and title of all the employees.
	4.Create another procedure displaying the manager id and title of all the employees and call 
this procedure from the prcDisplayEmpDetails stored procedure.
	C

22.In which of the following situations will you implement managed code in your database?
 
-2
	1.When you need to perform data access and manipulation operations that can be done 
using T-SQL statements.
	2. When you need to create database objects, such as procedures, functions, or triggers.
	3.When you need to implement complicated programming logic for which you can reuse 
the functionality provided by the .NET base class libraries.
	4.When you need to implement basic programming logic.
	C

23.You give the following command to create an index on the cOrderNo attribute of the Orders table 
using the following statement:
CREATE INDEX idxOrder
on Orders(cOrderNo)
Which of the following command would you use to verify that the index has been created on the 
Orders table?
 
-2
	1.sp_helpindex idxOrder
	2.sp_helpindex Orders
	3.sp_helpindex cOrderNo
	4.sp_helpindex Orders.cOrdNo
	B

24.A relational database contains two relations, A and B. You need to extract records from relation A 
for which the related records do not appear in relation B. 
Which of the following operators will you use?
-2
	1.Difference
	2.Intersect
	3.Union
	4.Project 
	A

25.In which of the following application architecture are all the elements of the business applications 
joined in a single executable unit:
-1
	1.Single-Tier Architecture 
	2.Two-Tier Architecture
	3.Three-Tier Architecture
	4. n-Tier Architecture 
	A

26.Which type of aggregate function is used to calculate the average of all the values in the column?
-1
	1.AVG
	2.SUM
	3.MAX
	4.COUNT
	A


27.Which type of trigger is fired when the data is modified in the table?
-1
	1.DELETE
	2.INSERT
	3.UPDATE
	4.INSTEAD OF
	C


28.How will you execute a procedure?
-1
	1.EXEC proc_name
	2.proc_name
	3.RUN proc_name
	4.proc_name EXEC
	A


29.Which class in CLR integration with SQL Server 2005 allows you to send T-SQL commands to 
the database server and to call stored procedures or functions?
-1
	1.SqlCommand
	2.SqlConnection
	3.SqlContext
	4.SqlPipe
	A

30.Which of the following options is used to encrypt the text of the view in the syscomments view?
-1
	1.WITH ENCRYPT
	2.ENCRYPT
	3.WITH ENCRYPTION
	4.WITH CHECK OPTION
	C


31.
-
	1.
	2.
	3.
	4.


32.
-
	1.
	2.
	3.
	4.


33.
-
	1.
	2.
	3.
	4.


34.
-
	1.
	2.
	3.
	4.
35.
-
	1.
	2.
	3.
	4.


36.
-
	1.
	2.
	3.
	4.


37.
-
	1.
	2.
	3.
	4.


38.
-
	1.
	2.
	3.
	4.


39.
-
	1.
	2.
	3.
	4.


40.
-
	1.
	2.
	3.
	4.


41.
-
	1.
	2.
	3.
	4.


42.
-
	1.
	2.
	3.
	4.


43.
-
	1.
	2.
	3.
	4.


44.
-
	1.
	2.
	3.
	4.


45.
-
	1.
	2.
	3.
	4.

46.
-
	1.
	2.
	3.
	4.


47.
-
	1.
	2.
	3.
	4.


48.
-
	1.
	2.
	3.
	4.


49.
-
	1.
	2.
	3.
	4.


50.
-
	1.
	2.
	3.
	4.


51.
-
	1.
	2.
	3.
	4.


52.
-
	1.
	2.
	3.
	4.


53.
-
	1.
	2.
	3.
	4.


54.
-
	1.
	2.
	3.
	4.


55.
-
	1.
	2.
	3.
	4.


56.
-
	1.
	2.
	3.
	4.