Access-Control-Methods
August 25, 2024
Software-Engineering
August 25, 2024
Access-Control-Methods
August 25, 2024
Software-Engineering
August 25, 2024

ER-Model

Question 16

Consider the following relation schema

    Students(rollno: integer, sname: string)
    Courses(courseno: integer, cname: string)
    Registration(rollno: integer, courseno: integer, percent: real)

Which of the following queries are equivalent to this query in English?

"Find the distinct names of all students who score more than 90% in the course numbered 107" 
(I) SELECT DISTINCT S.sname
    FROM Students as S,Registration as R
    WHERE R.rollno = S.roll AND R.courseno = 107 AND R.percent > 90
(II) Πsnamecourseno=107∧percent>90(Registration ⋈ Students))
(III) {T|∃S ∈ Students, ∃R ∈ Registration (S.rollno = R.rollno ∧ R.courseno = 107 ∧ R.percent > 90 ∧ T.sname = S.sname)}
(IV) {〈SN〉|∃SR∃RP(〈SR,SN〉 ∈ Students ∧ 〈SR,107,RP〉 ∈ Registration ∧ RP>90)}
A
I, II, III and IV
B
I, II and III only
C
I, II and IV only
D
II, III and IV only
Question 16 Explanation: 
Four queries given in SQL, RA, TRC and DRC and all four statements will retrieve the required information.
Correct Answer: A
Question 16 Explanation: 
Four queries given in SQL, RA, TRC and DRC and all four statements will retrieve the required information.
0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x
error: Alert: Content selection is disabled!!