MYSQL QUIZ DESCRIPTION

You are required to buy a license for MySQL if

  • If you use it for longer than 30 days
     

  • You use MySQL in a live application and not just for evaluation

  • You incorporate it into a product that you sell

  • You use it on a publicly accessible site

The program called MySQL is

  • There isn’t a program just called me
     

  • A wrapper through which Java clients must connect to the databases

  • A client program that lets you send SQL commands to the database engine

  • The database engine

Which of these is not a valid name for a column

  •  To
     

  • From

  • Far

  • Near

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

To see all the databases which command is used?

  • Show database;
     

  •  Show databases;

  •  Show database();

  •  Show_all database;

Which of the following is available in MySQL:

  • CREATE TRIGGER
    B. CREATE SCHEMA
    C. CREATE FAIRY LIGHTS
    D. CREATE DATABASE

  • CREATE SCHEMA

  • CREATE FAIRY LIGHTS

  • CREATE DATABASE

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

Which of the following can add a row to a table?

  •  Alter
     

  • Add

  • Insert

  • Create

Which of these is a valid call to a function (watch the spaces carefully!)

  • CONCAT(A, B  )
     

  • CONCAT  (A, B  )

  • CONCAT(  “A”, “B”  )

  • CONCAT  (  “A”, “B”  )

 Commands passed to the MySQL daemon are written in

  • Your choice from Perl, PHP, Java or some other languages
    B. English
    C. the Structured Query Language
    D. Swedish

  • English

  • the Structured Query Language

  • Swedish

What’s the difference between the DESCRIBE and SHOW FIELDS FROM commands?

  • Only SHOW FIELDS FROM can take a LIKE clause
     

  • Nothing – they’re the same thing

  • Only DESCRIBE can take a LIKE clause

In MYSQL, can you write multiple statements in a single line?

  • Yes

  • No

In a LIKE clause, you can ask for any 6 letter value by writing:

  • LIKE ??????
    B. LIKE .{6}
    C. LIKE ^.{6}$
    d. LIKE ______ (that’s six underscore characters)

  • LIKE .{6}

  • LIKE ^.{6}$

  • LIKE ______ (that’s six underscore characters)

The “father” of MySQL is ______.

  • Michael Widenius
     

  • Bill Joy

  • Bill Gates

  • Stephanie Wall

Which of the following is NOT supported by MySQL

  • Temporary (Hash) Tables
    B. Table Joining
    C. Stored Procedures
    D. Regular Expression Matching

  • Table Joining

  • Stored Procedures

  • Regular Expression Matching

Which of the following is available in MySQL:

  • CREATE VIEW
     

  • CREATE SCHEMA

  • CREATE TRIGGER

  • CREATE DATABASE

If you want to stop the processing query then which of the following command you should use?

  • QUIT
     

  • STOP

  •  /c

  •  C and D both

How many distinct, different values can you hold in an enum field?

  • 255
     

  • 7

  • 65535

  • 2 (True and False)

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

If you want to undo a GRANT, you should use

  • REVOKE
     

  • UNDO

  • UNGRANT

  • DELETE

The main MySQL program that does all the data handling is called

  • MySQL
     

  • myself

  • mysql.exe

  • httpd

A user with RELOAD privileges can

  •  Can reset passwords for any MySQL user account
     

  • Perform certain “admin type” operations such as flush table and logs from memory to disc, but can’t normally do anything “dangerous”

  • Can repopulate the databases and tables from a backup

  • Can restart the MySQL daemon in addition to any other privileges he might also have

Which of these commands will delete a table called XXX if you have appropriate authority:

  •  DROP XXX
    B. DELETE XXX WHERE confirm = “YES”
    C. DROP XXX WHERE confirm = “YES”
    D. DROP TABLE XXX

  • DELETE XXX WHERE confirm = “YES”

  • DROP XXX WHERE confirm = “YES”

  • DROP TABLE XXX

What kind of replication is supported by the MySQL server?

  • Multiple-master replication

  • Master to slave replication

  • Single file based clustering

  • MySQL doesn’t support replication

Internally information is held in tables. Which of these is NOT a valid format:

  • BDB
     

  • Isam99

  • MyISAM

  • Hash

One of the early proponents of the relational database who laid down many of the principles we use to this day was:

  •  Xigang Koi
     

  • Mahatma Coate

  • Edgar Codd

  • William Crawford

Commands passed to the MySQL daemon are written in

  • English
     

  • Your choice from Perl, PHP, Java or some other languages

  • the Structured Query Language

  • Swedish

In a LIKE clause, you can ask for any 6 letter value by writing:

  • LIKE ______ (that’s six underscore characters)
     

  • LIKE .{6}

  • LIKE ??????

  • LIKE ^.{6}$

MySQL Access security is controlled through

  • MySQL login accounts, and privileges set for each account
     

  • The ID that the user logged into the server through, and privileges set up for that account.

  • A table of valid IP addresses, and privileges set up for each IP address

  • The normal login security is sufficient for MySQL, and it does not have any extra controls of its own.

If you’re writing a client using the C language API, your source code should include the following line at the top:

  • use MySQL;
     

  • include (“myself.h”);

  • #include <mysql.h>

  • import com.mysql.*;