1. What SQL clause is used to restrict the rows returned by a query? |
| WHEN |
| HAVING |
| FROM |
WHERE
|
2. The only way to join two tables is by using standard, ANSI syntax. |
| True |
| False |
|
|
3. What type of lock will deny users any access to a table? |
| IMPLICIT |
| EXPLICIT |
| EXCLUSIVE |
READ ONLY
|
4. To use a FETCH staement with a cursor you always have to supply an explicit direction such next or prior. |
| True |
| False |
|
|
5. Given an employees table as follows: empid name managerid a1 bob NULL b1 jim a1 B2 tom a1 What value will select count(managerid) from employees return? |
| 1 |
| 2 |
| 3 |
non of the above
|
6. To remove duplicate rows from the result set of a select use the following keyword(s): |
| NO DUPLICATES |
| DISTINCT |
| UNIQUE |
None of the above
|
7. The result of a SELECT statement can contain duplicate rows. |
| True |
| False |
|
|
8. A NULL value is treated as a blank or 0. |
| True |
| False |
|
|
9. 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
|
10. What was the table size limitation in MySQL 3.22? |
| 16TB |
| 4TB |
| 4GB |
2GB
|
11. Which of the following types of replication is based on propagation of SQL statements from master to slave? |
| case-based |
| activity-based |
| statement-based |
row-based
|
12. You have recently downloaded a MySQL package and want to check its integrity. Which of the following is not a method of checking integrity available with MySQL packages? |
| MD5 checksums |
| Kerberos |
| GnuPG |
RPM integrity verification
|
13. Beneath which directory, on a Linux server, is the mysqld server placed during a normal installation? |
| /usr/sbin |
| /var/lib/mysql |
| /usr/share/mysql |
/usr/lib/mysql
|
14. Which of the following commands can be used to do a minimal install of MySQL server using the RPMs? |
| rpm �q MySQL-server-VERSION.i386.rpm |
| rpm �i MySQL-server-VERSION.i386.rpm |
| rpm �p MySQL-server-VERSION.i386.rpm |
rpm �l MySQL-server-VERSION.i386.rpm
|
15. Which of the following commands should be given to connect as the anonymous user of a MySQL server running on the local host? |
| mysql �u anon |
| mysql �u � � |
| mysql -u |
mysql
|
16. Which command can be given at the mysql> prompt to disconnect? |
| mysql -l |
| BYE |
| QUIT |
mysql -q
|
17. You are entering a multiple-line query in MySQL. What does the mysql> prompt change to? |
| # |
| -> |
| ? |
&
|
18. While entering a multiple-line query, you realize that you really don�t want to execute the command. What can you enter to stop the process you are currently in? |
| \c |
| \b |
| \r |
\d
|
19. Which of the following commands should be used to create a database named �anderson�? |
| CREATE DATABASE anderson |
| CREATE �I anderson |
| DATABASE /anderson |
mysql �s anderson
|
20. After creating the �anderson" database, you want to use it. Which command should you give? |
| SELECT anderson |
| ENTER anderson |
| USE anderson |
OPEN anderson
|
