Interviews Questions and Answers (8126) - Page 167

Latest and authentic Interview questions. You can also post an interview question and win monthly prizes as well as gain community credit points.

8126 records found.

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Post

Title Posted by, on, category, views

You want to ensure the following: 1) Statements in the transaction should not be able to read data ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 3122

You are configuring an appropriate transaction isolation level for a session. You want to ensure tha ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 4213

You are working on some errors raised by a some set of transactions. You want to ensure that transac ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 4548

Which of the following statements you can use to ensure that the SQL Server db engine automatically ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 4577

Which of the following statements will list the number of BEGIN TRANSACTION statements that have occ ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 6227

You want to revert changes made during a transaction to the start of that transaction ? Which of ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 5059

Which of the following statements can you use to specify the end of a transaction?
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 6380

You want to revert changes made during a transaction to a specific savepoint. Which of the follow ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 5610

You want to create several markers within a transaction that a user can return to without necessaril ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 6642

You are developing some T-SQL code. You want to ensure that you correctly mark the end of successful ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 5462

Which of the following statements would you use to mark the save point of within transaction?
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 5476

You are reviewing a database created by a developer. You have noticed that the developer has misname ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 5569

You want to remove the price column of the product table. This table is located in the Category sche ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 5365

You want to update the properties of the Suburb (name) column in the Address(employee) table of the ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 5981

You want to alter the properties of the city column of the employee table in the people schema so th ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 5545

You want to add a new column to an existing table in the temp databases. This column should have the ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 5801

Which of the following Transact-SQL statements can you use to move a table from one database schema ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 6895

Which of the following Transact-SQL statements moves the product table from the Production schema to ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 6291

You want to create a new table, named TestTable, in the temp database. This table should have three ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 6261

You are creating a number of tables for your product database. You want to create a table based on t ...
Posted by Rajkatie on 6/30/2013 under Sql Server category | Views: 5349

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