.Net Technology

.Net Technology - Upwork

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
Question: Which of the following features of SQL Server 2008 enables you to limit the memory used by incoming application requests?
A
Hot Add CPU

B
Dynamic management views

C
Resource Governor

D
Backup Compression

Note: Not available
1. Report
Question: Which data type of SQL Server 2008 converts itself into the type of data that is inserted into it?
A
real

B
rowversion

C
type_var

D
sql_variant

E
monetary

Note: Not available
1. Report
Question: Analyze the following command: -o "C:Folder<file_name>" Which of the following statements is true if a file with the file name specified in the above command already exists?
A
An error is generated.

B
The file is overwritten

C
None of these

Note: Not available
1. Report
Question: Multiple CHECK constraints can be applied to a single column and a single CHECK constraint can be applied to multiple columns in SQL Server 2008.
A
True

B
False

Note: Not available
1. Report
Question: A local temporary stored procedure name can contain a maximum of ______ characters.
A
58

B
116

C
128

D
512

Note: Not available
1. Report
Question: Analyze the following code using wild card characters of SQL Server 2008:
SELECT Name FROM person.employees WHERE Name LIKE '[_]n' GO
Which of the following values will be returned by the above code?
A
in

B
sin

C
_n

D
All of these

Note: Not available
1. Report
Question: Which of the following is the default authentication mode for sqlcmd in SQL Server 2008?
A
Windows Authentication

B
SQL Server Authentication

C
IIS Authentication

D
Digest Authentication

Note: Not available
1. Report

First Prev 15 16 17 18 19 Next Last

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?

Question: Which of the following features of SQL Server 2008 enables you to limit the memory used by incoming application requests?

Question: Which data type of SQL Server 2008 converts itself into the type of data that is inserted into it?

Question: Analyze the following command: -o "C:Folder<file_name>" Which of the following statements is true if a file with the file name specified in the above command already exists?

Question: Multiple CHECK constraints can be applied to a single column and a single CHECK constraint can be applied to multiple columns in SQL Server 2008.

Question: A local temporary stored procedure name can contain a maximum of ______ characters.

Question: Analyze the following code using wild card characters of SQL Server 2008:
SELECT Name FROM person.employees WHERE Name LIKE '[_]n' GO
Which of the following values will be returned by the above code?

Question: Which of the following is the default authentication mode for sqlcmd 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?

Question: Which of the following features of SQL Server 2008 enables you to limit the memory used by incoming application requests?

Question: Which data type of SQL Server 2008 converts itself into the type of data that is inserted into it?

Question: Analyze the following command: -o "C:Folder<file_name>" Which of the following statements is true if a file with the file name specified in the above command already exists?

Question: Multiple CHECK constraints can be applied to a single column and a single CHECK constraint can be applied to multiple columns in SQL Server 2008.

Question: A local temporary stored procedure name can contain a maximum of ______ characters.

Question: Analyze the following code using wild card characters of SQL Server 2008:SELECT Name FROM person.employees WHERE Name LIKE '[_]n' GO Which of the following values will be returned by the above code?

Question: Which of the following is the default authentication mode for sqlcmd in SQL Server 2008?

Question: Analyze the following code using wild card characters of SQL Server 2008:
SELECT Name FROM person.employees WHERE Name LIKE '[_]n' GO
Which of the following values will be returned by the above code?