.Net Technology

Question: What is the name of the default instance installed by SQL Server 2008 Express in your computer?
A
sqlinst

B
sqlcmd

C
sqlexpress

D
sqldef

Note: Not available
1. Report
Question: Analyze the following permissions: 1.ALTER permission on the database. 2.CONTROL permission in the database. 3.ALTER ANY SCHEMA permission and CREATE XML SCHEMA COLLECTION permission in the database. Which of the above permissions is/are required to create an XML SCHEMA COLLECTION?
A
1 and 2

B
2 and 3

C
1 and 3

D
1 or 2 or 3

E
1 and 2 and 3

Note: Not available
1. Report
Question: Which of the following statements is true regarding indexes in SQL Server 2008?
A
Modifications made in a table will be faster if the number of indexes is more.

B
Modifications made in a table will be slower if the number of indexes is more.

C
The number of indexes does not affect the modification process of a table.

Note: Not available
1. Report
Question: How many audit action groups are available for a server in SQL Server 2008 to perform different actions on audit data?
A
25

B
30

C
35

D
40

Note: Not available
1. Report
Question: Which of the following data types can be specified as SPARSE?
A
image

B
text

C
nchar

D
geography

Note: Not available
1. Report
Question: Analyze the following code snippet for creating a stored procedure in SQL Server 2008:
CREATE PROCEDURE Person.GetEmployees @LastName nvarchar(50), @FirstName nvarchar(50) AS SET NOCOUNT ON SELECT FirstName, LastName, JobTitle, Department FROM Person.EmployeeDepartment WHERE FirstName = @FirstName AND LastName = @LastName GO
Which of the following is a valid code to execute the GetEmployees stored procedure?
A
EXECUTE Person.GetEmployees N'John', N'Miller'

B
EXECUTE Person.GetEmployees N'John', N'Miller'

C
EXECUTE Person.GetEmployees @FirstName = N'John', @LastName = N'Miller'

D
All of these

Note: Not available
1. Report
Question: Starting from the lowest, arrange the following operators in the order in which they produce results in an SQL WHERE query. 1. >, >=, <, <= 2. <> 3. = 4. LIKE
A
1,4,3,2

B
4,1,2,3

C
3,2,1,4

D
2,4,1,3

Note: Not available
1. Report
Question: What is the default maximum precision of decimal data type in SQL Server 2008?
A
16

B
18

C
38

D
48

Note: Not available
1. Report
Question: What is the maximum number of columns that can be combined into a single composite index key?
A
8

B
16

C
32

D
64

Note: Not available
1. Report
Question: Which of the following values specifies that each instance of the XML data type in column_name can contain multiple top-level elements?
A
DEFAULT

B
CONTENT

C
DOCUMENT

D
FILESTREAM

Note: Not available
1. Report

First Prev 17 18 19 20 21 Next Last

Question: What is the name of the default instance installed by SQL Server 2008 Express in your computer?

Question: Analyze the following permissions: 1.ALTER permission on the database. 2.CONTROL permission in the database. 3.ALTER ANY SCHEMA permission and CREATE XML SCHEMA COLLECTION permission in the database. Which of the above permissions is/are required to create an XML SCHEMA COLLECTION?

Question: Which of the following statements is true regarding indexes in SQL Server 2008?

Question: How many audit action groups are available for a server in SQL Server 2008 to perform different actions on audit data?

Question: Which of the following data types can be specified as SPARSE?

Question: Starting from the lowest, arrange the following operators in the order in which they produce results in an SQL WHERE query. 1. >, >=, <, <= 2. <> 3. = 4. LIKE

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

Question: What is the maximum number of columns that can be combined into a single composite index key?

Question: Which of the following values specifies that each instance of the XML data type in column_name can contain multiple top-level elements?