Page 313 - C++

CBSE AISSCE 2016-2017 Marking Scheme for Computer Science
(Sub Code: 083 Paper Code 91 Outside Delhi)

Ans SELECT * FROM MEMBER ORDER BY ISSUEDATE DESC;

(½ Mark for correct SELECT statement)
(½ Mark for correct ORDER BY clause)

(ii) To display the DCODE and DTITLE of all Folk Type DVDs from the table DVD

Ans SELECT DCODE,DTITLE FROM DVD WHERE DTYPE=’Folk’;

(½ Mark for correct SELECT statement)
(½ Mark for correct WHERE clause)

(iii) To display the DTYPE and number of DVDs in each DTYPE from the table DVD

Ans SELECT COUNT(*),DTYPE FROM DVD GROUP BY DTYPE;

(½ Mark for correct SELECT statement)
(½ Mark for correct GROUP BY clause)

(iv) To display all NAME and ISSUEDATE of those members from the table MEMBER who
have DVDs issued (i.e ISSUEDATE) in the year 2017

Ans SELECT NAME, ISSUEDATE FROM MEMBER WHERE
ISSUEDATE>=’2017-01-01’ AND ISSUEDATE<=’2017-12-31’;
OR
SELECT NAME, ISSUEDATE FROM MEMBER WHERE ISSUEDATE
BETWEEN ‘2017-01-01’ AND ‘2017-12-31’;
OR
SELECT NAME, ISSUEDATE FROM MEMBER WHERE ISSUEDATE LIKE
‘2017%’;
(½ Mark for correct SELECT statement)
(½ Mark for correct WHERE clause)

(v) SELECT MIN(ISSUEDATE) FROM MEMBER;

Ans MIN(ISSUEDATE)
2016-12-13
(½ Mark for correct output)

(vi) SELECT DISTINCT DTYPE FROM DVD;

Ans DISTINCT DTYPE
Folk
Classical
Rock
(½ Mark for correct output)
NOTE: Values may be written in any order
(vii) SELECT D.DCODE,NAME,DTITLE
FROM DVD D, MEMBER M WHERE D.DCODE=M.DCODE ;

Ans DCODE​ ​NAME​ ​DTITLE
R102 AGAM SINGH A day in life
F102 ARTH JOSEPH Universal Soldier
C101 NISHA HANS The Planets

(½ Mark for correct output)

Page #23 of 28