Blog

6. You are working on a PostgreSQL 10 database. Evaluate the following statement.

DROP TABLE EMP;

which three statements are true for the above SQL command?

1. You cannot rollback this statement.
2. All pending transactions are committed.
3. All views based on the emp table are deleted.
4. All indexes based on the emp table are dropped.
5. All data in the table is deleted along with the table structure.
6. All the data in the table is deleted but the structure is retained.
7. RESTRICT option can delete the records in a table but the structure is retained.

Show Answer

Keep watching this space for more questions, questions will be coming up on #QuestionADay Series

PostgreSQL 13 Beta 1 has been released for testing. Click here to know its features.