How many distinct, different values can you hold in an enum field?
65535
Well Done. Your Answer is Correct Keep it Up!
255
635
7
Category: MySQL MCQs
If you want to undo a GRANT, you should use
If you want to undo a GRANT, you should use
REVOKE
Well Done. Your Answer is Correct Keep it Up!
UNDO
UNGRANT
WITHDRAW
Which of these is a valid call to a function (watch the spaces carefully!)
Which of these is a valid call to a function (watch the spaces carefully!)
CONCAT( “A” , “B” )
Well Done. Your Answer is Correct Keep it Up!
CONCAT ( A , B )
CONCAT( A , B )
None of the options are correct
Which of the following is NOT supported by MySQL
Which of the following is NOT supported by MySQL
Stored Procedures
Well Done. Your Answer is Correct Keep it Up!
Regular Expression Matching
Table Joining
Temporary (Hash) Tables
MySQL runs on which operating systems?
MySQL runs on which operating systems?
Unix, Linux, Windows and others
Well Done. Your Answer is Correct Keep it Up!
Linux and Mac OS-X only
Unix and Linux only
Any operating system at all
Which of the following can add a row to a table?
Which of the following can add a row to a table?
Insert
Well Done. Your Answer is Correct Keep it Up!
Create
Add
Alter
The USE command
The USE command
Should be used to choose the database you want to use once you’ve connected to MySQL
Well Done. Your Answer is Correct Keep it Up!
Is a pseudonym for the SELECT command
Has been deprecated and should be avoided for security reasons
Is used to load code from another file
MySQL comes with as standard with client libraries for:
MySQL comes with as standard with client libraries for:
C only
Well Done. Your Answer is Correct Keep it Up!
Java only
Java and C
Perl, PHP and C
To use MySQL on your computer, you’ll need
To use MySQL on your computer, you’ll need
Some sort of client program to access the databases
Well Done. Your Answer is Correct Keep it Up!
Perl, PHP or Java
A Browser
FTP and Telnet
The “father” of MySQL is ______.
The “father” of MySQL is ______.
Michael Widenius
Well Done. Your Answer is Correct Keep it Up!
Bill Joy
Bill Gates
Stephanie Wall