UTpaper

Free mock tests & test series

Question 147Asked in DSSSB TGT Computer Science, 25 Jun 2023, Shift 1 (8:30 AM)

The 'DEFAULT constraint' of SQL will

  1. Aensure that a column cannot have a NULL value
  2. Bensure that all the values in a column satisfy certain conditions
  3. Censure that all values in a column are different
  4. Dprovide a default value for a column when none is specified
Show answerHide answer

Correct answer: (D) provide a default value for a column when none is specified

Explanation

The DEFAULT constraint supplies a default value for a column when no value is given in an INSERT. NOT NULL, CHECK and UNIQUE do the other jobs.

From DSSSB TGT Computer Science PYQ, 25 Jun 2023, Shift 1 (8:30 AM)

This is question 147 of DSSSB TGT Computer Science PYQ, 25 Jun 2023, Shift 1 (8:30 AM). 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.