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

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

How can you add carriage returns to text when inserting into a table?

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

Which of the following would be a correct way to call the stored procedure USP_MyProc?

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

One table has historical transactions details. The table only has 10 columns but it's vital that the table performs well. How many primary keys should you create for the table for best performance?

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

What is missing from the T-SQL statement below for creating and using a cursor? DECLARE mycursor CURSOR FOR SELECT * FROM Vendor; FETCH NEXT FROM mycursor;

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

Which of the following is the standard four-part naming convention when referencing database objects in SQL Server?

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

Which word is missing from the following statement to create a stored procedure? CREATE PROCEDURE uspGetAllEmployees SET NOCOUNT ON; SELECT LastName, FirstName, Department FROM vEmployeeDepartmentHistory; GO

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

Which of the following CANNOT be passed back as an output parameter from a stored procedure?

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

What is the output of select COALESCE(10, getdate()) as 'COALESCE' ?

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

What is the output of select ISNULL(10, getdate()) as 'IsNullWithDifferentTypesofData' ?

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

Which of the following datepart argument is used to get the MINUTE value from datetime using DATENAME() function in SQL server?

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

How to generate grand total for the total column as a separate result in SQL server?

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

Which of the following statement is TRUE regarding INSTEAD OF triggers?

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

which one of the following is suitable for writing a new query that will return names from the employee table for people who are not part of the contractors table (the two tables share a unique id, similar to social security or NI number).

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

CREATE TABLE employee ( id_num int IDENTITY(100,10), fname varchar (20), minit char(1), lname varchar(30) ); what do the 2 numbers after the IDENTITY clause of id_num column mean?

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

How to limit the results to include only the top 100 most recent records. What is the best way to achieve this?

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

SELECT * FROM sys.dm_db_index_physical_stats (DB_ID(N'study'), OBJECT_ID(N'EMPLOYEEs'), NULL, NULL , 'DETAILED'); What you should do if a table (employees) has very less average fragmentation (avg_fragmentation_in_percent) value?

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

If you have ON DELETE CASCADE statement to the foreign key relationship. What will happen when a row is deleted from the parent table?

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

Which of the following is FALSE regarding DML triggers?

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

Which of the following transaction isolation levels is the default in SQL Server 2012?

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

How to get Table row no/row index in sql-server.

With the help of Row_Number() sql-server in-built function, we can get table row number as below:-

select row_number() over(order by employee_id) as 'sr. no.'
from employee_mster where status='AA';

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