Give two examples of how you might determine the structure of the table DEPT.

[nandagopal]

Use the describe command or use the dbms_metadata.get_ddl package.

Where would you look for errors from the database engine?

In the alert log.

  Compare and contrast TRUNCATE and DELETE for a table.

Both the truncate and delete command have the desired outcome of getting rid of all the rows in a table. The difference between the two is that the truncate command is a DDL operation and just moves the high water mark and produces a now rollback. The delete command, on the other hand, is a DML operation, which will produce a rollback and thus take longer to complete.