MySQL MCQ Questions

MySQL MCQ Questions | Freshers & Experienced

  • Sharad Jaiswal
  • 17th Jun, 2021

Practice here the best MySQL MCQ Questions, which are very popular and asked various times. This MySQL MCQ Quiz contains the best 25+ MySQL Multiple Choice Questions, which cover the latest and important topics of MySQL. for which, you can perform best in MySQL MCQ, Interviews, Exams, and Placement drives.

Practice Best MySQL MCQ Questions;

1) Which Of The Following Is NOT Supported By MySQL?

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

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

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

3) which of the following is available in mysql?

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

4) which of the following is not available in mysql?

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

5) The father of mysql is ...........

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

6) The Program Called Mysql Is

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

7) The commands passed to the mysql daemon are written in ............

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

8) Which of the following is true about mysql?

  • A. It is a Microsoft product.
  • B.It limits databases to 2 TB in size.
  • C.It is license-free for most applications.
  • D.It is a paid and proprietary database product.

9) MySQL Comes With As Standard With Client Libraries For

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

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

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

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

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

12) Which Among The Following Have The Maximum Bytes?

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

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

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

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

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

15) Which of the following is used to delete an entire MYSQL database?

  • A. drop db dbname
  • B.drop dbase dbname
  • C.drop entiredb dbname
  • D.drop database dbname

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

  • A. mysql
  • B.httpd
  • C.mysqld
  • D.mysql.exe

17) which declaration represents that character data will consume the same number of bytes as declared?

  • A. Varchar
  • B.Char
  • C.Both A & B
  • D.None of the above

18) Which declaration doesn’t use the same number of bytes and consumption of bytes depends on the input data?

  • A. Char
  • B.Varchar
  • C.Both Char & Varchar
  • D.None of the above

19) Which of the following is not a valid aggregate function?

  • A. MIN
  • B.MAX
  • C.COUNT
  • D.COMPUTE

20) Character data can be stored as .............

  • A. Fixed length string
  • B.Variable length string
  • C.Either Option A or B
  • D.None of the above

21) In PHP in order to access MySQL database you will use

  • A. sql_connect() function
  • B.mysqlconnect() function
  • C.mysql_connect() function
  • D.None of the above

22) Which of the following “text type” has the maximum number of bytes?

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

23) Numeric Data is used to store ........

  • A. Whole numbers
  • B.Natural numbers
  • C.Rational numbers
  • D.Both Whole and Natural Numbers

24) Mysql runs on which operating systems?

  • A. Unix and Linux only
  • B.Linux and Mac OS-X only
  • C.Unix, Linux, Windows and others
  • D.None of the above

25) How much character are allowed to create database name?

  • A. 64
  • B.72
  • C.55
  • D.40

26) What is the use of extent in oracle?

  • A. Temporary Segment
  • B.Tablespaces
  • C.logical database space
  • D.Stack space

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.