Discussion
The command to eliminate a table from a database is:
Answer: B
Correct answer: DROP TABLE CUSTOMER;
DROP TABLE removes the table itself - its rows, its definition, its indexes and its constraints - leaving no object of that name in the database.
The contrast with DELETE is the point of the question. DELETE FROM CUSTOMER removes rows but keeps the table, ready for new ones. DROP is data definition, DELETE is data manipulation. TRUNCATE TABLE sits between them, emptying the table quickly while keeping its structure. REMOVE TABLE and DELETE TABLE are not SQL.
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development