Q:

What is the result of the following query?

mhmadesk

Save to bookmark

|

2022-07-13

|

511

Medium

0

What is the result of the following query?

DELETE FROM student
WHERE marks &lt; (SELECT avg(marks)
                             FROM student);

The query deletes all the tuples whose marks are greater than the average marks
The query deletes all the tuples whose marks are less than the average marks
The query deletes all the values under the marks attribute which are less than the average
The query is syntactically wrong and does not execute

Database, MCQ Questions, Database MCQ-questions,

login and add your own answer to this question

All Answers

mhmadesk

2022-07-13

need an explanation for this answer? contact us directly to get an explanation for this answer

(b).The query deletes all the tuples whose marks are less than the average marks

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)