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

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

The Employee table of the AdventureWorks2012 database includes information on each employee's accrued vacation hours. When an employee takes a vacation and uses all his or her hours, the hours are reset to NULL. You want to determine the total number of employees who have a job title like Design Engineer who have outstanding vacation hours. Which of the following T-SQL statements can you use to accomplish this task?

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

You want to use the appropriate function to convert a binary value to the datetime2 data type. The conversion should not return a null value if this is not possible. Which of the following built-in functions can you use to accomplish this goal?

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

You are optimizing several Transact-SQL statements. You have determined that a particular statement will perform more efficiently if a lock is applied at the row level rather than at the page or table level. Which of the following table hints will you use in your Transact-SQL statements when performing optimization?

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

Which of the following queries that use string functions will return the result 'aus'?

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

The employees table of the Hovercraft database has the following columns: EmpId Full Name Address1 Address2 Email Phone Country Your company has offices in 10 countries. You want to simplify the process of querying data so that sales people in India are returned results from the employees table only where the value in the Country column is india. employee people in india must be able to query data in all other columns. Which of the following T-SQL statements can you use to accomplish this task?

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

There are several very large tables in the Hovercraft database. You want to create a database object that users in the India office can issue select queries against that will return only results that have the Country column of the Sales table set to the value India. Which of the following Transact-SQL statements can you use to accomplish this task

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

You want to generate a ranked list of pay rates for employees who are paid every two weeks by querying the EmployeePayHistory table of the AdventureWorks2012 database. If more than one employee has the same rate, they should all be assigned the same rank. The employee who has the rate that is next below this rate should be ranked from the beginning as shown in the exhibit between rows 7 and 8. Which of the following Transact-SQL statements can you use to accomplish this task?

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

Which of the following mathematical functions would you use to calculate the absolute numeric value of a numeric value?

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

Which of the following statements would you use to mark the start point of an explicit local transaction?

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

You want to change the definition of a DML trigger. Which of the following T-SQL statements would you use to accomplish this goal?

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

You have created a new table named Maintenance in the Hovercraft Rentals database. This table is located in the Chassis schema and has a HovercraftID column that is set to disallow null values. You want to create a relationship between the HovercraftID column in this new table and the HovercraftID column in the Inventory table, also located in the Chassis schema. Which of the following Transact-SQL statements can you use to accomplish this goal?

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

You want to query the table OrderDetail to generate a list of product IDs for products that cost less than $100.00 that have an average order quantity greater than 10. Which of the following T-SQL statements can you use to accomplish this goal?

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

Which of the following Transact-SQL statements would you use when creating a common language runtime (CLR) stored procedure in SQL Server 2012?

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

You are creating a trigger that will report the number of rows in the Inserted table during its operation. Which of the following statements would you include when defining this trigger to accomplish this goal?

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

Your subordinate created a view named dbo.vSalesAustralia that was supposed to return information in the Sales table only where the Country column is set to Australia. Instead, the view returns information in the Sales table only where the Country column is set to Tonga. Which of the following statements would you use to rectify this problem ?

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

You want to generate a list of integers that includes the integer raised to the power of 5 where the integers have a value between 1 and 20. Which of the following Transact-SQL statements can you use to accomplish this task?

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

You are developing some Transact-SQL code. You want to ensure that you correctly mark the end of successful transactions. Which of the following statements would you use to accomplish this goal?

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

You want to disable the existing trigger named Sales.Order_Count that applies to the Sales table. You might need to re-enable this trigger in the future. Which of the following Transact-SQL statements can you use to accomplish this goal?

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

Write a SQL Query to find the second maximum salary without using TOP keyword. Consider the following Employee table EmpID Salary 1 1000 2 2000 3 5200 4 7855 5 4000 6 6500 7 7000

Here the main constraint is we should not use the TOP keyword.

The query is

select MAX(Salary) from tbl_Employee

where Salary <> (

select MAX(Salary) from tbl_Employee)

In sub query I am first getting the Maximum salary of Employee Table. Now 7855 will come. In the outer query I am using Where condition to check the salary NOT EQUAL to 7855 and gettting the maximum value in select query. So now the query will be

select MAX(Salary) from tbl_Employee

where Salary <> 7855

The above query gives 7000 which is the second maximum salary

What is the difference between GetDate() and SysDateTime() in SQL Server 2008?

GetDate() and SysDateTime are used to fetch the current datetime of server. But there is a slight difference exists between these two. GetDate() used to get the time upto MilliSeconds where as SysDateTime used to get the time upto NanoSeconds.

If we run the query in Sql Server

SELECT GETDATE() [GetDate], SYSDATETIME() [SysDateTime]

The output will be

GetDate	                   SysDateTime

2012-12-03 11:28:43.500	   2012-12-03 11:28:43.5004729

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