SQL Queries 6

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