ICT E 2014-33

Author : Admin

Topic updated on 10/23/2017 11:32am

Consider the following three tables in a relational database to answer question 33 . Assume that a subject has only one paper for an examination.

Which of the following is the correct SQL statement to retrieve examId, name, and examDate of all examinations ?

RATE CONTENT 0, 0

Answers

select examSubject.examId, name examDate from exam, examSubject where exam.examId=examSubject.examId
select examId, name, examDate from exam and examSubject where exam.examId=examSubject.examId
select examId and name and examDate from exam and examSubject where exam.examId=examSubject.examId
select * from exam and examSubject where exam.examId=examSubject.examId
select * from exam, examSubject where exam.examId=examSubject.examId

PREFERRED RESPONSE...

Comments Hide Comments(0)

Leave a Reply Cancel reply