Page 1 - Home Assignment-Simple Queries in SQL

Computer Science

Class – XII

Topic: Simple Queries in SQL

1. The __________________ keyword eliminates duplicate records from the result of a
select statement.
2. Pattern in MySQL are described using two special wildcard characters ________ and
_________.
3. The _______________ function is used to count the number of NOT NULL entries in a
column.
4. The __________________ command helps us to see the structure of a table.
5. ___________________ works as a range operator in MySQL (IN/IS/BETWEEN)

6. The __________________clause allows sorting of query results.
7. What is the significance of datatype in SQL? What are the three categories of data type
available in SQL.
8. What is the difference between the datatypes char and varchar?
9. What is NULL value?
10. Compare string datatypes Char, Binary, BLOB and Text of MySQL.
11. Write SQL queries (i) to (viii) and find outputs for SQL queries (ix) to (xii) which are based
on the tables:

Note: PERKM is Freight Charges per Kilometer

Note: KM is Kilometers travelled
NOP is the number of passengers travelled in vehicle