17th
Feb
MYSQL MCQ

Take MYSQL Online Test & MCQ Quiz To test your knowledge 

We have listed below the best MYSQL MCQ Questions, that check your basic knowledge of the MYSQL Database. This MYSQL Online Test contains around 40 best MYSQL Multiple Choice Questions. You have to select the right answer to every question. these MCQs are very helpful for the preparation of the MYSQL Exam/Interview. Apart from this, You can also download here the MYSQL MCQ PDF completly free.

Also, Read the Best MYSQL Interview Questions.

MYSQL MCQ Questions and Answers

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

  • A. Mysqlcopydb
  • B.Mysqldbcopy
  • C.Mysqlflushdb
  • D.Mysqldbflush

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

  • A. 64
  • B.40
  • C.70
  • D.75

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

  • A. CREATE
  • B.INSERT
  • C.SELECT
  • D.UPDATE

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

  • A. Row Name
  • B.Column Name
  • C.Table Name
  • D.Database Name

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

  • A. Fetch()
  • B.Fetchrow_array()
  • C.Fetchrow_hashref()
  • D.Fetchrow_arrayref()
Download Free : MYSQL MCQ PDF

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

  • A. Error Log
  • B.Binary Log
  • C.General Query Log
  • D.Relay Log

7) Character Data Can Be Stored As

  • A. Either Fixed Or Variable Length String
  • B.Fixed Length String
  • C.Variable Length String
  • D.None Of The Mentioned

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

  • A. Varchar
  • B.Char
  • C.Both Varchar And Char
  • D.None Of The Mentioned

9) The Maximum Length Of The Char Columns Is

  • A. 65, 535 Bytes
  • B.256 Bytes
  • C.255 Bytes
  • D.None Of The Mentioned

10) The Maximum Length Of The Varchar Columns Is

  • A. Upto 65, 535 Bytes
  • B.Upto 256 Bytes
  • C.Upto 65, 567 Bytes
  • D.None Of The Mentioned

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

  • A. SHOW;
  • B.SHOW CHARACTER SET;
  • C.CHARACTER SET;
  • D.None Of The Mentioned

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

  • A. Varchar(20);
  • B.Varchar(20) Character Set Utf8;
  • C.Varchar(20) Character Set;
  • D.None Of The Mentioned

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

  • A. Long Text
  • B.Medium Text
  • C.Tiny Text
  • D.Text

14) Which Among The Following Have The Maximum Bytes?

  • A. Varchar
  • B.Char
  • C.Both Varchar And Char
  • D.Text Type

15) The "father" Of MySQL Is ______.

  • A. Bill Joy
  • B.Michael Widenius
  • C.Bill Gates
  • D.Stephanie Wall

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

  • A. Perl, PHP Or Java
  • B.A Browser
  • C.Some Sort Of Client Program To Access The Databases
  • D.FTP And Telnet

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

  • A. Mysql
  • B.Mysql.exe
  • C.Httpd
  • D.Mysqld

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

  • A. C Only
  • B.Java Only
  • C.Java And C
  • D.Perl, PHP And C

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

  • A. Multiple-master Replication
  • B.Single File Based Clustering
  • C.Master To Slave Replication
  • D.MySQL Doesn't Support Replication

20) Commands Passed To The MySQL Daemon Are Written In

  • A. English
  • B.Swedish
  • C.Your Choice From Perl, PHP, Java Or Some Other Languages
  • D.The Structured Query Language

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

  • A. DROP TABLE XXX
  • B.DELETE XXX WHERE Confirm = "YES"
  • C.DROP XXX
  • D.DROP XXX WHERE Confirm = "YES"

22) MySQL Runs On Which Operating Systems?

  • A. Unix And Linux Only
  • B.Unix, Linux, Windows And Others
  • C.Linux And Mac OS-X Only
  • D.Any Operating System At All

23) Which of the following is not supported by MySQL?

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

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

  • A. Xigang Koi
  • B.Edgar Codd
  • C.William Crawford
  • D.Mahatma Coate

