Q:

What does the above query do?

mhmadesk
Save to bookmark
|
2022-07-13
|
  488 
Medium
0

select distinct dept_name
from institute;
What does the above query do?

  1. It gives all the tuples having a distinct dept_name
  2. It gives the dept_name attribute values of all tuples without repetition
  3. It gives all the dept_name attribute of all the tuples
  4. It gives all the tuples having a null value under the dept_name attribute
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).It gives the dept_name attribute values of all tuples without repetition

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

total answers (1)

This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now