PyQdeck LogoPyQdeckSubjectsSyllabusBlog
Back to the 2024 paper

Unit 1: Database System Architecture

20242m

Which 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) DDL
Search GoogleAsk AI
Worked SolutionAI Assisted

Answer: (iv) DDL

Explanation: DDL (Data Definition Language) is used for structure operations like CREATE, ALTER, DROP, TRUNCATE. DML is for data manipulation (SELECT, INSERT, UPDATE, DELETE). Query is a DML SELECT. Relational schema is the design itself, not the language.

Similar questions

Database Management SystemWhich of the following is an example of a DML command in SQL? (i) CREATE (ii) SELECT (iii) DROP (iv) ALTER20242mDATABASE MANAGEMENT SYSTEMThe 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)20242mDATABASE MANAGEMENT SYSTEMWhich command is used to remove a relation from SQL? - (i) Drop table - (ii) Delete - (iii) Purge - (iv) Remove20242mDatabase Management SystemFour DML commands are : (i) create, update, delete, select (ii) insert, update, drop, select (iii) create, alter, delete, select (iv) insert, modify, delete, select20222m
Next__________ operations do not preserve non-matched tuples. - (i) Inner join - (ii) Left outer join - (iii) Query - (iv) Relational schema
Budget AppAndroid App

Pocketly on Android

Log daily food, travel, and hostel expenses instantly. Set monthly spending limits and see where your money goes without complex spreadsheets.

Install Pocketly