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

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

You need to delete a stored procedure from the SQL Server 2012 database. The stored procedure is called MyProc. Which statement below is correct?

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

You're creating a new query that will select rows from a products tables. The query works 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.

SQL Server 2012 uses the standard four-part naming convention when referencing database objects. Which of the following is the correct example of the four-part naming?

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.

You're designing a new query that will return all of the medical records from the patients table. This could run into millions of rows so you need to find a way 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.

You need to write 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). Your query will use a sub query to check that the employee is not in the contractors table. How might you achieve this?

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 HumanResources.uspGetAllEmployees SET NOCOUNT ON; SELECT LastName, FirstName, Department FROM HumanResources.vEmployeeDepartmentHistory; GO

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

As part of a new HR project you're creating several stored procedures that will add logging information to the logs table. This logging information is very detailed and should contain carriage returns to make paragraphs more readable. 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.

You're designing a new SQL Server 2012 table that will hold millions of records. The table will be used by a finance application to show historical transactions. 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.

The transaction isolation level controls the locking and row versioning behavior of Transact-SQL statements issued by a connection to SQL Server. 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.

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.

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.

You're designing a new SQL Server 2012 query for the HR department. The query will find records from the persons table for people whose name starts with 'Ja'. Which WHERE statement would be the correct choice?

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

You're designing a new query that will eventually be used by a new software application. It's important that the application knows the id value of the last row that was inserted. Rather than re-run another query just to get the maximum id value, your friend has told you to include an inbuilt function. What might that function be?

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

The !> operator is a comparison operator that compares two expressions. However, if ANSI_NULLS is set to ON and one of the operands is NULL, what will the result be? expression !> expression (NULL)

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

You're designing a new table that will hold information about medical records. Another table called documents contains a foreign key that references this table. To make sure information is cleaned up when a delete operation is performed, you've added an ON DELETE CASCADE statement to the foreign key relationship. What will happen when a row is deleted from the medical records table?

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.

Which of the following conversions is NOT allowed either implicitly or explicitly using CONVERT OR CAST?

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 MyProc?

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

A DML trigger is an action programmed to execute when a data manipulation language (DML) event occurs in the database server. DML events include UPDATE, INSERT, or DELETE statements issued against a table or view. Which of the following is TRUE regarding INSTEAD OF triggers?

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

1
...
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
...
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