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

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

Which of the following Transact-SQL statements can you use to move a table from one database schema to another?

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

You want to add a new column to an existing table in the temp databases. This column should have the name category and use the nvarchar 200 type. Which of the following Transact-SQL statements you can use to achieve this goal?

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

You want to alter the properties of the city column of the employee table in the people schema so that it is of data type nvarchar 25 rather than nvarchar 50. Which of the following statements can you use to accomplish this goal?

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

You want to update the properties of the Suburb (name) column in the Address(employee) table of the temp database. This table is located in the Products schema. The column should now use the nvarchar(150) data type. 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 remove the price column of the product table. This table is located in the Category schema of the temp datatabase. Which of the following statements can you use to accomplish this goal?

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

You are reviewing a database created by a developer. You have noticed that the developer has misnamed the product table in the category schema as employee. You need to change the employee table name to product. 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.

Which of the following statements would you use to mark the save point of within transaction?

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

You are developing some T-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 create several markers within a transaction that a user can return to without necessarily rolling back the entire transaction. 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 revert changes made during a transaction to a specific savepoint. 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.

Which of the following statements can you use to specify the end of a transaction?

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

You want to revert changes made during a transaction to the start of that transaction ? 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 statements will list the number of BEGIN TRANSACTION statements that have occurred through the current connection without a COMMIT TRANSACTION, COMMIT WORK, ROLLBACK TRANSACTION, or ROLLBACK WORK statement being issued?

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

Which of the following statements you can use to ensure that the SQL Server db engine automatically rolls back the entire current transaction if a T-SQL statement raises a run-time error ?

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

You are working on some errors raised by a some set of transactions. You want to ensure that transactions are not rolled back when low-severity errors are raised by the database engine. 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 are configuring an appropriate transaction isolation level for a session. You want to ensure that statements in the transaction cannot read data altered by other transactions if those transactions have not yet committed. Data selected during the transaction should be able to be modified during the current transaction by update statements issued later in the transaction. Other transactions should be able to insert data into rows with key values that would fall into the range read by statements in the current transaction. 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 ensure the following: 1) Statements in the transaction should not be able to read data altered by other transactions if those transactions have not yet been committed. 2) Statements in other transactions should not be able to read data altered by the current transaction until the current transaction commits. 3)Other transactions should be able to insert new rows that meet the search conditions of statements in the current transaction. 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 ensure the following: 1) Data read by any statement in the transaction must be transactionally consistent with how that data existed at the start of the transaction. 2) Other transactions should be able to write data to rows selected by the transaction even when the transaction has yet to commit. 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 ensure the following: Statements in a particular transaction cannot read data that has been altered but not committed. Other transactions cannot modify data read by the current transaction until the transaction commits. *Other transactions cannot insert rows with key values that would fall into the range read by statements in the current transaction until that transaction completes. 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 ensure that statements in the transaction can read rows altered by other transactions even when those transactions have yet to be committed. 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.

1
...
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
...
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