Question
Which of the following is true?
a.
It gives the name of the student whose marks in semester 1 and semester 2 are same.
b.
It gives all the names and roll nos of those students whose marks in semester 1 and semester 2 are same.
c.
It gives the names of all the students whose marks in semester 1 and semester 2 are same.
d.
It gives roll numbers of all students whose marks in semester 1 and semester 2 are same.
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 student_data WHERE rollno (SELECT rollno FROM student_marks WHERE SEM1_MARK=SEM2_MARK); Which of the following is true?
Similar Questions
Discover Related MCQs
Q. A primary key for an entity is:
View solution
Q. Aggregate functions in SQL are:
View solution
Q. If a relation is in 2NF and 3NF forms then:
View solution
Q. The end of an SQL command is denoted by:
View solution
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 ?
View solution
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
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!
