1. What SQL clause is used to restrict the rows returned by a query? |
WHEN
WHERE
FROM
HAVING
2. Which one of the following represents a correct order for
INSERT, INTO, SELECT, FROM, WHERE
INSERT, INTO, WHERE, AND, VALUES
INTO, INSERT, VALUES, FROM, WHERE
SELECT, FROM, WHERE, INSERT, INTO |
3. Which of the following commands should be used to create a database named “anderson”?
CREATE DATABASE anderson
CREATE –I anderson
DATABASE /anderson
SAVE |
4. In a LIKE clause, you can could ask for any value ending in "qpt" by writing
LIKE %qpt
LIKE *ton
LIKE ton$
LIKE ^.*ton$ |
5. A NULL value is treated as a blank or 0.
True
False
None of the above
|
6. To remove duplicate rows from the result set of a SELECT use the following keyword: |
NO DUPLICATE
UNIQUE
DISTINCT
None of the above |
7. MySQL is |
A Programming language
A Structure language
A technique for writing reliable programs
A Relational Database Management System |
8. The result of a SELECT statement can contain duplicate rows. |
False
True
None of the above
|
9. Which function used to get the current time in mysql? |
getTime()
Time()
NOW()
None of the above |
10. Which of the following is not a valid aggregate function? |
COUNT
MIN
MAX
COMPUTE |
11. The main MySQL program that does all the data handling is called? |
mysql.exe
mysql
mysqld
httpd
12. Which of the following is used to delete an entire MYSQL database?
mysql_drop_database
mysql_drop_entiredb
mysql_drop_db
mysql_drop_dbase |
13. A SELECT command without a WHERE clause returns?
All the records from a table that match the previous WHERE clause
All the records from a table, or information about all the records
SELECT is invalid without a WHERE clause
Nothing |
14. MySQL supports the complete SQL99 standard
True
False |
15. Primary Key does allow the Null Values. where as in Unique key doesn't accept the Null values.
True
False
|
| |
|
|
Query
