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

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 is the correct syntax for creating new Login on the Sql Server?

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

When we install Sql Server,then which of the following databases are created by default?

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

Difference between UNION and UNION ALL.

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

We can add a row using Sql Server Database with which of the following keyword?

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

The command to remove rows from a table is?

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

What is the correct syntax to delete a Login?

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

What is the purpose of Sql WHERE clause?

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

What is the Capabilities of RAISERROR in Sql Server?

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

Which global variables can be used to determine if a transaction is still open?

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

Which of the following is not correct for DELETE and TRUNCATE Command?

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

The Sql keyword(s) is used with which Wildcards?

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

The result of a Sql SELECT statement is in the form of?

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

The HAVING clause does which of the following operations?

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

The Sql keyword BETWEEN is used?

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

In an Sql SELECT statement what does * mean?

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

What do we mean by SPACE function in Sql Server?

The SPACE string function is an in-built Sql Server Function which returns a string of repeated spaces.

Syntax:-

SPACE (Expression)

The Expression is a positive integer that indicates the number of spaces.If Expression is negative,a NULL string is returned.

Give an example of Space function.

2 spaces in between characters.

select 'vishal' + space(2) + 'neeraj';

Output:-
Vishal Neeraj

What is the Return Type of Space Function?

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

What is NCHAR function in Sql Server?

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

What is the syntax of NCHAR function?

Syntax of NCHAR function is:-

NChar(numeric_value)

Where numeric_value can be any positive number from 0 to 65535.If we specify number other than this range then it returns NULL.

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