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!
Software Engineering
Learn about the systematic approach to developing software with our Software...
Operating System
Dive deep into the core of computers with our Operating System MCQs. Learn about...
Microprocessor
Understand the heart of your computer with our Microprocessor MCQs. Topics include...
