MYSQL MCQ Quiz

  1. Which Program Copies The Databases From One Server To Another?
  2. How Much Character Are Allowed To Create Database Name?
  3. To Use 'mysqldbcopy' Which Privileges Are Required On The Source Server?
  4. The Function 'fetchrow_hashref()' Returns Reference To Hash Of Row Values Keyed By ______________
  5. Which Function Returns Reference To Array Of Row Values?
  6. Which Is The Log In Which Data Changes Received From A Replication Master Server Are Written?
  7. Character Data Can Be Stored As
  8. Which Declaration Doesn't Use The Same Number Of Bytes And Consumption Of Bytes Depends On The Input Data?
  9. The Maximum Length Of The Char Columns Is
  10. The Maximum Length Of The Varchar Columns Is
  11. Mysql Support Different Character Sets, Which Command Is Used To Display All Character Sets?
  12. Which One Is The Correct Declaration For Choosing The Character Set Other Than Default?
  13. Which "text Type" Has The Maximum Number Of Bytes?
  14. Which Among The Following Have The Maximum Bytes?
MYSQL MCQ

Take MYSQL Quiz To test your Knowledge 

Below are few MYSQL MCQ test that checks your basic knowledge of MYSQL. This MYSQL Test contains around 20 questions of multiple choice with 4 options. You have to select the right answer to a question. You can see the correct answer by clicking view answer link.

Also, Read Best MYSQL interview questions.

  • Mysqlcopydb
  • Mysqldbcopy
  • Mysqlflushdb
  • Mysqldbflush
View Answer
  • Fetch()
  • Fetchrow_array()
  • Fetchrow_hashref()
  • Fetchrow_arrayref()
View Answer
  • Either Fixed Or Variable Length String
  • Fixed Length String
  • Variable Length String
  • None Of The Mentioned
View Answer
  • 65, 535 Bytes
  • 256 Bytes
  • 255 Bytes
  • None Of The Mentioned
View Answer
  • Upto 65, 535 Bytes
  • Upto 256 Bytes
  • Upto 65, 567 Bytes
  • None Of The Mentioned
View Answer
  • SHOW;
  • SHOW CHARACTER SET;
  • CHARACTER SET;
  • None Of The Mentioned
View Answer
  • Varchar(20);
  • Varchar(20) Character Set Utf8;
  • Varchar(20) Character Set;
  • None Of The Mentioned
View Answer
  • Long Text
  • Medium Text
  • Tiny Text
  • Text
View Answer
  • Varchar
  • Char
  • Both Varchar And Char
  • Text Type
View Answer
  • Bill Joy
  • Michael Widenius
  • Bill Gates
  • Stephanie Wall
View Answer
  • Perl, PHP Or Java
  • A Browser
  • Some Sort Of Client Program To Access The Databases
  • FTP And Telnet
View Answer
  • C Only
  • Java Only
  • Java And C
  • Perl, PHP And C
  • Multiple-master Replication
  • Single File Based Clustering
  • Master To Slave Replication
  • MySQL Doesn't Support Replication
View Answer
  • English
  • Swedish
  • Your Choice From Perl, PHP, Java Or Some Other Languages
  • The Structured Query Language
View Answer
  • DROP TABLE XXX
  • DELETE XXX WHERE Confirm = "YES"
  • DROP XXX
  • DROP XXX WHERE Confirm = "YES"
View Answer
  • Unix And Linux Only
  • Unix, Linux, Windows And Others
  • Linux And Mac OS-X Only
  • Any Operating System At All
View Answer
  • Temporary (Hash) Tables
  • Table Joining
  • Regular Expression Matching
  • Stored Procedures
View Answer
  • CONCAT( A , B )
  • CONCAT ( A , B )
  • CONCAT( "A" , "B" )
  • CONCAT ( "A" , "B" )
View Answer
  • There Isn't A Program Just Called Mysql
  • A Wrapper Through Which Java Clients Must Connect To The Databases
  • The Database Engine
  • A Client Program That Lets You Send SQL Commands To The Database Engine
View Answer
  • LIKE .{6}
  • LIKE ______ (that's Six Underscore Characters)
  • LIKE ^.{6}$
  • LIKE ??????
View Answer
  • CREATE VIEW
  • CREATE SCHEMA
  • CREATE TRIGGER
  • CREATE DATABASE
View Answer
  • To Limit The Columns Displayed
  • As A Wildcard
  • For Ranges
  • None Of The Above
View Answer
  • Virtual
  • Static
  • Real
  • Temporary Table
View Answer