_____command is used to remove a relation from an SQL database.
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: A. Drop table
Explanation
DROP TABLE removes the relation and its schema; DELETE only removes rows.
More Database Management Systems questions
- Which of the following statements is/are true? (i) Facebook has the world's largest Hadoop cluster. (ii) Hadoop 2.0 allows live stream proc…
- Data scrubbing is
- Consider a relation schema R = (A, B, C, D, E, F) on which the following functional dependencies hold : A → B B, C → D E → C D → A What are…
- Consider two transactions on account A (initial balance 20,000): T1 transfers 5,000 to account B, then T2 applies 10% interest to A. The lo…
- Consider the tables Students(Roll-No, Name) and Performance(Roll-No, Course, Marks) shown below; Students also contains the row (18CS103, R…
- A clustering index is defined on the fields which are of type