Management to database systems UE Past Papers Questions.

i. A clause in the sql select statement that specifies the tables to be used in the search for data.

2. A data type in MYSQL that accepts fixed-length of text data up to 255 characters.
3. A clause in the sql statement that filters the rows to be displayed.
4. A client program used to connect to MYSQL databases
5. Another name used to describe a table
6. A clause in the sql select statement that specifies the order in which the output is to be displayed
7. An alternative term used for a tuple
8. An aggregate function that returns largest value in specified column.
9. A remote login utility used to connect to MYSQL databases
10. An aggregate function that returns number of values in a specified column.

A. GROUP BY

2. TELNET
3. SUM()
4. ORDER BY
5. MYSQLADMIN
6. CHAR
7. RELATION
8. WHERE
9. COLUMN
10. COUNT()
11. DATABASE
12. FROM
13. RECORD
14. PHPMYADMIN
15. VARCHAR
16. MAX()
17. AVG()