Question 120Asked in DSSSB TGT Computer Science, 25 Jun 2023, Shift 2 (12:30 PM)

Which of the following is used to define the structure of a relation as well as delete relations and relate schemas?

  1. AIntegrity constraint
  2. BView
  3. CDML (Data Manipulation Language)
  4. DDDL (Data Definition Language)
Show answerHide answer

Correct answer: (D) DDL (Data Definition Language)

Explanation

DDL commands (CREATE, ALTER, DROP) define and change the structure (schema) of relations and remove them. DML only queries and modifies the data stored in them.

From DSSSB TGT Computer Science PYQ, 25 Jun 2023, Shift 2 (12:30 PM)

This is question 120 of DSSSB TGT Computer Science PYQ, 25 Jun 2023, Shift 2 (12:30 PM). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.