A relational database contains two tables Student and Performance as shown below:The primary key of the student table is Roll_no. For the performance table, the columns Roll_no and Subject_code together form the primary key. Consider the SQL query given below:Select S. Student_name, sum (P. Marks)FROM Student S, Performance PWHERE P. Marks andgt;84GROUP BY S.Student_name;The number of rows returned by the above SQL query is________.Correct answer is '5'. Can you explain this answer? - EduRev Computer Science Engineering (CSE) Question

Explore Courses UPSC Exam UPSC Test Series Free Notes EduRev Infinity

Open App

Computer Science Engineering (CSE) Exam > Computer Science Engineering (CSE) Questions > A relational database contains two tables Stu...

Join the Discussion on the App

A relational database contains two tables Student and Performance as shown below:

The primary key of the student table is Roll_no. For the performance table, the columns Roll_no and Subject_code together form the primary key. Consider the SQL query given below:
Select S. Student_name, sum (P. Marks)
FROM Student S, Performance P
WHERE P. Marks >84
GROUP BY S.Student_name;
The number of rows returned by the above SQL query is________.

Correct answer is '5'. Can you explain this answer?

FREE This question is part of

Test : CSE Past Year Paper 2019

Attempt Test

Attempt this Test

Verified Answer

A relational database contains two tables Student and Performance as s...

We are doing Cartesian product. So without any condition or constraint there are 5 × 6 = 30 rows.
But on applying where P marks > 84 there will be 5× 5 = 25 Rows.
So there are 5 different student names.
So after group by 5 rows would be there.

View all questions of this test

View all answers Start learning for free

< Previous Question Next Question >

Explore Courses for Computer Science Engineering (CSE) exam

Similar Computer Science Engineering (CSE) Doubts

Consider the following entity relationship diagram (ERD), where two entities E1 and E2 have arelation R of cardinality 1 : m.The attributes of E1 are A11, A12 and A13where , A11 is key attribute. The attributes of E2 are A21, A22, and A23 where A21is the key attribute andA23 is a multi-valued attribute. Relation R doesnot have any attribute. A relational database containing minimum number of tables with each table satisfying the requirements of the third normal form (3NF) is designed from the above ERD. The number of tables in the database is

View answer

Consider the following entity relationship diagram (ERD), where two entities E1 and E2 have a relation R of cardinality 1 : m.The attributes of E1 are A11, A12 and A13 where A11 is the key attribute. The attributes of E2 are A21, A22 and A23 where A21 is the key attribute and A23 is a multi-valued attribute. Relation R does not have any attribute. A relational database containing minimum number of tables with each table satisfying the requirements of the third normal form (3NF) is designed from the above ERD. The number of tables in the database is

View answer

Consider the following relational schema for students (STU):The following query is made on the database.T1→ Πid, name (σage >13∧age<16(STU))T2→ Πid, name (σmarks >55∧ marks <66(STU))T → T2 − T1The total no. of rows in T is ________. Correct answer is '1'. Can you explain this answer?

View answer

Consider the relation "enrolled(student, cours e)" in which (student, course) is the primary key, and the relation "paid(student, amount)" where student is the primary key. Assume no null values and no foreign keys or integrity constraints. Given the following four queries:Q. Which one of the following statements is correct?

View answer

Consider the relational schema given below, where eId of the relation dependent is a foreign key referring to empId of the relation employee. Assume that every employee has at least one associated dependent in the dependent relation.employee (empId, empName, empAg e)dependent(depId, eId, depName, depAge)Consider the following relational algebra query:The above query evaluates to the set of empIds of employees whose age is greater than that of

View answer

Top Courses for Computer Science Engineering (CSE)View all

GATE Computer Science Engineering(CSE) 2025 Mock Test Series

Question Bank for GATE Computer Science Engineering

General Aptitude for GATE

Computer Networks

Programming and Data Structures

Top Courses for Computer Science Engineering (CSE)

View all

