Page 8 - IP

3. (a) What is MySQL used for ? Abhay wants to start learning MySQL.

From where can he obtain the MySQL software ? 1

(b) In the table ‘‘Student’’, Priya wanted to increase the Marks (Column

Name:Marks) of those students by 5 who have got Marks below 33.

She has entered the following statement :

SELECT Marks+5 FROM Student WHERE Marks<33;

Identify errors (if any) in the above statement. Rewrite the correct

SQL statement. 1

(c) (i) Name the Data type that should be used to store

AccountCodes like ‘‘A1001’’ of Customers. 1

(ii) Name two Data types that require data to be enclosed in

quotes. 1 2

(d) Given the table ‘Player’ with the following columns :

Table : Player

PCODE POINTS

1 50
2 NULL

3 40

Write the output of the following statements : 2

(i) SELECT AVG(POINTS)
FROM Player;

(ii) Select COUNT(POINTS) FROM Player;

90 4