You Scored:
Ranking:
Past Papers MySQL Database Solved Questions Answers
MySQL
1. MySQL is?
A Programming language
A Relational Database Management System (Answer)
A technique for writing reliable programs
A Programming language
2. In a LIKE clause, you can ask for any 6 letter value by writing?
LIKE .{6} Answer 5: LIKE ^.{6}$
LIKE ------ (that's six underscore characters) (Answer)
LIKE ??????
LIKE ...... (that's six dots)
3. Mysql command line tool is used to show “how many rows are returned and how long SQL command took to execute”?
Undetermined (Answer)
True
False
Depend
4. To remove duplicate rows from the result set of a SELECT use the following keyword?
None of the above
NO DUPLICATE
UNIQUE
DISTINCT (Answer)
5. In a LIKE clause, you can could ask for any value ending in "qpt" by writing?
LIKE ^.*ton$
LIKE ton$
LIKE *ton
LIKE %qpt (Answer)
6. To use MySQL on your computer, you'll need?
FTP and Telnet
A Browser
Some sort of client program to access the databases (Answer)
Perl, PHP or Java
7. Which of the following can add a row to a table?
Alter
Insert (Answer)
Update
Add
8. Which of the following is not a valid aggregate function?
COMPUTE (Answer)
MIN
MAX
COUNT
9. Which statement is used to access an existing Database?
Use
USE databasename; (Answer)
None of these
Use database.name
10. The “Mysql command line tool” formats are bounded by?
+-}
+-| (Answer)
+-/
+-*
