Knowledge of SQL Server 2008, .Net Technology

Knowledge of SQL Server 2008

Question: Which of the following options is NOT supported by the ON DELETE clause of a FOREIGN KEY constraint of SQL Server 2008?
A
CASCADE

B
DELETE

C
SET NULL

D
SET DEFAULT

Note: Not available
1. Report
Question: Suppose you create a stored procedure and save it in the database with "sp_" prefix. Which of the following statements is true regarding the execution of the stored procedure?
A
The prefix will speed up the execution of the stored procedure.

B
The prefix will slow down the execution of the stored procedure.

C
The performance of the stored procedure is not affected.

D
All of these

Note: Not available
1. Report
Question: Each table in SQL Server 2008 can have up to ______ nonclustered indexes.
A
777

B
888

C
999

D
1000

Note: Not available
1. Report
Question: Analyze the following code which uses the TOP clause of SQL Server 2008:
USE Person GO DECLARE @p AS int SELECT @p=10 SELECT TOP(@p) FROM Employee GO
What Will be the output of the above code?
A
No output is displayed.

B
A list of first 10 employees is displayed from the Person database.

C
An incorrect syntax error is displayed.

D
None of these.

Note: Not available
1. Report
Question: Which of the following is a valid code to remove the key used to encrypt a database using Transparent Data Encryption algorithm?
A
ALTER DATABASE DROP ENCRYPTION KEY

B
DROP DATABASE ENCRYPTION KEY

C
ALTER DATABASE REMOVE ENCRYPTION KEY

D
REMOVE DATABASE ENCRYPTION KEY

Note: Not available
1. Report
Question: What should a computed column be marked as so that SQL Server Database Engine can physically store values in a table?
A
ON

B
WRITE

C
PERSISTED

D
All of these

Note: Not available
1. Report
Question: The output of a Transact SQL query using the GROUPING function of SQL Server 2008 is of ______ return type.
A
varchar

B
boolean

C
int

D
tinyint

Note: Not available
1. Report
Question: What is the data type of the parameter "Audit_file_offset" of function "fn_get_audit_file()" in SQL Server 2008?
A
varchar

B
nvarchar

C
int

D
bigint

Note: Not available
1. Report
Question: Which of the following queries is used to rename a database in SQL Server 2008?
A
sp_renamedb oldname,newname

B
sp_renamedb newname,oldname

C
sp_dbrename oldname,newname

D
sp_rename oldname,newname

Note: Not available
1. Report
Question: Which of the following is the correct precedence order of the data types in SQL Server 2008? 1.xml 2.text 3.bigint 4.image 5.float 6.datetime
A
1,2,3,4,5,6

B
6,5,4,3,2,1

C
1,6,5,3,2,4

D
1,4,2,3,6,5

Note: Not available
1. Report

First Prev 8 9 10 11 Next Last

Question: Which of the following options is NOT supported by the ON DELETE clause of a FOREIGN KEY constraint of SQL Server 2008?

Question: Suppose you create a stored procedure and save it in the database with "sp_" prefix. Which of the following statements is true regarding the execution of the stored procedure?

Question: Each table in SQL Server 2008 can have up to ______ nonclustered indexes.

Question: Analyze the following code which uses the TOP clause of SQL Server 2008:
USE Person GO DECLARE @p AS int SELECT @p=10 SELECT TOP(@p) FROM Employee GO
What Will be the output of the above code?

Question: Which of the following is a valid code to remove the key used to encrypt a database using Transparent Data Encryption algorithm?

Question: What should a computed column be marked as so that SQL Server Database Engine can physically store values in a table?

Question: The output of a Transact SQL query using the GROUPING function of SQL Server 2008 is of ______ return type.

Question: What is the data type of the parameter "Audit_file_offset" of function "fn_get_audit_file()" in SQL Server 2008?

Question: Which of the following queries is used to rename a database in SQL Server 2008?

Question: Which of the following is the correct precedence order of the data types in SQL Server 2008? 1.xml 2.text 3.bigint 4.image 5.float 6.datetime

Question: Which of the following options is NOT supported by the ON DELETE clause of a FOREIGN KEY constraint of SQL Server 2008?

Question: Suppose you create a stored procedure and save it in the database with "sp_" prefix. Which of the following statements is true regarding the execution of the stored procedure?

Question: Each table in SQL Server 2008 can have up to ______ nonclustered indexes.

Question: Analyze the following code which uses the TOP clause of SQL Server 2008:USE Person GO DECLARE @p AS int SELECT @p=10 SELECT TOP(@p) FROM Employee GO What Will be the output of the above code?

Question: Which of the following is a valid code to remove the key used to encrypt a database using Transparent Data Encryption algorithm?

Question: What should a computed column be marked as so that SQL Server Database Engine can physically store values in a table?

Question: The output of a Transact SQL query using the GROUPING function of SQL Server 2008 is of ______ return type.

Question: What is the data type of the parameter "Audit_file_offset" of function "fn_get_audit_file()" in SQL Server 2008?

Question: Which of the following queries is used to rename a database in SQL Server 2008?

Question: Which of the following is the correct precedence order of the data types in SQL Server 2008? 1.xml 2.text 3.bigint 4.image 5.float 6.datetime

Question: Analyze the following code which uses the TOP clause of SQL Server 2008:
USE Person GO DECLARE @p AS int SELECT @p=10 SELECT TOP(@p) FROM Employee GO
What Will be the output of the above code?