MYSQL QUIZ DESCRIPTION Total Questions −30 00 Max Time − 15:00 The main MySQL program that does all the data handling is called MySQL myself mysql.exe httpd To see all the databases which command is used? Show database; Show databases; Show database(); Show_all database; 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 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 If you want to undo a GRANT, you should use REVOKE UNDO UNGRANT DELETE 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 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 Which of the following can add a row to a table? Alter Add Insert Create Which of these field types would be best to hold a film title? longblob tiny text medium text longtext 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 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 MySQL comes with as standard with client libraries for: C only Java only Java and C Perl, PHP, and C 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 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.*; Which of these field types would be best to hold a .jpg image? char binary char binary text blob 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 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 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}$ Internally information is held in tables. Which of these is NOT a valid format: BDB Isam99 MyISAM Hash In a LIKE clause, you can ask for any value ending in “ton” by writing LIKE ton$ LIKE ^.*ton$ LIKE %ton LIKE *ton 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 In MYSQL, can you write multiple statements in a single line? Yes No The “father” of MySQL is ______. Michael Widenius Bill Joy Bill Gates Stephanie Wall 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 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 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 is not a valid name for a column To From Far Near 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) 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. Previous Next Total Question16 Wrong Answer13 Right Answer13
