Querying Microsoft SQL Server 2012 (70-461) – Exam Preparation Questions – Part 1

What will be the best possible output of following T-SQL statement?

DECLARE @value int=1000;

SELECT CASE

WHEN TRY_CAST(@value AS tinyint) IS NULL THEN ‘Cast Failed’

ELSE ‘Cast Succeeded’

END;

What will be the correct output of following T-SQL statement?

SELECT ROUND (799.00, -2, 0);

What will be the correct output of following T-SQL statement?

CREATE TABLE tbl_Test(Col1 int);

SELECT DISTINCT OBJECTPROPERTY(OBJECT_ID(‘tbl_Test’),’IsSystemTable’);

DROP TABLE tbl_Test;

Which of the following function is a SQL Server 2012 Analytic Function?

Which of the below statements is incorrect about the View in SQL Server 2012?

Which of the below statements is incorrect about the SET DATEFORMAT Statement?

Which of the below statements is true about the SET XACT_ABORT command in SQL Server 2012?

What are the cursors in SQL Server 2012?

Which of the following function would you consider using to repeat a string value a specified number of times?

What will be the default output of following T-SQL statement?

DECLARE @value int = 1, @datetime datetime2 = ‘2014-01-01’;

SELECT DATEADD(week, @value, @datetime);

You’re planning to modify an existing table called “Manager” in your current database. Which of the following syntax can be used to rebuilds a primary key index called “PK_Manager_ID” on the Manager table?

What will be the possible output of following T-SQL statement?

SELECT TYPEPROPERTY(‘uniqueidentifier’,’Scale’);

What will be the correct output of following T-SQL statement?

DECLARE @expression varchar(100)=’0′;

DECLARE @count int=5;

SELECT REPLICATE(@expression,@count)+’A’;

Which of the following function would you consider using to get the statistical standard deviation for the population for all values in the specified expression?

Which of the following is the correct output for the following T-SQL statement?

CREATE TABLE tbl_Scores(Score decimal(8,2)) ;

INSERT tbl_Scores VALUES (1.58),(2.38),(3.47),(4.01),(5.20) ;

SELECT IIF ( 5.20 = ANY (SELECT * FROM tbl_Scores), ‘TRUE’, ‘FALSE’ );

DROP TABLE tbl_Scores;