Oracle Certification Exam Question:

Download Job Interview Questions and Answers PDF

what is the difference between TRUNCATE, DELETE, DROP?

Answer:

1) Drop will drop the records from the table along with its structure.All the indexes associated with it will also deleted and there is no rollback.
2) Delete will deletes the records of the table but the structure of the table is retained back.It is a DML operation which is slower but provides rollback facility.
3) Truncate is a DDL command which is faster ,retain structure of the table and rollback is possible.It allocates memory usually after truncating so structure is retained.

Download Oracle Certification Interview Questions And Answers PDF

Previous Question

Next Question

Explain Which two statements are true regarding working with dates? (Choose two.)
A. The default internal storage of dates is in the numeric format
B. The default internal storage of dates is in the character format
C. The RR date format automatically calculates the century from the SYSDATE function and does
not allow the user to enter the century
D. The RR date format automatically calculates the century from the SYSDATE function but allows
the user to enter the century if required?

Explain When does a transaction complete? (Choose all that apply.)
A. When a DELETE statement is executed
B. When a ROLLBACK command is executed
C. When a PL/SQL anonymous block is executed
D. When a data definition language statement is executed
E. When a TRUNCATE statement is executed after the pending transaction