ICT E 2014-34

Author : Admin

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

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

Which of the following SQL statements changes only the date of examination of Physics paper of GCE AL examination to 2014.08.25 ?

RATE CONTENT 0, 0

Answers

update examSubject set examDate=’2014.08.25’ where subjectId = ‘SUB003’ or ‘sub003’
update examSubject set examDate=’2014.08.25’ where examId = ‘EXAM002’ or ‘subjectId=’SUB003’
update examSubject set examDate=’2014.08.25’ where examId = ‘EXAM002’ and subjectId=’SUB003’
update examSubject set examDate=’2014.08.25’ where examDate = ‘2014.08.21’.
update examSubject set examDate=’2014.08.25’ where examId = ‘EXAM002’ or ‘subjectId=’SUB003’ or examDate = ‘2014.08.23’.

PREFERRED RESPONSE...

Comments Hide Comments(0)

Leave a Reply Cancel reply