.Net Technology

.Net Technology - Upwork

Question: All MDX, DMX and XML/A errors are displayed in the Error List window of the SQL Server 2008. Management Studio.
A
True

B
False

Note: Not available
1. Report
Question: Which of the following stored procedures is used to delete data from the management data warehouse of a Data Collector?
A
core.sp_delete_data

B
core.sp_purge_data

C
core.sp_remove_data

D
None of these

Note: Not available
1. Report
Question: What is the maximum number of processors that can be used in parallel plan execution using the MAXDOP option in SQL Server 2008?
A
32 processors

B
50 processors

C
64 processors

D
75 processors

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

First Prev 16 17 18 19 20 Next Last

Question: All MDX, DMX and XML/A errors are displayed in the Error List window of the SQL Server 2008. Management Studio.

Question: Which of the following stored procedures is used to delete data from the management data warehouse of a Data Collector?

Question: What is the maximum number of processors that can be used in parallel plan execution using the MAXDOP option in 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?

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?