Question: a) Q1 returns 5 tuples and Q2 return 4 tuples b) Q1 returns 5 tuples and Q2 return no tuples c) Q1 returns the ID


a) Q1 returns 5 tuples and Q2 return 4 tuples
b) Q1 returns 5 tuples and Q2 return no tuples
c) Q1 returns the ID of every student who has taken Comp352 and Comp353
d) Q2 returns the ID of every student who has taken Comp352 and Comp353
Consider the following instance of the relation Register (Student_id, CourseNo). Student_id CourseNo 111 Comp352 222 Comp352 333 Comp353 444 Comp353 555 Comp352 111 Comp346 Which of the following statements is CORRECT about the outputs of the queries Q1 and 02 below? Q1: SELECT Student_id FROM Register WHERE CourseNo="Comp352" OR CourseNo="Comp353": Q2: SELECT Student Id FROM Register WHERE CourseNo= "Comp352" AND Q1: SELECT Student_id FROM Register WHERE CourseNo="Comp352" OR CourseNo="Comp353"; Q2: SELECT Student_id FROM Register WHERE CourseNo= "Comp352" AND CourseNo= "Comp346
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
