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

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

What will be the output of SELECT PARSENAME('Dotnet.Funda.nice.forum',1)

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

What will be the output of DECLARE @Name VARCHAR(30) = 'FirstName MiddleName LastName' SELECT CONCAT( PARSENAME(REPLACE(@Name,' ','.'),3),',', PARSENAME(REPLACE(@Name,' ','.'),2),',', PARSENAME(REPLACE(@Name,' ','.'),1) )

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

What will be the output of DECLARE @Name AS VARCHAR(30) ='dotnetfunda!!>$:niceforum' SELECT NAME = SUBSTRING(@Name,1,ISNULL(NULLIF(PATINDEX('%[^A-Za-z0-9]%',@Name),0)-1,LEN(@Name)))

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

Can we modify the data of a table variable that is passed as a Parameter to a stored procedure in sql server?

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

Which switch will help to first change the pasword and then help to execute a sql script from SQLCMD utility?

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

SELECT RAND() Random_Number SELECT RAND() Random_Number SELECT RAND() Random_Number SELECT RAND() Random_Number SELECT RAND() Random_Number is equivalent to

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

Maximum, how many parameters we can pass into a store procedure?

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

Which command is the faster for deleting records from a table (without referential integrity)?

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

What is the output ? RAISERROR ('dotnetfunda', 0, 20)

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

What is the output ? RAISERROR ('dotnetfunda', 7777997777770, 20)

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

What is the output ? RAISERROR ('dotnetfunda', 1, 0)

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

What is the output ? RAISERROR ('dotnetfunda', 0, 0)

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

What is the output ? RAISERROR ('dotnetfunda', 19, 0)

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

What will be the output SELECT DATEDIFF (ms,GETDATE()-25,GETDATE()) ?

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

Which of the below command are equal to Select 1

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

What will be the output? Declare @t1 table(ID1 int) Declare @t2 table(ID2 int) Insert into @t1 Values(1),(2),(3),(4),(5) Insert into @t2 Values(21),(22),(3),(44),(5) select * from @t1 MID JOIN @t2 on ID1 = ID2

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

What is the datatype of hierarchyID?

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

What will be the output of declare @t table(names varchar(MAX)) insert into @t select 'Ram' union all select 'Shyam' union all select 'Jadhu' union all select 'Madhu' union all select NULL DECLARE @NamesList VARCHAR(8000); SELECT @NamesList = COALESCE(@NamesList + ', ', '') + CAST(names AS varchar(20)) FROM @t SELECT CombinedResult = @NamesList

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

What will be the output of declare @t table(names varchar(MAX)) insert into @t select 'Ram' union all select 'Shyam' union all select 'Jadhu' union all select 'Madhu' union all select 'NULL' DECLARE @NamesList VARCHAR(8000); SELECT @NamesList = COALESCE(@NamesList + ', ', '') + CAST(names AS varchar(20)) FROM @t SELECT CombinedResult = @NamesList

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

What will be the output of declare @t table(names varchar(MAX)) insert into @t select 'Ram' union all select 'Shyam' union all select 'Jadhu' union all select 'Madhu' DECLARE @NamesList VARCHAR(8000); SELECT @NamesList = COALESCE(@NamesList + ', ', '') + CAST(names AS varchar(20)) FROM @t SELECT CombinedResult = @NamesList UNION ALL SELECT NULL

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