Sql Interview Question and Answers:
110. What is the difference between TRUNCATE and DELETE commands?
TRUNCATE is a DDL command whereas DELETE is a DML command. Hence DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back. WHERE clause can be used with DELETE and not with TRUNCATE.
111. Describe the three levels of data abstraction?
There are three levels of abstraction :
Physical level :
The lowest level of abstraction describes how data are stored.
Logical level:
The next higher level of abstraction, describes what data are stored in database and what relationship among those data.
View level:
The highest level of abstraction describes only part of entire database.
112. How to copy the tables, schema and views from one SQL server to another?
Microsoft SQL Server 2000 Data Transformation Services (DTS) is a set of graphical tools and programmable objects that lets user extract, transform, and consolidate data from disparate sources into single or multiple destinations.
110. What is the difference between TRUNCATE and DELETE commands?
TRUNCATE is a DDL command whereas DELETE is a DML command. Hence DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back. WHERE clause can be used with DELETE and not with TRUNCATE.
111. Describe the three levels of data abstraction?
There are three levels of abstraction :
Physical level :
The lowest level of abstraction describes how data are stored.
Logical level:
The next higher level of abstraction, describes what data are stored in database and what relationship among those data.
View level:
The highest level of abstraction describes only part of entire database.
112. How to copy the tables, schema and views from one SQL server to another?
Microsoft SQL Server 2000 Data Transformation Services (DTS) is a set of graphical tools and programmable objects that lets user extract, transform, and consolidate data from disparate sources into single or multiple destinations.
No comments:
Post a Comment