25) Which Of These Is A Valid Call To A Function (watch The Spaces Carefully!)

  • A. CONCAT( A , B )
  • B.CONCAT ( A , B )
  • C.CONCAT( "A" , "B" )
  • D.CONCAT ( "A" , "B" )

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

  • A. REVOKE
  • B.UNDO
  • C.UNGRANT
  • D.DELETE

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

  • A. 255
  • B.7
  • C.65535
  • D.2 (True And False)

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

  • A. REVOKE
  • B.FETCH
  • C.LIKE
  • D.JOIN

29) The Program Called Mysql Is

  • A. There Isn't A Program Just Called Mysql
  • B.A Wrapper Through Which Java Clients Must Connect To The Databases
  • C.The Database Engine
  • D.A Client Program That Lets You Send SQL Commands To The Database Engine

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

  • A. LIKE .{6}
  • B.LIKE ______ (that's Six Underscore Characters)
  • C.LIKE ^.{6}$
  • D.LIKE ??????

31) Which Of The Following Is Available In MySQL:

  • A. CREATE VIEW
  • B.CREATE SCHEMA
  • C.CREATE TRIGGER
  • D.CREATE DATABASE

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

  • A. To
  • B.From
  • C.Far
  • D.Near

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

  • A. INSERT NEW
  • B.Add New
  • C.INSERT INTO
  • D.UPDATE

34) The SQL Keyword BETWEEN Is Used?

  • A. To Limit The Columns Displayed
  • B.As A Wildcard
  • C.For Ranges
  • D.None Of The Above

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

  • A. LIKE
  • B.Union
  • C.Group By
  • D.MAX

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

  • A. Delete
  • B.Truncate
  • C.Remove
  • D.Both A & B

37) What Is MySQL View?

  • A. Virtual
  • B.Static
  • C.Real
  • D.Temporary Table

38) Storing same data in many places is called .................

  • A. Iteration
  • B.Redundancy
  • C.Enumeration
  • D.Concurrency

39) Which level of Abstraction describes what data are stored in the Database?

  • A. View Level
  • B.Logical Level
  • C.Physical Level
  • D.Abstraction Level

40) In order to add a new column to an existing table in SQL, we can use the command ...........

  • A. Edit Table
  • B.Alter Table
  • C.Modify Table
  • D.Alter Colums

41) Which of the following is a valid SQL command?

  • A. ALTER
  • B.COMMIT
  • C.Insert
  • D.Back

42) Which of the following is true of mysql?

  • A. It is license-free for most applications.
  • B.It is written in C and C++ languages
  • C.It was owned and sponsored by the Swedish company MySQL AB
  • D.All of the Above

43) Which of the following is not a sql keyword?

  • A. DELETE
  • B.CREATE
  • C.SELECT
  • D.REMOVE

44) Which of the following is not considered to be type of database client?

  • A. Apps
  • B.​Browsers
  • C.Local software
  • D.All of the Above

45) Which of the following keywords cannot be used to modify an existing table?

  • A. ALTER TABLE...AS
  • B.ALTER TABLE...ADD
  • C.ALTER TABLE...MODIFY
  • D.ALTER TABLE...DROP COLUMN

46) The privilege ____ can be granted to retrieve data.

  • A. READ
  • B.SELECT
  • C.UPDATE
  • D.RETRIEVE

47) Which of the following is not one of the standard nosql categories?

  • A. chart databases
  • B.graph databases
  • C.document databases
  • D.column-oriented databases

48) Databases are stored in ______ so that they are available when needed.

  • A. data mines
  • B.data matrices
  • C.data sources
  • D.data dashboards

49) Which of the following is a valid sql statement?

  • A. SELECT SYSDATE;
  • B.SELECT UPPER(Hello) FROM dual;
  • C.SELECT TO_CHAR(SYSDATE, 'Month DD, YYYY') FROM dual;
  • D.None of the above

50) Mysql is an example of the _____.

  • A. hierarchical model
  • B.relational data model
  • C.file system data model
  • D.XML data model

51) The relational data model was developed in the _______.

  • A. 1970s
  • B.1979s
  • C.1980s
  • D.1960s

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Feb
Wordpress MCQ
01st
Feb
Android MCQ
01st
Mar
C++  MCQ
01st
Jun
Blue Prism MCQ