Question
a.
the list of names of students with 100 marks in mathematics
b.
the names of all students of all classes in which at least one student has 100 marks in mathematics
c.
the names of all students in all classes having 100 marks in mathematics
d.
the names and class of all students whose marks in mathematics is 100
Posted under UGC NET computer science question paper DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Consider the query : SELECT student_name FROM students WHERE class_name=(SELECT class_name FROM students WHERE math_marks=100); what will be the output ?
Similar Questions
Discover Related MCQs
Q. Which of the following statements is wrong?
View solution
Q. A recursive foreign key is a:
View solution
Q. A sub class having more than one super class is called:
View solution
Q. A relation R={A,B,C,D,E,F} is given with following set of functional dependencies:
F={A→B,AD→C,B→F,A→E}.
Which of the following is Candidate Key?
View solution
Q. Which statement is false regarding data independence?
View solution
Q. In DBMS, deferred update means:
View solution
Q. Which statement is false regarding data independence ?
View solution
Q. Two phase protocol in a database management system is:
View solution
Q. A relation R = {A, B, C, D, E, F} is given with following set of functional dependencies:
F = {A→B, AD→C, B→F, A→E}
Which of the following is candidate key ?
View solution
Q. Immediate updates as a recovery protocol is preferable, when:
View solution
Q. Which of the following statement is wrong ?
View solution
Q. A subclass having more than one super class is called .................
View solution
Q. A schema describes:
View solution
Q. One approach to standardizing storing of data:
View solution
Q. In a relational schema, each tuple is divided in fields called:
View solution
Q. An embedded pointer provides:
View solution
Q. A locked file can be:
View solution
Q. An Entity - relationship diagram is a tool to represent:
View solution
Q. Multi-valued dependency among attribute is checked at which level ?
View solution
Q. A WINDOW into a portion of a data base is:
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
