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?

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.

MYSQL MCQ

1. Which Program Copies The Databases From One Server To Another?

  • Mysqlcopydb
  • Mysqldbcopy
  • Mysqlflushdb
  • Mysqldbflush
View Answer

2. How Much Character Are Allowed To Create Database Name?

  • 64
  • 40
  • 70
  • 75

3. To Use 'mysqldbcopy' Which Privileges Are Required On The Source Server?

  • CREATE
  • INSERT
  • SELECT
  • UPDATE

4. The Function 'fetchrow_hashref()' Returns Reference To Hash Of Row Values Keyed By ______________

  • Row Name
  • Column Name
  • Table Name
  • Database Name
View Answer

5. Which Function Returns Reference To Array Of Row Values?

  • Fetch()
  • Fetchrow_array()
  • Fetchrow_hashref()
  • Fetchrow_arrayref()
View Answer

6. Which Is The Log In Which Data Changes Received From A Replication Master Server Are Written?

  • Error Log
  • Binary Log
  • General Query Log
  • Relay Log
View Answer

7. Character Data Can Be Stored As

  • Either Fixed Or Variable Length String
  • Fixed Length String
  • Variable Length String
  • None Of The Mentioned
View Answer

8. Which Declaration Doesn't Use The Same Number Of Bytes And Consumption Of Bytes Depends On The Input Data?

  • Varchar
  • Char
  • Both Varchar And Char
  • None Of The Mentioned
View Answer

9. The Maximum Length Of The Char Columns Is

  • 65, 535 Bytes
  • 256 Bytes
  • 255 Bytes
  • None Of The Mentioned
View Answer

10. The Maximum Length Of The Varchar Columns Is

  • Upto 65, 535 Bytes
  • Upto 256 Bytes
  • Upto 65, 567 Bytes
  • None Of The Mentioned
View Answer

11. Mysql Support Different Character Sets, Which Command Is Used To Display All Character Sets?

  • SHOW;
  • SHOW CHARACTER SET;
  • CHARACTER SET;
  • None Of The Mentioned
View Answer

12. Which One Is The Correct Declaration For Choosing The Character Set Other Than Default?

  • Varchar(20);
  • Varchar(20) Character Set Utf8;
  • Varchar(20) Character Set;
  • None Of The Mentioned
View Answer

13. Which "text Type" Has The Maximum Number Of Bytes?

  • Long Text
  • Medium Text
  • Tiny Text
  • Text
View Answer

14. Which Among The Following Have The Maximum Bytes?

  • Varchar
  • Char
  • Both Varchar And Char
  • Text Type
View Answer

15. The "father" Of MySQL Is ______.

  • Bill Joy
  • Michael Widenius
  • Bill Gates
  • Stephanie Wall
View Answer

16. To Use MySQL On Your Computer, You'll Need

  • Perl, PHP Or Java
  • A Browser
  • Some Sort Of Client Program To Access The Databases
  • FTP And Telnet
View Answer

17. The Main MySQL Program That Does All The Data Handling Is Called

  • Mysql
  • Mysql.exe
  • Httpd
  • Mysqld

18. MySQL Comes With As Standard With Client Libraries For:

  • C Only
  • Java Only
  • Java And C
  • Perl, PHP And C

19. What Kind Of Replication Is Supported By The MySQL Server?

  • Multiple-master Replication
  • Single File Based Clustering
  • Master To Slave Replication
  • MySQL Doesn't Support Replication
View Answer

20. Commands Passed To The MySQL Daemon Are Written In

  • English
  • Swedish
  • Your Choice From Perl, PHP, Java Or Some Other Languages
  • The Structured Query Language
View Answer

21. Which Of These Commands Will Delete A Table Called XXX If You Have Appropriate Authority:

  • DROP TABLE XXX
  • DELETE XXX WHERE Confirm = "YES"
  • DROP XXX
  • DROP XXX WHERE Confirm = "YES"
View Answer

22. MySQL Runs On Which Operating Systems?

  • Unix And Linux Only
  • Unix, Linux, Windows And Others
  • Linux And Mac OS-X Only
  • Any Operating System At All
View Answer

23. Which Of The Following Is NOT Supported By MySQL

  • Temporary (Hash) Tables
  • Table Joining
  • Regular Expression Matching
  • Stored Procedures
View Answer

24. One Of The Early Proponents Of Relational Database Who Laid Down Many Of The Principles We Use To This Day Was:

  • Xigang Koi
  • Edgar Codd
  • William Crawford
  • Mahatma Coate
View Answer

25. 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" )
View Answer

26. If You Want To Undo A GRANT, You Should Use

  • REVOKE
  • UNDO
  • UNGRANT
  • DELETE

27. How Many Distinct, Different Values Can You Hold In An Enum Field?

  • 255
  • 7
  • 65535
  • 2 (True And False)

28. Which Of The Following Is NOT Available In MySQL:

  • REVOKE
  • FETCH
  • LIKE
  • JOIN

29. The Program Called Mysql Is

  • 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

30. In A LIKE Clause, You Can Ask For Any 6 Letter Value By Writing:

  • LIKE .{6}
  • LIKE ______ (that's Six Underscore Characters)
  • LIKE ^.{6}$
  • LIKE ??????
View Answer

31. Which Of The Following Is Available In MySQL:

  • CREATE VIEW
  • CREATE SCHEMA
  • CREATE TRIGGER
  • CREATE DATABASE
View Answer

32. Which Of These Is Not A Valid Name For A Column

  • To
  • From
  • Far
  • Near

33. Which Statement Is Used To Insert A New Data In A Database?

  • INSERT NEW
  • Add New
  • INSERT INTO
  • UPDATE
View Answer

34. The SQL Keyword BETWEEN Is Used?

  • To Limit The Columns Displayed
  • As A Wildcard
  • For Ranges
  • None Of The Above
View Answer

35. Which Of The Following Is An Aggregate Function In MySQL?

  • LIKE
  • Union
  • Group By
  • MAX

36. Which Command Is Used To Remove All Rows From A Table?

  • Delete
  • Truncate
  • Remove
  • Both A & B
View Answer

37. What Is MySQL View?

  • Virtual
  • Static
  • Real
  • Temporary Table
View Answer