Question

Scalar Subqueries can be used in the SQL update statement when they are used under the ____ clause

(a) where

(b) with

(c) set

(d) end

This question was addressed to me in semester exam.

The query is from Modification of Database in section Introduction to Relational Model and Sql of RDBMS

Answer 1

Correct answer is (c) set

To explain I would say: SQL subqueries that can occur wherever a value is permitted provided the subquery gives only one tuple with a single attribute are called Scalar subqueries. Scalar Subqueries can be used in the SQL update statement when they are used under the set clause.