Explore topic-wise MCQs in Mysql.

This section includes 70 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.

1.

Identify the table name in the following statement.INSERT INTO Employee VALUES('Ajit','M',NULL);

A. Ajit
B. M
C. Employee
D. Values
E. None of these
Answer» D. Values
Discussion
2.

x in the following statement is ____________.DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;

A. database name
B. column name
C. server name
D. table name
E. None of these
Answer» E. None of these
Discussion
3.

In the following code, InnoDB is __________.CREATE TABLE Employee( Emp_name CHAR(30), Emp_id INT(10), PRIMARY KEY (Emp_id) ) ENGINE = InnoDB;

A. table name
B. reference engine
C. storage engine
D. database name
E. None of these
Answer» D. database name
Discussion
4.

What column names are displayed when this command is executed?SHOW COLUMNS FROM Table_Name LIKE '%name';

A. prefixed with name
B. prefixed with %name
C. suffixed with name
D. suffixed with %name
E. None of these
Answer» D. suffixed with %name
Discussion
5.

abc in the following statement is ___________.DELETE FROM xyz WHERE abc = 5;

A. table name
B. database name
C. column name
D. row name
E. None of these
Answer» D. row name
Discussion
6.

The collations this statement lists are ______________.SHOW COLLATION LIKE 'utf8%'

A. names ending in utf8%
B. names containing utf8% anywhere
C. names ending with utf8
D. names beginning with utf8
E. None of these
Answer» E. None of these
Discussion
7.

What is tamp in the following command?mysql -h xyz.host.try.net -p -u tamp

A. password
B. table name
C. user name
D. host name
E. None of these
Answer» D. host name
Discussion
8.

What is the host name in the following command?mysql -h interview.mania.com -p -u sampadam

A. interview.mania.com
B. mania
C. interview
D. interview.mania
E. None of these
Answer» B. mania
Discussion
9.

The number of attributes in the following table is ______________.CREATE TABLE Student( name CHAR(30), id INT(11) );

A. 3
B. 2
C. 1
D. 0
E. None of these
Answer» C. 1
Discussion
10.

What does Student & name specify?CREATE TABLE Student (name);

A. column specs and table name
B. table name and number of rows
C. table name and column specs
D. table name and number of columns
E. None of these
Answer» D. table name and number of columns
Discussion
11.

xyz in the following statement is __________.CREATE VIEW xyz AS SELECT a, b FROM t;

A. database
B. table
C. column
D. view
E. None of these
Answer» E. None of these
Discussion
12.

abc in the following statement is ____________.CREATE VIEW xyz (abc) AS SELECT a FROM t;

A. column name
B. row name
C. database
D. view
E. None of these
Answer» B. row name
Discussion
13.

The following statement is valid.SELECT name, id FROM Employee UNION name, salary FROM Person;

A. False
B. True
C. NA
D. NA
E. NA
Answer» C. NA
Discussion
14.

What is Employee in the following statement?SELECT name FROM Employee;

A. column name
B. table name
C. database name
D. row name
E. None of these
Answer» C. database name
Discussion
15.

The LOCAL capability for client library is enabled by ______________.

A. enable-local-infile
B. enabled-local-file
C. enable-local-file
D. enable-global-file
E. None of these
Answer» B. enabled-local-file
Discussion
16.

What are X 61626364 and X 61626364 ?

A. dcba and 1633837924
B. abcd and 1633837924
C. dcba and 4297383361
D. abcd and 4297383361
E. None of these
Answer» C. dcba and 4297383361
Discussion
17.

What is x ffff in decimal?

A. 65537
B. 65536
C. 66535
D. 65534
E. None of these
Answer» C. 66535
Discussion
18.

The mode used to turn off the special meaning of backslash and treat it as an ordinary character is _____________.

A. NO_BACKSLASH_ESCAPE
B. NO_ESCAPES_SLASH
C. NO_ESCAPES_BACKSLASH
D. NO_BACKSLASH_ESCAPES
E. None of these
Answer» E. None of these
Discussion
19.

x in the following statement is ____________.

A. database name
B. column name
C. server name
D. table name
E. None of these
Answer» E. None of these
Discussion
20.

abc in the following statement is ___________.

A. table name
B. database name
C. column name
D. row name
E. None of these
Answer» D. row name
Discussion
21.

The character that the mysql client program recognizes as a statement delimiter is ______________.

A. ,
B. ;
C. :
D. .
E. None of these
Answer» C. :
Discussion
22.

Execution on a time activated basis according to a schedule is done by _____________.

A. Stored procedures
B. Triggers
C. Stored program
D. Events
E. None of these
Answer» E. None of these
Discussion
23.

The log enabled by relay-log-index is _____________

A. binary log
B. error log
C. relay log index
D. relay log
E. None of these
Answer» D. relay log
Discussion
24.

The option that supplies the pathname to root directory of MySQL installation is _____________.

A. port
B. basedir
C. datadir
D. socket
E. None of these
Answer» C. datadir
Discussion
25.

The command to see the warning messages is ______________.

