Sql Server Interview Questions and Answers (1758) - Page 79

Latest and authentic Interview questions. You can also post an interview question and win monthly prizes as well as gain community credit points.

1758 records found.

Post |

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

SQL Server 2012 - what is the data type of output of below SQL ? SELECT IIF(@CurrentDate > @ComparisonDate, 100, GETDATE())

NOTE: This is objective type question, Please click question title for correct answer.

SQL Server 2012 - Which of the following statement restars the numeric value generated by a sequence to a value of 1? Sequence object definition is CREATE SEQUENCE [dbo].[SequenceObj] AS TINYINT

NOTE: This is objective type question, Please click question title for correct answer.

Which transaction isolation level is the most restrictive causing the highest level of blocking and contention and protects against phantom reads?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following isolation level allows nonrepeatable reads but prevents dirty reads?

NOTE: This is objective type question, Please click question title for correct answer.

SQL Server 2000 - Which part of the code line generates error in the below user-defined function? CREATE FUNCTION [dbo].[SampleFunction] RETURNS DATETIME AS BEGIN DECLARE @TodaysDate DATETIME SET @TodaysDate = GETDATE() SET @TodaysDate = DATEADD(DD, DATEDIFF(DD, 0, @TodaysDate), 0) RETURN @TodaysDate END

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following is FALSE statement against the securityadmin fixed server role in SQL Server?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following is FALSE against the setupadmin fixed server role?

NOTE: This is objective type question, Please click question title for correct answer.

what is the output of below query? DECLARE @Today VARCHAR(10) SET @Today = '06/26/2015' SET @Today = @Today + 5

NOTE: This is objective type question, Please click question title for correct answer.

what is the output of this SQL ? SELECT LEN(CAST(LEFT('030-020', 3) AS INT))

NOTE: This is objective type question, Please click question title for correct answer.

You need to ensure that if a row in a parent table is deleted, it must delete all related child rows in another table.

NOTE: This is objective type question, Please click question title for correct answer.

A user-defined function must have

NOTE: This is objective type question, Please click question title for correct answer.

You have two tables in your database namely, currentStock and previousStock. These both tables have productName column. you need to display the name of all products from these both the tables,but leave off the twin course names. whcih operator should you use in query for getting desire output?

NOTE: This is objective type question, Please click question title for correct answer.

What is the output of ? SELECT STR(1024.58, 6, 1)

NOTE: This is objective type question, Please click question title for correct answer.

Which of the follwoing is VALID statement for defining computed column in CREATE TABLE ?

NOTE: This is objective type question, Please click question title for correct answer.

In SQL Server 2000, Which of the following statement is NOT Valid about SMALLDATETIME?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following details are not stored in sysobjects system table?

NOTE: This is objective type question, Please click question title for correct answer.

In SQL server 2000, how many maximum number of parameters can a stored procedure have?

NOTE: This is objective type question, Please click question title for correct answer.

which of the follwoing statement is NOT VALID in CREATE TABLE ?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following column definition will allow you to create a UNIQUE CONSTRAINT on the column?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following statements will return a different value?

NOTE: This is objective type question, Please click question title for correct answer.

More SQL SERVER Exclusive Interview Questions & Answers here

Found this useful, bookmark this page to the blog or social networking websites.

Bookmark It

Interview Questions and Answers Categories

Data Structures & Algorithms

Design Pattern & Practices

DotNetFunda.Com

Entity Framework

Error and Solution

Function Points (FPA)

MSBI (SSIS, SSRS, SSAS)

Web Services, Remoting