UTpaper

Free mock tests & test series

Question 16Asked in DSSSB TGT Computer Science (Technical), 12 Sep 2025, Shift 1 (9:00 AM)

____________ is NOT allowed in a SQL:1999 view definition.

  1. AUse of subqueries
  2. BUse of nested queries
  3. CUse of aggregate formulas
  4. DUse of ORDER BY clause
Show answerHide answer

Correct answer: (D) Use of ORDER BY clause

Explanation

A view is a virtual table, and standard SQL (SQL:1999) does not allow ORDER BY in the view's defining query; ordering is applied when the view is queried. Subqueries and aggregates are allowed.

From DSSSB TGT Computer Science PYQ (Technical), 12 Sep 2025, Shift 1 (9:00 AM)

This is question 16 of DSSSB TGT Computer Science PYQ (Technical), 12 Sep 2025, Shift 1 (9:00 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.