Home
MS SQL
Interview FAQs

FAQs of level

The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the transaction.
Microsoft SQL Server 2000 Data Transformation Services (DTS) is a set of graphical tools and programmable objects that lets you extract, transform, and consolidate data from disparate sources into single or multiple destinations.
DESC has two purposes. It is used to describe a schema as well as to retrieve rows from table in descending order.
Both the statement delete all row from the table EMP.


While database is in full recovery mode, it can rollback any changes done by DELETE using Log files. TRUNCATE can not be rolled back using log files in full recovery mode.

DELETE and TRUNCATE both can be rolled back when surrounded by TRANSACTION if the current session is not closed. If TRUNCATE is written in Query Editor surrounded by TRANSACTION and if session is closed, it can not be rolled back but DELETE can be rolled back.

CREATE TABLE NEWTABLE AS SELECT command

To copy only the structure, the WHERE clause of the SELECT command should contain a FALSE statement as in the following.

CREATE TABLE NEWTABLE AS SELECT * FROM EXISTINGTABLE WHERE 1=2;

If the WHERE condition is true, then all the rows or rows satisfying the condition will be copied to the new table.

A constraint is an object that exists only within confines of a table. Constraints are much like they sound, i.e. - Rules which are enforced on data being entered, and prevents the users from entering invalid data into tables are called constraints. Thus, constraints super control data being entered in tables for permanent storage.
A View is something like a virtual table in SQL Server. A view is used just like a table, except that it does not contains any data of its own. Instead, a view is merely a preplanned mapping and representations of the data stored in tables. The plan is stored in the database in the form of query. This query calls for data from some, but not necessarily all, columns to be retrieved from one or more tables.
1. When data security is required.
2. When data redundancy is to be kept to the minimum while maintaining data security.
PreviousDisplaying 3 of 15Next
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Need Help? Contact Us.

Log in

*
*

Forgot password?

*

New User

*
*
*
*