Question

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?

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

Answer: (c).It gives the names of all the students whose marks in semester 1 and semester 2 are same.

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?

Add Comment

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

View All MCQs on DBMS

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!

Reverse Engineering

Strengthen your understanding of Reverse Engineering with our curated set of MCQs....

Object Oriented Programming Using C++

Enhance your programming skills with our MCQs on Object Oriented Programming using...

Compiler Design

Unravel the process of translating source code into executable programs with our...

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

Human Computer Interaction

Enhance your knowledge of Human-Computer Interaction with our specialized MCQs....

Computer Hardware

Explore the tangible components of computers with our Computer Hardware MCQs. Learn...

SQL Server

Master Microsoft's database server with our SQL Server MCQs. Topics cover database...

CSS

Polish your web design skills with our CSS MCQs. Learn about selectors, properties,...