Difference between:
- Delete & Truncate
- Table & View
- Constraints & Triggers

Difference between: - Delete & Truncate - Table & View - Constraints & Triggers..

Answer / amrish kumar

The DELETE command is used to remove rows from a table. A
WHERE clause can be used to only remove some rows. If no
WHERE condition is specified, all rows will be removed.
After performing a DELETE operation you need to
COMMIT or ROLLBACK the transaction to make the change
permanent or to undo it.

TRUNCATE removes all rows from a table. The operation cannot
be rolled back. As such, TRUCATE is faster and doesn't use
as much undo space as a DELETE.

DROP and TRUNCATE are DDL commands, whereas DELETE is a DML
command. Therefore DELETE operations can be rolled back
(undone), while DROP and TRUNCATE operations cannot be
rolled back.

Table is a basic unit of data storage in an oracle database.
It holds all user accessible data.

View is a virtual table
- It can be created on a table or another view.
- It is just like a window through which we can access or
change base table data.
- It does contain data of its own. It always takes data from
its base table.
- It is stored as a query in data dictionary.Whenever you
query a view it gets data from its based table using this query.

Constraints are great at maintaining database integrity for
database fields and relationships between database tables.

Triggers are great for checking past vs. current values and
making decisions based on that data.

Is This Answer Correct ?    11 Yes 0 No

Post New Answer

More SQL Server Interview Questions

what is the output for this query select * from employee where 1=1;

4 Answers  

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 Answers  

How many types of cursors are there in SQL Server?

5 Answers   247Customer, CarrizalSoft Technologies,

how to dispaly a particular row details from a given table

2 Answers  

UPDATE statement can on a single table or on the multiple table?

7 Answers   TCS, iGate,

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

6 Answers   APX,

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  

How to provide Security for package?

1 Answers   Convergys,

what is differece between union and union all

6 Answers  

What is a stored procedure?

3 Answers  

Which databases are part of SQL server default installation? Explain the usage of each?

2 Answers   Accenture,

application server is slow what may be the problem

0 Answers   Microsoft,