Knowledge of SQL Server 2008, .Net Technology

Knowledge of SQL Server 2008

Question: Which of the following arguments of the fn_get_audit_file() function of SQL Server 2008 specifies the directory indicating the location and audit file set to be read?
A
Initial_file_name

B
File_pattern

C
Audit_file_offset

D
None of these

Note: Not available
1. Report
Question: Analyze the following code snippet: DECLARE @myDate DATETIME2 SELECT @myDate = '2009/10/08 12:35:29.2348 +12:15' SELECT @myDate AS '@myDate' What is the output of the above code?
A
2009-10-08 12:35:29

B
2009/10/08 12:35:29.2348000

C
2009-10-08 12:35:29.2348000

D
2009/10/08 12:35:29

Note: Not available
1. Report
Question: What exactly is Full-Text Catalog in SQL Server 2008?
A
The Full-Text Catalog is an index for searching specific keywords.

B
The Full-Text Catalog is a file which contains full-text indexes.

C
The Full-Text Catalog is an inbuilt function for validating text data.

D
The Full-Text Catalog is a system trigger for checking text validation.

Note: Not available
1. Report
Question: Which of the following clauses of SQL Server 2008 avoids enforcing a constraint when repeated inserts are performed?
A
IDENTITY

B
SPARSE

C
NOT FOR REPLICATION

D
COLLATE

Note: Not available
1. Report
Question: Which of the following roles is required to connect to a Central Management Server?
A
ServerGroupReaderRole

B
ServerGroupAdministratorRole

C
PolicyAdministratorRole

D
db_ssisoperator

Note: Not available
1. Report
Question: What range is supported by the TIME data type in SQL Server 2008?
A
00:00:00.0000000 through 23:59:59.9999999

B
00:00:00.0000000 through 24:00:00.0000000

C
00:00:00.0000000 through 23:59:00.0000000

D
00:00:00.0000000 through 23:59:59.0000000

Note: Not available
1. Report
Question: Which of the following is a valid syntax of the ALTER SERVER AUDIT statement used to enable a server audit?
A
ALTER SERVER AUDIT <audit_name> WITH (ENABLE=TRUE)

B
ALTER SERVER AUDIT <audit_name> SET (ENABLE=TRUE)

C
ALTER SERVER AUDIT <audit_name> WITH (STATE=ON)

D
ALTER SERVER AUDIT <audit_name> SET (STATE=ON)

Note: Not available
1. Report
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

First Prev 5 6 7 8 9 Next Last

Question: Which of the following arguments of the fn_get_audit_file() function of SQL Server 2008 specifies the directory indicating the location and audit file set to be read?

Question: Analyze the following code snippet: DECLARE @myDate DATETIME2 SELECT @myDate = '2009/10/08 12:35:29.2348 +12:15' SELECT @myDate AS '@myDate' What is the output of the above code?

Question: What exactly is Full-Text Catalog in SQL Server 2008?

Question: Which of the following clauses of SQL Server 2008 avoids enforcing a constraint when repeated inserts are performed?

Question: Which of the following roles is required to connect to a Central Management Server?

Question: What range is supported by the TIME data type in SQL Server 2008?

Question: Which of the following is a valid syntax of the ALTER SERVER AUDIT statement used to enable a server audit?

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?