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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!