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

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.

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

How to get Row Index in MySQL?

select employee_id,employee_name,@index := @index + 1 as 'sr. no.' from employee_master,(select @index := 0) Emp order by employee_name;

@index > Is an User Defined variable.
:= -> Is an Assignment operator.
@index := @index + 1 -> It sets the variable to the Next Incremental Value for each rows.

Setting @index in the sub-selection or sub-query makes it simple to put it into 1 query.The incrementing number can be adjusted.

After the "Emp" which stands for derived and it is mandatory to have an alias,we can use order by or group by clause.

How to enforce rules for the type of information that can be stored in a particular column. The information must match a particular pattern e.g. a number between 1 and 7. This checking must be performed during insert or update operations. Which parameter should you use when you create the column?

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

Which of the following is FALSE regarding PRIMARY KEYS in SQL Server 2012?

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

A Customers table has columns names as firstname and lastname. Which of the following function could you use to get the first initial and their last name in the result set?

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

What is wrong with the T-SQL batch statement below: @find varchar(30); SET @find = 'Man'; SELECT LastName FROM Person WHERE LastName = @find;

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

Which of the following is an example of a scalar subquery?

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

Which of the following is FALSE regarding FOREIGN KEYS in SQL Server 2012?

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

If you use the BEGIN TRANSACTION statement, then execute 2 insert statements and 2 delete statements what will happen if you execute ROLLBACK TRANSACTION?

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

Assume we have one query to find out the count of products within each category by grouping on the category, filtering by categories that contain more than one product and then sorting the results in category order. In which order should these clauses be used in the query?

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

How to delete a stored procedure named as MyProc from the SQL Server 2012 database?

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

How to remove any table from DB in SQL-Server

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

Which operation Resets Identity column in Table.

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

Which Select statement will not execute successfully about Distinct clause?

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

What is an Alternative way of getting Distinct or Unique records in SQL-Server?

With the help of Group-By clause,we can get unique records:-

select program_name,program_desc,created_date from program_details
group by program_name,program_desc,created_date order by program_name,program_desc,created_date;

Apart from Distinct clause used in select statement, we can get the same records using Group-by clause.

What will be the output of the below query? select ISNUMERIC('1234') as [1234],ISNUMERIC(1234) as [1234],ISNUMERIC('1234sddd') as [1234];

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

What will be the order of null values in below query? Create table test(a int) insert into test values (null) insert into test values (2) insert into test values (3) insert into test values (1) insert into test values (null) select *from test order by a

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

How to Concat 2 Column values in MySQL?

With the help of CONCAT in-built mysql function,we can add 2 column values to make one value as shown:-

select Concat(employee_firstname,' ',employee_lastname) as 'Employee Full Name' from employee_master where status = 'AA';

We can Concat more columns as many as we can,

select Concat(Concat(employee_firstname,' ',employee_lastname),' ',employee_code) as 'Employee Name' from employee_master where status = 'AA';

How to Concatnate 2 column values to make one column value in SQL-Server?

Using '+' sign or Concat in-built function we can Concatnate 2 column values as shown below:-

select(employee_firstname + ' ' + employee_lastname) AS Name from employee_master;

select Concat(employee_firstname , ' ' ,employee_lastname) AS Name from employee_master;

Which of the following is FALSE regarding filtered indexes?

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

We can RECOMPILE a stored procedure in SQL server. Which of the following situations will NOT trigger recompilation of a stored procedure?

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

1
...
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
...
88

More SQL SERVER Exclusive Interview Questions & Answers here

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

GooglePlus

StumbleUpon

Delicious

Reddit

Email

Bookmark It

Interview Questions and Answers Categories

.NET Certifications

ASP.NET Web API

Data Structures & Algorithms

Design Pattern & Practices

DotNetFunda.Com

Entity Framework

Error and Solution

Function Points (FPA)

Interview Questions

Mobile Development

MSBI (SSIS, SSRS, SSAS)

News and Community

Product Reviews

Project Management

Regular Expressions

Web Services, Remoting