Knowledge of SQL Server 2008, .Net Technology

Knowledge of SQL Server 2008

Question: How many groupings are generated when CUBE is used with the GROUP BY clause of SQL Server 2008?
A
n (n= number of expressions in the element list passed to CUBE)

B
n+1 (n= number of expressions in the element list passed to CUBE)

C
2^n (n= number of expressions in the element list passed to CUBE)

D
2^n+1 (n= number of expressions in the element list passed to CUBE)

Note: Not available
1. Report
Question: Which of the following Audit objects primarily describes the destination where the audit data of SQL Server 2008 gets stored?
A
Server Audit object

B
Server Audit Specification object

C
Database Audit Specification object

D
None of these

Note: Not available
1. Report
Question: Windows Security log can be specified as a target for Audit in SQL Server 2008.
A
True

B
False

Note: Not available
1. Report
Question: Which of the following is a valid code to delete a clustered index with a PRIMARY KEY constraint in SQL Server 2008?
A
LTER TABLE Production.ProductCost DROP CONSTRAINT PK_Product WITH (ONLINE = ON) GO

B
ALTER TABLE Production.ProductCostHistory DROP CONSTRAINT PK_Product DROP INDEX Index_Product WITH (ONLINE = ON) GO

C
DROP INDEX Index_Product ON Production.ProductCost GO

D
None of these

Note: Not available
1. Report
Question: What is the default timeout for login to sqlcmd while you try to connect to a server?
A
5 seconds

B
8 seconds

C
10 seconds

D
15 seconds

E
1 minute

Note: Not available
1. Report
Question: What is the default precision of the date data type in SQL Server 2008?
A
4 digits

B
6 digits

C
8 digits

D
10 digits

Note: Not available
1. Report
Question: What amount of storage is required by a date variable in SQL Server 2008?
A
3 bytes

B
5 bytes

C
6 bytes

D
8 bytes

Note: Not available
1. Report
Question: PRIMARY KEY constraint defaults to ______ index.
A
Clustered

B
Nonclustered

C
None of these

Note: Not available
1. Report
Question: Which of the following is a valid code to change the index created on a column of a table to page compression?
A
ALTER INDEX Index_Product ON Table1 WITH ( DATA_COMPRESSION = PAGE ) GO

B
ALTER INDEX Index_Product ON Table1 SET ( DATA_COMPRESSION = PAGE ) GO

C
ALTER INDEX Index_Product ON Table1 REBUILD WITH ( DATA_COMPRESSION = PAGE ) GO

D
ALTER INDEX Index_Product ON Table1 REBUILD SET ( DATA_COMPRESSION = PAGE ) GO

Note: Not available
1. Report
Question: What is the return type of the value returned by @@DATEFIRST in SQL Server 2008?
A
datetime

B
date

C
int

D
tinyint

Note: Not available
1. Report

First Prev 3 4 5 6 7 Next Last

Question: How many groupings are generated when CUBE is used with the GROUP BY clause of SQL Server 2008?

Question: Which of the following Audit objects primarily describes the destination where the audit data of SQL Server 2008 gets stored?

Question: Windows Security log can be specified as a target for Audit in SQL Server 2008.

Question: Which of the following is a valid code to delete a clustered index with a PRIMARY KEY constraint in SQL Server 2008?

Question: What is the default timeout for login to sqlcmd while you try to connect to a server?

Question: What is the default precision of the date data type in SQL Server 2008?

Question: What amount of storage is required by a date variable in SQL Server 2008?

Question: PRIMARY KEY constraint defaults to ______ index.

Question: Which of the following is a valid code to change the index created on a column of a table to page compression?

Question: What is the return type of the value returned by @@DATEFIRST in SQL Server 2008?