A. DISP WARNINGS
B. SHOW WARNINGS
C. DISPLAY WARNINGS
D. DISP WARNING
E. None of these
Answer» C. DISPLAY WARNINGS
Discussion
26.

Slow shutdown can be performed by setting innodb_fast_shutdown to _____________.

A. 2
B. 1
C. -1
D. 0
E. None of these
Answer» E. None of these
Discussion
27.

The privilege that must be given to the database to create a stored function or procedure is ____________.

A. CREATE PROCEDURE
B. CREATE METHOD
C. CREATE ROUTINE
D. CREATE FUNCTION
E. None of these
Answer» D. CREATE FUNCTION
Discussion
28.

How would a stored function named PI() written in the database sampdb be called?

A. db.PI()
B. MySQL.PI()
C. PI()
D. sampdb.PI()
E. None of these
Answer» E. None of these
Discussion
29.

The mode used to turn on strict mode and all of the additional restrictions is _____________.

A. TRADITIONAL
B. ERROR_WHEN_DIVIDE_BY_ZERO
C. STRICT_ALL_TABLES
D. ERROR_FOR_DIVISION_BY_ZERO
E. None of these
Answer» B. ERROR_WHEN_DIVIDE_BY_ZERO
Discussion
30.

The number of values returned from a stored procedure can be _______________.

A. 3
B. 2
C. 1
D. 0
E. None of these
Answer» E. None of these
Discussion
31.

REPAIR TABLE does not work for _____________.

A. InnoDB
B. CSV
C. ARCHIVE
D. MyISAM
E. None of these
Answer» B. CSV
Discussion
32.

Which of the following columns is not returned by OPTIMIZE TABLE ?

A. Op
B. Msg_txt
C. Msg_type
D. Table
E. None of these
Answer» C. Msg_type
Discussion
33.

The recovery of data changes made since a given point in time is called _____________.

A. clear
B. close
C. incremental
D. decremental
E. None of these
Answer» D. decremental
Discussion
34.

The line which is written at the top of the script to write a Perl script using CGI.pm is ______________.

A. put CGI
B. include CGI
C. use this CGI
D. use CGI
E. None of these
Answer» E. None of these
Discussion
35.

abc in the following statement is ____________.

A. column name
B. row name
C. database
D. view
E. None of these
Answer» B. row name
Discussion
36.

It is required to have an access privilege for a database before selecting it with USE .

A. False
B. True
C. NA
D. NA
E. NA
Answer» C. NA
Discussion
37.

The option which finds the startup options supported by the server through mysqld is ______________.

A. shutdown
B. startup
C. vertex
D. verbose
E. None of these
Answer» E. None of these
Discussion
38.

The error log file has a suffix ______________.

A. .error
B. .log
C. .err
D. .er
E. None of these
Answer» D. .er
Discussion
39.

In the CREATE TABLE statement the engine name specified is case insensitive.

A. False
B. True
C. NA
D. NA
E. NA
Answer» C. NA
Discussion
40.

The name of the format file for a table named my_tbl is __________.

A. my_tbl.fmr
B. my_tbl.fmt
C. my_tbl.ftm
D. my_tbl.frm
E. None of these
Answer» E. None of these
Discussion
41.

Server startup can also be done by the ______________.

A. system file
B. error file
C. log file
D. option file
E. None of these
Answer» E. None of these
Discussion
42.

The option used to specify the socket file pathname is ______________.

A. pathtosocket
B. path_socket
C. socket_pathfile
D. socket
E. None of these
Answer» E. None of these
Discussion
43.

The server listens on a network port for TCP/IP connections unless started with the option ______________.

A. skip-networking
B. networking
C. quit-networking
D. skip-networks
E. None of these
Answer» B. networking
Discussion
44.

The keyword used to create a database is __________.

A. SETUP
B. LINK
C. CREATE
D. SET
E. None of these
Answer» D. SET
Discussion
45.

The disk data that the FILES table in INFORMATION_SCHEMA stores is ____________.

A. NBD
B. NCD
C. NBK
D. NDB
E. None of these
Answer» E. None of these
Discussion
46.

The largest value to which the variable max_allowed_packet can be set is ______________.

A. 2GB
B. 8GB
C. 1GB
D. 4GB
E. None of these
Answer» D. 4GB
Discussion
47.

The most important configurable resource for MyISAM is ______________.

A. memory cache
B. speed cache
C. key cache
D. time cache
E. None of these
Answer» D. time cache
Discussion
48.

The storage engine for which the runtime options are always enabled is ______________.

A. MEMORY
B. InnoDB
C. FEDERATED
D. Falcon
E. None of these
Answer» B. InnoDB
Discussion
49.

The search mode that uses natural language search as a subroutine is ____________.

A. Query expansion
B. Cross mode
C. Boolean mode
D. Natural language
E. None of these
Answer» B. Cross mode
Discussion
50.

The keyword used with UNION that retains duplicate rows is ___________.

A. STRICT
B. ALL
C. DISTINCT
D. NARROW
E. None of these
Answer» C. DISTINCT
Discussion