What is the difference between drop and truncate commands?


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

Post New Answer

More SQL PLSQL Interview Questions

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,


How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,


What are sql injection vulnerabilities?

0 Answers  


What is output spooling in sql*plus?

0 Answers  


what are date and time data types in mysql? : Sql dba

0 Answers  






define sql insert statement ? : Sql dba

0 Answers  


four procedures is are there should i write their in a package

2 Answers  


Does pdo prevent sql injection?

0 Answers  


What are the possible values that can be stored in a boolean data field?

0 Answers  


What is difference between db2 and sql?

0 Answers  


What is rename command in sql?

0 Answers  


What is sql profiler in oracle?

0 Answers  


Categories