NEW
Font size
WorksheetsSQL Queries 6
Total questions: 10
Worksheet time: 10mins
The “father” of MySQL is ______.
Michael Widenius
Bill Joy
Bill Gates
Stephanie Wall
To use MySQL on your computer, you’ll need
Perl, PHP or Java
Some sort of client program to access the databases
A Browser
FTP and Telnet
Which of these is not a valid name for a column
Where
Near
Order
From
In a LIKE clause, you can could ask for any value ending in “ton” by writing
LIKE ton$
LIKE ^.*ton$
LIKE %ton
LIKE *ton
The USE command
Is a pseudonym for the SELECT command
Has been deprecated and should be avoided for security reasons
Should be used to choose the database you want to use once you’ve connected to MySQL
Is used to load code from another file
In a LIKE clause, you can ask for any 6 letter value by writing:
LIKE ??????
LIKE .{6}
LIKE …… (that’s six dots)
LIKE ______ (that’s six underscore characters)
MySQL runs on which operating systems?
Unix and Linux only
Linux and Mac OS-X only
Unix, Linux, Windows and others
Any operating system at all
In a LIKE clause, you can could ask for any value ending in “qpt” by writing
LIKE %qpt
LIKE *ton
LIKE ton$
LIKE ^.*ton$
Which statement is used to count number of rows in table?
SELECT COUNT(*) FROM table_name;
SELECT COUNT ALL(*) FROM table_name;
SELECT ROWS(*) FROM table_name;
All the above
Which clause is used to sort the result of SELECT statement?
SORT BY
ORDER BY
ARRANGE BY
None of the above