A relational database contains two tables Student and Performance as shown below:The primary key of the student table is Roll_no. For the performance table, the columns Roll_no and Subject_code together form the primary key. Consider the SQL query given below:Select S. Student_name, sum (P. Marks)FROM Student S, Performance PWHERE P. Marks >84GROUP BY S.Student_name;The number of rows returned by the above SQL query is________.Correct answer is '5'. Can you explain this answer?

Share with a Friend

Answer this doubt

Question Description
A relational database contains two tables Student and Performance as shown below:The primary key of the student table is Roll_no. For the performance table, the columns Roll_no and Subject_code together form the primary key. Consider the SQL query given below:Select S. Student_name, sum (P. Marks)FROM Student S, Performance PWHERE P. Marks >84GROUP BY S.Student_name;The number of rows returned by the above SQL query is________.Correct answer is '5'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about A relational database contains two tables Student and Performance as shown below:The primary key of the student table is Roll_no. For the performance table, the columns Roll_no and Subject_code together form the primary key. Consider the SQL query given below:Select S. Student_name, sum (P. Marks)FROM Student S, Performance PWHERE P. Marks >84GROUP BY S.Student_name;The number of rows returned by the above SQL query is________.Correct answer is '5'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for A relational database contains two tables Student and Performance as shown below:The primary key of the student table is Roll_no. For the performance table, the columns Roll_no and Subject_code together form the primary key. Consider the SQL query given below:Select S. Student_name, sum (P. Marks)FROM Student S, Performance PWHERE P. Marks >84GROUP BY S.Student_name;The number of rows returned by the above SQL query is________.Correct answer is '5'. Can you explain this answer?.

Solutions for A relational database contains two tables Student and Performance as shown below:The primary key of the student table is Roll_no. For the performance table, the columns Roll_no and Subject_code together form the primary key. Consider the SQL query given below:Select S. Student_name, sum (P. Marks)FROM Student S, Performance PWHERE P. Marks >84GROUP BY S.Student_name;The number of rows returned by the above SQL query is________.Correct answer is '5'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE). Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.

Here you can find the meaning of A relational database contains two tables Student and Performance as shown below:The primary key of the student table is Roll_no. For the performance table, the columns Roll_no and Subject_code together form the primary key. Consider the SQL query given below:Select S. Student_name, sum (P. Marks)FROM Student S, Performance PWHERE P. Marks >84GROUP BY S.Student_name;The number of rows returned by the above SQL query is________.Correct answer is '5'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of A relational database contains two tables Student and Performance as shown below:The primary key of the student table is Roll_no. For the performance table, the columns Roll_no and Subject_code together form the primary key. Consider the SQL query given below:Select S. Student_name, sum (P. Marks)FROM Student S, Performance PWHERE P. Marks >84GROUP BY S.Student_name;The number of rows returned by the above SQL query is________.Correct answer is '5'. Can you explain this answer?, a detailed solution for A relational database contains two tables Student and Performance as shown below:The primary key of the student table is Roll_no. For the performance table, the columns Roll_no and Subject_code together form the primary key. Consider the SQL query given below:Select S. Student_name, sum (P. Marks)FROM Student S, Performance PWHERE P. Marks >84GROUP BY S.Student_name;The number of rows returned by the above SQL query is________.Correct answer is '5'. Can you explain this answer? has been provided alongside types of A relational database contains two tables Student and Performance as shown below:The primary key of the student table is Roll_no. For the performance table, the columns Roll_no and Subject_code together form the primary key. Consider the SQL query given below:Select S. Student_name, sum (P. Marks)FROM Student S, Performance PWHERE P. Marks >84GROUP BY S.Student_name;The number of rows returned by the above SQL query is________.Correct answer is '5'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice A relational database contains two tables Student and Performance as shown below:The primary key of the student table is Roll_no. For the performance table, the columns Roll_no and Subject_code together form the primary key. Consider the SQL query given below:Select S. Student_name, sum (P. Marks)FROM Student S, Performance PWHERE P. Marks >84GROUP BY S.Student_name;The number of rows returned by the above SQL query is________.Correct answer is '5'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.

Explore Courses for Computer Science Engineering (CSE) exam