Analyze the following code snippet for creating a stored procedure in SQL Server 2008:CREATE PROCEDURE Person.GetEmployees@LastName nvarchar(50),@FirstName nvarchar(50)ASSET NOCOUNT ONSELECT FirstName, LastName, JobTitle, DepartmentFROM Person.EmployeeDepartmentWHERE FirstName = @FirstName AND LastName = @LastNameGOWhich of the following is a valid code to execute the GetEmployees stored procedure?
Which of the following data types are supported by SQL Server 2008?
The output of a Transact SQL query using the GROUPING function of SQL Server 2008 is of __________ return type
What is the return type of the value returned by @@DATEFIRST in SQL Server 2008?
Which of the following commands is used to run a Transact-SQL script file by using sqlcmd?
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?
Which of the following namespaces is used to manage the audit configuration programmatically in SQL Server 2008?
An identifier denoting a global temporary object in SQL Server 2008 starts with a ______ sign.
Which of the following commands is used to save the output to a text file after you run a Transact-SQL script using sqlcmd?
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?
Which of the following is a valid code to change the index created on a column of a table to page compression?
Analyze the following code snippet:DECLARE @myDate DATETIME2SELECT @myDate = "2009/10/08 12:35:29.2348 +12:15"SELECT @myDate AS "@myDate"What is the output of the above code?
Which of the following data types can be specified as SPARSE?
What range is supported by the TIME data type in SQL Server 2008?
How many audit action groups are available for a server in SQL Server 2008 to perform different actions on audit data?
Analyze the following code which uses the TOP clause of SQL Server 2008:USE PersonGODECLARE @p AS intSELECT @p=10SELECT TOP(@p)FROM EmployeeGOWhat Will be the output of the above code?
Which of the following is a valid syntax of the ALTER SERVER AUDIT statement used to enable a server audit?
Which of the following permissions are required to create a view in SQL Server 2008?
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.
What is the default timeout for login to sqlcmd while you try to connect to a server?
Which of the following compression features have been introduced in SQL Server 2008 that were NOT supported by SQL Server 2005?
Analyze the following code used to update a Common Table Expression:USE demodbGODECLARE @a TABLE (ID int, Value int);DECLARE @b TABLE (ID int, Value int);INSERT @a VALUES (1, 10), (2, 20);INSERT @b VALUES (1, 100),(2, 200);WITH cte AS (SELECT * FROM @a)UPDATE cteSET Value = b.ValueFROM cte AS aINNER JOIN @b AS b ON b.ID = a.IDSELECT * FROM @aGOWhat Will be the output of the above code?
What is the default maximum precision of decimal data type in SQL Server 2008?
All MDX, DMX and XML/A errors are displayed in the Error List window of the SQL Server 2008. Management Studio.
Which of the following is used to comment a portion of an SQL Server 2008 script?
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?
Which of the following is used by SQL Server 2008 Management Studio to execute scripts in regular mode in the Query Editor?
Which of the following options are available for the DATA_COMPRESSION clause specified for a table in SQL Server 2008?
Which of the following features is used by SQL Server Audit to create and manage audits in SQL Server 2008?
What is the data type of the parameter "Audit_file_offset" of function "fn_get_audit_file()" in SQL Server 2008?
Windows Security log can be specified as a target for Audit in SQL Server 2008.
User defined data type columns can be designated with ROWGUIDCOL.
Which function/functions are performed by the following statement? DBCC CHECKIDENT ("table_name", RESEED, new_reseed_value)
Which of the following stored procedures is used to delete data from the management data warehouse of a Data Collector?
What is the function of DBCC CHECKDB command in SQL Server 2008?
Which of the following Audit objects primarily describes the destination where the audit data of SQL Server 2008 gets stored?
Which of the following commands is used to connect to a named instance of SQL Server using the sqlcmd utility of SQL Server?
PRIMARY KEY constraint defaults to __________ index.
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
Which of the following queries is used to rename a database in SQL Server 2008?
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?
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
Which of the following commands is used to start the Resource Governor in SQL Server 2008?
Which of the following options is used to change the value of the password variable and exit using sqlcmd?
Which of the following spatial data types are used in SQL Server 2008?
Which of the following formats are supported by the language_term argument while altering a full-text stoplist in SQL Server 2008?
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?
About these SQL Server questions
Questions on Microsoft SQL Server 2008 and Transact-SQL: data types, constraints and indexes, the sqlcmd utility, data compression, SQL Server Audit, encryption, the Resource Governor and DBCC commands.
Topics: Data types, Tables, constraints and indexes, T-SQL queries, sqlcmd, Administration and security, and Maintenance.
What the SQL Server test covers and how to prepareTeachers: using these SQL Server questions with a class? Tell us about your class.