Page 371 - C++

CBSE AISSCE 2017-2018 Marking Scheme for Computer Science
(2018-2019 Sub Code: 083 Paper Code: 91)

(½ Mark for correct WHERE clause)
Note:
● No marks to be deducted if MONTH() is used.
● No marks to be deducted if LIKE clause is used correctly.

(iii) To display the last date of transaction (DOT) from the table TRANSACT for the
Accounts having ANO as 103.

Ans SELECT MAX(DOT) FROM TRANSACT WHERE ANO = 103;

(½ Mark for correct SELECT statement)
(½ Mark for correct WHERE clause)
(iv) To display all ANO, ANAME and DOT of those persons from tables ACCOUNT and
TRANSACT who have done transactions less than or equal to 3000.

Ans SELECT ACCOUNT.ANO,ANAME,DOT FROM ACCOUNT,TRANSACT WHERE
ACCOUNT.ANO=TRANSACT.ANO AND AMOUNT <=3000;
OR
SELECT A.ANO,ANAME,DOT FROM ACCOUNT A,TRANSACT T WHERE
A.ANO=T.ANO AND AMOUNT <=3000;

(½ Mark for correct SELECT statement)
(½ Mark for correct WHERE clause)
NOTE:
● Marks not to be deducted for writing ​SELECT ANO ​instead of
SELECT ACCOUNT.ANO / SELECT A.ANO

(v) SELECT ANO, ANAME FROM ACCOUNT
WHERE ADDRESS NOT IN ('CHENNAI', 'BANGALORE');

Ans ANO​ ​ANAME
103 Ali Reza
105 Simran Kaur

OR
ANO​ ​ANAME
101 Nirja Singh
102 Rohan Gupta
103 Ali Reza
104 Rishabh Jain
105 Simran Kaur

(½ Mark for correct output)

(vi) SELECT DISTINCT ANO FROM TRANSACT;

Ans DISTINCT ANO
101
102
103

Page #29/35