A local temporary stored procedure name can contain a maximum of __________ characters.
58 0.0%
116 100.0%
128 0.0%
512 0.0%
All MDX, DMX and XML/A errors are displayed in the Error List window of the SQL Server 2008. Management Studio.
An identifier denoting a global temporary object in SQL Server 2008 starts with a ______ sign.
At sign(@) 0.0%
Double number(##) 100.0%
Underscore(_) 0.0%
None of the above 0.0%
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...
EXECUTE Person.GetEmployees N'John', N'Miller' 0.0%
EXEC Person.GetEmployees @LastName = N'Miller', @FirstName = N'John' 0.0%
EXECUTE Person.GetEmployees @FirstName = N'John', @LastName = N'Miller' 0.0%
All of the above 100.0%
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?
2009-10-08 12:35:29 0.0%
2009/10/08 12:35:29.2348000 0.0%
2009-10-08 12:35:29.2348000 100.0%
2009/10/08 12:35:29 0.0%
Analyze the following code snippet: DECLARE @myTime TIME(4) = '02:02:02.234567 +01:01' SELECT @myTime AS '@myTime' What is the output of the above code?
02:02:02.2345 0.0%
02:02:02 0.0%
02:02:02.2346 100.0%
An error is displayed 0.0%
Analyze the following code used to update a Common Table Expression: USE demodb GO DECLARE @a TABLE (ID int, Value int); DECLARE @b TABLE (ID int, Value int); INSERT @a VALUES (1, 10), (2, 20); IN...
ID Value ----- ----- 1 100 2 200 0.0%
ID Value ----- ----- 1 10 2 100 0.0%
ID Value ----- ----- 1 10 2 200 0.0%
ID Value ----- ----- 1 100 2 100 100.0%
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 c...
in 0.0%
sin 0.0%
_n 100.0%
All of the above 0.0%
Analyze the following code which uses the TOP clause of SQL Server 2008: USE Person GO DECLARE @p AS int SELECT @p=10 SELECT TOP(@p) FROM Employee GO What Will be the output of the above code?
No output is displayed. 0.0%
A list of first 10 employees is displayed from the Person database. 0.0%
An incorrect syntax error is displayed. 100.0%
None of the above. 0.0%
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?
An error is generated. 100.0%
The file is overwritten. 0.0%
None of the above. 0.0%
Analyze the following data types and schemas: 1.The SQL Server system data type. 2.The default schema of the current user in the current database. 3.The dbo schema in the current database. In whi...
3,2,1 0.0%
2,3,1 0.0%
3,1,2 0.0%
1,2,3 100.0%
Any order 0.0%
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 databa...
1 and 2 0.0%
2 and 3 0.0%
1 and 3 0.0%
1 or 2 or 3 33.0%
1 and 2 and 3 66.0%
Columns marked with which of the following constraints/properties allow null values to be inserted in them?
PRIMARY KEY 0.0%
UNIQUE 50.0%
IDENTITY 0.0%
FOREIGN KEY 50.0%
Each table in SQL Server 2008 can have up to ______ nonclustered indexes.
777 0.0%
888 0.0%
999 100.0%
1000 0.0%
For which of the following data types can a COLLATE clause be applied?
text 50.0%
int 0.0%
varchar 50.0%
bigint 0.0%
How many audit action groups are available for a server in SQL Server 2008 to perform different actions on audit data?
25 0.0%
30 0.0%
35 33.0%
40 66.0%
How many groupings are generated when CUBE is used with the GROUP BY clause of SQL Server 2008?
n (n= number of expressions in the element list passed to CUBE) 0.0%
n+1 (n= number of expressions in the element list passed to CUBE) 0.0%
2^n (n= number of expressions in the element list passed to CUBE) 100.0%
2^n+1 (n= number of expressions in the element list passed to CUBE) 0.0%
In which of the following statements can TOP clause be used in SQL Server 2008?
Only SELECT 0.0%
Only SELECT and INSERT 0.0%
Only SELECT, INSERT, UPDATE, DELETE 0.0%
Only SELECT, INSERT, UPDATE, MERGE, DELETE 100.0%
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.
PRIMARY KEY constraint defaults to __________ index.
Clustered 100.0%
Nonclustered 0.0%
None of the above 0.0%
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
1,4,3,2 0.0%
4,1,2,3 100.0%
3,2,1,4 0.0%
2,4,1,3 0.0%
Suppose e1 and e2 denote two decimal expressions with precisions p1 and p2 and scales s1 and s2, respectively. What is the result precision of the following operation on the two expressions? Opera...
p1 - s1 + s2 + max(6, s1 + p2 + 1) 0%
max(s1, s2) + max(p1 - s1, p2 - s2) + 1 0%
p1 + p2 + 1 0%
Suppose you create a stored procedure and save it in the database with "sp_" prefix. Which of the following statements is true regarding the execution of the stored procedure?
The prefix will speed up the execution of the stored procedure. 0.0%
The prefix will slow down the execution of the stored procedure. 33.0%
The performance of the stored procedure is not affected. 66.0%
The login timeout when you try to connect to a server must be a number between __________.
0 and 66020 0.0%
1 and 65530 0.0%
0 and 65534 100.0%
1 and 65535 0.0%
The output of a Transact SQL query using the GROUPING function of SQL Server 2008 is of __________ return type.
varchar 0.0%
boolean 0.0%
int 0.0%
tinyint 100.0%
The regular identifiers of SQL Server 2008 may contain a range of _____________ characters.
1 to 116 0.0%
1 to 127 0.0%
1 to 128 100.0%
1 to 512 0.0%
The Server Audit object and the Server Audit Specification object of SQL Server 2008 share a __________ relationship.
One-to-one 66.0%
One-to-many 33.0%
Many-to-one 0.0%
Many-to-many 0.0%
User defined data type columns can be designated with ROWGUIDCOL.
What amount of storage is required by a date variable in SQL Server 2008?
3 bytes 100.0%
5 bytes 0.0%
6 bytes 0.0%
8 bytes 0.0%
What exactly is Full-Text Catalog in SQL Server 2008?
The Full-Text Catalog is an index for searching specific keywords. 0.0%
The Full-Text Catalog is a file which contains full-text indexes. 100.0%
The Full-Text Catalog is an inbuilt function for validating text data. 0.0%
The Full-Text Catalog is a system trigger for checking text validation. 0.0%
What happens to the audit records if a failure to write the Audit event does NOT trigger the SQL Server instance to shut down?
The server blocks any new activity to be performed to the SQL Server instance. 0.0%
Audit events are buffered in memory until they can be flushed to the target. 100.0%
The audit is automatically disabled. 0.0%
An error is displayed. 0.0%
What is returned by NULLIF if the two expressions that it compares are NOT equal?
It returns the first expression. 100.0%
It returns the second expression. 0.0%
It returns a null value. 0.0%
It returns an error. 0.0%
What is the data type of the parameter "Audit_file_offset" of function "fn_get_audit_file()" in SQL Server 2008?
varchar 0.0%
nvarchar 0.0%
int 0.0%
bigint 100.0%
What is the default maximum precision of decimal data type in SQL Server 2008?
16 0.0%
18 50.0%
38 50.0%
48 0.0%
What is the default precision of the date data type in SQL Server 2008?
4 digits 0.0%
6 digits 0.0%
8 digits 0.0%
10 digits 100.0%
What is the default precision of the TIME data type in SQL Server 2008?
5 digits 0.0%
6 digits 0.0%
7 digits 100.0%
10 digits 0.0%
What is the default timeout for login to sqlcmd while you try to connect to a server?
5 seconds 0.0%
8 seconds 100.0%
10 seconds 0.0%
15 seconds 0.0%
1 minute 0.0%
What is the default value of the SORT_IN_TEMPDB clause of the relational_index_option specified at the time of creation of an index on a table in SQL Server 2008?
ON 0.0%
OFF 100.0%
TRUE 0.0%
FALSE 0.0%
What is the function of DBCC CHECKDB command in SQL Server 2008?
It checks the allocation of all the objects in the specified database. 33.0%
It checks the structural integrity of all the objects in the specified database. 33.0%
It checks for consistency in and between system tables in the specified database. 0.0%
It checks the consistency of disk space allocation structures of a specified database. 33.0%
What is the maximum number of columns that can be combined into a single composite index key?
8 0.0%
16 100.0%
32 0.0%
64 0.0%
What is the maximum number of processors that can be used in parallel plan execution using the MAXDOP option in SQL Server 2008?
32 processors 0.0%
50 processors 0.0%
64 processors 100.0%
75 processors 0.0%
What is the maximum value for the sum of the values of MIN_CPU_PERCENT and MIN_MEMORY_PERCENT for all the resource pools of SQL Server?
50 0.0%
75 0.0%
100 0.0%
150 0.0%
200 100.0%
What is the name of the default instance installed by SQL Server 2008 Express in your computer?
sqlinst 0.0%
sqlcmd 0.0%
sqlexpress 100.0%
sqldef 0.0%
What is the return type of the value returned by @@DATEFIRST in SQL Server 2008?
datetime 0.0%
date 0.0%
int 0.0%
tinyint 100.0%
What range is supported by the TIME data type in SQL Server 2008?
00:00:00.0000000 through 23:59:59.9999999 100.0%
00:00:00.0000000 through 24:00:00.0000000 0.0%
00:00:00.0000000 through 23:59:00.0000000 0.0%
00:00:00.0000000 through 23:59:59.0000000 0.0%
What should a computed column be marked as so that SQL Server Database Engine can physically store values in a table?
ON 0.0%
WRITE 0.0%
PERSISTED 100.0%
Which data type of SQL Server 2008 converts itself into the type of data that is inserted into it?
real 0.0%
rowversion 0.0%
type_var 0.0%
sql_variant 100.0%
monetary 0.0%
Which function/functions are performed by the following statement? DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)
It checks the current iDentity fielD value of the specifieD table. 50.0%
It sets the identity field value to the new reseed value. 50.0%
It sets the identity field value to 1. 0.0%
All of the above. 0.0%
Which of the following are valid DATETIME functions in SQL Server 2008?
SYSDATE() 0.0%
SYSTIME() 0.0%
SYSDATETIME() 50.0%
SYSUTCDATETIME() 50.0%
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?
Initial_file_name 0.0%
File_pattern 100.0%
Audit_file_offset 0.0%
None of the above 0.0%
Which of the following Audit objects primarily describes the destination where the audit data of SQL Server 2008 gets stored?
Server Audit object 100.0%
Server Audit Specification object 0.0%
Database Audit Specification object 0.0%
Which of the following clauses of SQL Server 2008 avoids enforcing a constraint when repeated inserts are performed?
IDENTITY 100.0%
SPARSE 0.0%
NOT FOR REPLICATION 0.0%
COLLATE 0.0%
Which of the following code snippets causes only partition number 1 to be rebuilt while changing the compression of a partitioned table?
ALTER TABLE Table1 REBUILD WITH (DATA_COMPRESSION = PAGE) 0.0%
ALTER TABLE Table1 REBUILD PARTITION = 1 WITH (DATA_COMPRESSION = NONE) GO 100.0%
ALTER TABLE Table1 REBUILD PARTITION ALL WITH (DATA_COMPRESSION = PAGE ON PARTITIONS(1) ) 0.0%
All of the above 0.0%
Which of the following commands is used to connect to a named instance of SQL Server using the sqlcmd utility of SQL Server?
sqlcmd -C myServerinstanceName 0.0%
sqlcmd -S instanceName 0.0%
sqlcmd -C instanceName 0.0%
sqlcmd -S myServerinstanceName 100.0%
Which of the following commands is used to run a Transact-SQL script file by using sqlcmd?
sqlcmd -S myServerinstanceName -i C:
ewScript.sql 100.0%
sqlcmd -S instanceName -o C:
ewScript.sql 0.0%
sqlcmd -S myServerinstanceName -r C:
ewScript.sql 0.0%
sqlcmd -S instanceName -i C:
ewScript.sql 0.0%
Which of the following commands is used to save the output to a text file after you run a Transact-SQL script using sqlcmd?
sqlcmd -S instanceName -o C:
ew.txt 0.0%
sqlcmd -S instanceName -i C:myScript.sql -o C:
ew.txt 0.0%
sqlcmd -S myServerinstanceName -o C:
ew.txt 0.0%
sqlcmd -S myServerinstanceName -i C:myScript.sql -o C:
ew.txt 100.0%
Which of the following commands is used to start the Resource Governor in SQL Server 2008?
ALTER Resource Governor Enable 0.0%
ALTER Resource Governor Reconfigure 100.0%
ALTER Resource Governor Set 0.0%
None of the above 0.0%
Which of the following compression features have been introduced in SQL Server 2008 that were NOT supported by SQL Server 2005?
Row-level compression 33.0%
Page-level compression 33.0%
Data file level compression 0.0%
Backup level compression 33.0%
Which of the following counters are used to monitor compression of the whole instance of SQL Server?
Page compression attempts/sec 50.0%
Row compression/sec 0.0%
Pages compressed/min 0.0%
Pages compressed/sec 50.0%
Rows compressed/min 0.0%
Which of the following data types are supported by SQL Server 2008?
date 28.0%
datetime 28.0%
datetime1 0.0%
datetime2 28.0%
datetimeoffset 14.0%
Which of the following data types can be specified as SPARSE?
image 0.0%
text 0.0%
nchar 100.0%
geography 0.0%
Which of the following default passwords is used by sqlcmd if -P option is used at the end of the command prompt without a password?
0000 0.0%
NULL 100.0%
1234 0.0%
None of the above 0.0%
Which of the following encryption algorithms are used by the Transparent Data Encryption security mechanism of SQL Server 2008?
Tiny Encryption Algorithm 0.0%
Advanced Encryption Standard(AES) 50.0%
Blowfish 0.0%
Triple Data Encryption Standard(3DES) 50.0%
Which of the following evaluation modes of Policy-Based Management CANNOT be automated in SQL Server 2008?
On demand 100.0%
On change: prevent 0.0%
On change: log only 0.0%
On schedule 0.0%
Which of the following features is used by SQL Server Audit to create and manage audits in SQL Server 2008?
System stored procedures 0.0%
Triggers 100.0%
SQL DDL syntax 0.0%
None of the above 0.0%
Which of the following features of SQL Server 2008 enables you to limit the memory used by incoming application requests?
Hot Add CPU 0.0%
Dynamic management views 0.0%
Resource Governor 100.0%
Backup Compression 0.0%
Which of the following features of SQL Server 2008 evaluates servers for compliance with a set of predefined conditions and prevents making undesirable changes to servers?
Data Compression 0.0%
Resource Governor 0.0%
Policy-Based Management 100.0%
Auditing 0.0%
Which of the following formats are supported by the language_term argument while altering a full-text stoplist in SQL Server 2008?
Integer 50.0%
Binary 0.0%
Decimal 0.0%
Hexadecimal 50.0%
Which of the following is a valid code to change the index created on a column of a table to page compression?
ALTER INDEX Index_Product ON Table1 WITH ( DATA_COMPRESSION = PAGE ) GO 0.0%
ALTER INDEX Index_Product ON Table1 SET ( DATA_COMPRESSION = PAGE ) GO 0.0%
ALTER INDEX Index_Product ON Table1 REBUILD WITH ( DATA_COMPRESSION = PAGE ) GO 100.0%
ALTER INDEX Index_Product ON Table1 REBUILD SET ( DATA_COMPRESSION = PAGE ) GO 0.0%
Which of the following is a valid code to delete a clustered index with a PRIMARY KEY constraint in SQL Server 2008?
ALTER TABLE Production.ProductCost DROP CONSTRAINT PK_Product WITH (ONLINE = ON) GO 100.0%
ALTER TABLE Production.ProductCostHistory DROP CONSTRAINT PK_Product DROP INDEX Index_Product WITH (ONLINE = ON) GO 0.0%
DROP INDEX Index_Product ON Production.ProductCost GO 0.0%
Which of the following is a valid code to remove the key used to encrypt a database using Transparent Data Encryption algorithm?
ALTER DATABASE DROP ENCRYPTION KEY 0.0%
DROP DATABASE ENCRYPTION KEY 100.0%
ALTER DATABASE REMOVE ENCRYPTION KEY 0.0%
REMOVE DATABASE ENCRYPTION KEY 0.0%
Which of the following is a valid syntax of the ALTER SERVER AUDIT statement used to enable a server audit?
ALTER SERVER AUDIT <audit_name> WITH (ENABLE=TRUE) 0.0%
ALTER SERVER AUDIT <audit_name> SET (ENABLE=TRUE) 0.0%
ALTER SERVER AUDIT <audit_name> WITH (STATE=ON) 100.0%
ALTER SERVER AUDIT <audit_name> SET (STATE=ON) 0.0%
Which of the following is the correct order of steps to be followed while using the Transparent Data Encryption security feature of SQL Server 2008?
1. Create a database encryption key. 2. Create or obtain a certificate protected by the encryption key. 3. Create a master key and protect it by the certificate. 4. Set the database to use encryption. 0.0%
1. Create a database encryption key. 2. Create a master key. 3. Create or obtain a certificate protected by the master key. 4. Set the database to use encryption. 0.0%
1. Create a master key. 2. Create or obtain a certificate protected by the master key. 3. Create a database encryption key and protect it by the certificate. 4. Set the database to use encryption. 100.0%
Which of the following is the correct precedence order of the data types in SQL Server 2008? 1.xml 2.text 3.bigint 4.image 5.float 6.datetime
1,2,3,4,5,6 0.0%
6,5,4,3,2,1 0.0%
1,6,5,3,2,4 100.0%
1,4,2,3,6,5 0.0%
Which of the following is the default authentication mode for sqlcmd in SQL Server 2008?
Windows Authentication 100.0%
SQL Server Authentication 0.0%
IIS Authentication 0.0%
Digest Authentication 0.0%
Which of the following is used by SQL Server 2008 Management Studio to execute scripts in regular mode in the Query Editor?
sqlcmd 0.0%
Microsoft .NET Framework SqlClient 100.0%
OLE DB provider 0.0%
None of the above 0.0%
Which of the following is used to comment a portion of an SQL Server 2008 script?
Double asterisk (**) 0%
Double forward slash (//) 0%
Double dash (--) 0%
Double back slash (\) 0%
Which of the following methods can be specified for the lock escalation of a table in SQL Server 2008?
ENABLE 0.0%
AUTO 33.0%
DISABLE 33.0%
TABLE 33.0%
DEFAULT 0.0%
Which of the following namespaces is used to manage the audit configuration programmatically in SQL Server 2008?
Microsoft.SqlServer.Management.Smo 100.0%
Microsoft.SqlServer.Server 0.0%
Microsoft.sqlserver.management.common 0.0%
Microsoft.sqlserver.connectioninfo 0.0%
Which of the following options are available for the DATA_COMPRESSION clause specified for a table in SQL Server 2008?
Page 33.0%
Table 0.0%
Row 33.0%
Column 33.0%
Which of the following options is NOT supported by the ON DELETE clause of a FOREIGN KEY constraint of SQL Server 2008?
CASCADE 0.0%
DELETE 100.0%
SET NULL 0.0%
SET DEFAULT 0.0%
Which of the following options is used to change the value of the password variable and exit using sqlcmd?
-p 0.0%
-P 100.0%
-z 0.0%
Which of the following permissions are required to create a view in SQL Server 2008?
CREATE VIEW permission in database 50.0%
ALTER permission on schema 50.0%
CONTROL permission on object 0.0%
Which of the following permissions is required to drop a stored procedure in SQL Server 2008?
SELECT permission on the schema 0.0%
ALTER permission on the schema 0.0%
CONTROL permission on the procedure 0.0%
Both a and b 0.0%
Either b or c 100.0%
Both b and c 0.0%
Which of the following queries is used to rename a database in SQL Server 2008?
sp_renamedb oldname,newname 100.0%
sp_renamedb newname,oldname 0.0%
sp_dbrename oldname,newname 0.0%
sp_rename oldname,newname 0.0%
Which of the following roles is required to connect to a Central Management Server?
ServerGroupReaderRole 100.0%
ServerGroupAdministratorRole 0.0%
PolicyAdministratorRole 0.0%
db_ssisoperator 0.0%
Which of the following rules must be followed for combining the result sets of two queries by using UNION?
The number of columns must be same in all queries. 33.0%
The order of columns must be same in all queries. 33.0%
The data types of the columns of the queries must be compatible. 33.0%
There should be at least one common column in the tables which are part of the UNION operation. 0.0%
Which of the following scripting options are available while creating a script using the shortcut menu from the Object Explorer in SQL Server 2008 Management Studio?
DELETE To 33.0%
MERGE To 0.0%
CREATE INDEX To 0.0%
INSERT To 33.0%
UPDATE To 33.0%
Which of the following security features have been introduced in SQL Server 2008?
Extensible Key Management 50.0%
SOAP Security 0.0%
Hashing 0.0%
Transparent Data Encryption 50.0%
Which of the following spatial data types are used in SQL Server 2008?
Geography 50.0%
Longitude 0.0%
Altitude 0.0%
Geometry 50.0%
Latitude 0.0%
Which of the following statements are true about FILESTREAM storage in SQL Server 2008?
Transact-SQL can be used to SELECT, INSERT, UPDATE, DELETE FILESTREAM data. 50.0%
The size of the stored data is limited to 2 GB. 0.0%
You cannot take backup of a database without the FILESTREAM data. 0.0%
FILESTREAM storage is best used when the BLOB file sizes average 1MB or higher. 50.0%
Which of the following statements are true about the FILESTREAM argument of SQL Server 2008?
If a table contains FILESTREAM data and the table is partitioned, the FILESTREAM_ON clause must be included. 50.0%
The FILESTREAM column can be partitioned even if a table is not partitioned. 0.0%
There may not be a FILESTREAM filegroup if a table is not partitioned and the FILESTREAM_ON clause is not specified. 0.0%
The filegroup in the FILESTREAM_ON <filegroup>> clause must have one file defined for the filegroup. 50.0%
Which of the following statements are true regarding row and page compression in SQL Server 2008?
When a table or index is created, data compression is set to NONE, unless otherwise specified. 50.0%
Nonclustered indexes inherit the compression property of the table. 0.0%
New pages allocated in a heap as part of DML operations will not use PAGE compression until the heap is rebuilt. 50.0%
When you are compressing indexes, leaf-level pages can be compressed with only page compression. 0.0%
Which of the following statements are true?
IGNORE_DUP_KEY cannot be set to ON for XML indexes. 50.0%
IGNORE_DUP_KEY can be set to ON for spatial indexes. 0.0%
IGNORE_DUP_KEY can be set to ON for filtered indexes. 0.0%
IGNORE_DUP_KEY can be set to ON for XML indexes. 0.0%
IGNORE_DUP_KEY cannot be set to ON for indexes created on a view. 50.0%
Which of the following statements is NOT true about the UNIQUE constraint of SQL Server 2008?
Multiple UNIQUE constraints can be defined on a table. 0.0%
When using the UNIQUE constraint, only one null value is allowed per column. 0.0%
UNIQUE constraint cannot be referenced by a FOREIGN KEY constraint 100.0%
Which of the following statements is true if you create a global temporary table in SQL Server 2008 and specify a FOREIGN KEY with the CREATE TABLE command?
The table is created successfully with the FOREIGN KEY constraint. 0.0%
The table is not created and no message is returned. 0.0%
The table is created without the FOREIGN KEY constraint and a warning message is returned. 100.0%
The table is not created and an error message is displayed. 0.0%
Which of the following statements is true regarding indexes in SQL Server 2008?
Modifications made in a table will be faster if the number of indexes is more. 0.0%
Modifications made in a table will be slower if the number of indexes is more. 100.0%
The number of indexes does not affect the modification process of a table. 0.0%
Which of the following statements using GROUP BY clause are allowed in SQL Server 2008?
SELECT Column1 + Column2 FROM Table GROUP BY Column1, Column2 33.0%
SELECT Column1, Column2 FROM Table GROUP BY Column1 + Column2 33.0%
SELECT Column1 + constant + Column2 FROM Table GROUP BY Column1 + Column2 0.0%
SELECT Column1 + Column2 FROM Table GROUP BY Column1 + Column2 33.0%
Which of the following stored procedures is used to delete data from the management data warehouse of a Data Collector?
core.sp_delete_data 0.0%
core.sp_purge_data 100.0%
core.sp_remove_data 0.0%
None of the above 0.0%
Which of the following values specifies that each instance of the XML data type in column_name can contain multiple top-level elements?
DEFAULT 0.0%
CONTENT 100.0%
DOCUMENT 0.0%
FILESTREAM 0.0%
Windows Security log can be specified as a target for Audit in SQL Server 2008.