PyQdeck LogoPyQdeckSubjectsSyllabusBlog
Back to the 2024 paper

Unit 2: Relational Query Languages

20242m

Which command is used to remove a relation from SQL?

  • (i) Drop table 
  • (ii) Delete 
  • (iii) Purge 
  • (iv) Remove
Search GoogleAsk AI
Worked SolutionAI Assisted

Answer: (i) Drop table

Explanation: DROP TABLE removes relation schema and data completely from database. DELETE without WHERE deletes all rows but keeps structure (DML). PURGE is Oracle extension to permanently remove from recyclebin. REMOVE is not SQL standard.

Similar questions

Database Management SystemWhich SQL command is used to remove a table from a database? (i) REMOVE (ii) DELETE (iii) DROP (iv) CLEAR20242mDATABASE MANAGEMENT SYSTEMWhich of the following is generally used for performing tasks like creating the structure of the relations or deleting relations? - (i) DML - (ii) Query - (iii) Relational schema - (iv) DDL20242mDatabase Management SystemWhich of the following is an example of a DML command in SQL? (i) CREATE (ii) SELECT (iii) DROP (iv) ALTER20242mDATABASE MANAGEMENT SYSTEM__________ operations do not preserve non-matched tuples. - (i) Inner join - (ii) Left outer join - (iii) Query - (iv) Relational schema20242m
PreviousThe ability to query data, as well as insert, delete, and alter tuples, is offered by: - (i) TCL (Transaction Control Language) - (ii) DCL (Data Control Language) - (iii) DDL (Data Definition Language) - (iv) DML (Data Manipulation Language)NextIllustrate the database characteristics, How they are different from File systems.
AI LearningWeb Platform

Coursify — Personal AI Course Generator

Struggling with a difficult subject or concept? Turn any engineering topic into a structured course with interactive lessons, quizzes, and research-backed explanations.

Try Coursify Free