Explain the difference between drop and truncate commands in sql?

Question Posted / deepak singh

No Answer is Posted For this Question
Be the First to Post Answer

More SQL PLSQL Interview Questions

What is input buffer in sql*plus?

What is type and rowtype in pl sql?

How do you use join?

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

How to return multiple rows from the stored procedure?

What is sql entity?

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

How can we optimize a sql query?

where are cookies actually stored on the hard disk? : Sql dba

how do you know the version of your mysql server? : Sql dba

how to enter binary numbers in sql statements? : Sql dba

Explain autonomous transaction.

For more SQL PLSQL Interview Questions Click Here