What is the difference between delete, truncate and drop command?


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

Post New Answer

More SQL PLSQL Interview Questions

What is pl sql record in oracle?

0 Answers  


What is the difference between syntax error and runtime error?

0 Answers  


What are the most important ddl statements in sql?

0 Answers  


what are the advantages a stored procedure? : Sql dba

0 Answers  


What is trigger types in sql?

0 Answers  






Can one improve the performance of sql*loader? : aql loader

0 Answers  


i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 Answers  


how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  


How can you create Cursor with parametres ?

3 Answers  


write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  


there are .......different types of serializability

1 Answers   Wipro,


How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,


Categories