MySQL Test

Which “MySQL” client utility option is useful for MySQL query execution on the command line?

--LINE-NUMBERS

--NAMED-COMMANDS, -G

--PAGER [=COMMAND]

--EXECUTE=STATEMENT, -E STATEMENT

Which of the following is the best way to store variable length text data in a MYSQL database?

VARCHAR(255);

CHAR(255);

VARCHAR

CHAR

Which of the following relational database management system is simple to embed in a layer program?

MYSQL

SQLITE

BOTH

NONE

If you use NULL with Logical operators, NULL is considered as:

NULL

FALSE

TRUE

AN ERROR MESSAGE IS GENERATED

Which of the following are true in case of Indexes for MYISAM Tables?

Note: Select more than 1 option as correct answer

INDEXES CAN HAVE NULL VALUES

BLOB AND TEXT COLUMNS CAN BE INDEXED

INDEXES PER TABLE CANNOT BE MORE THAN 16

COLUMNS PER INDEX CANNOT BE MORE THAN 16

Which of the following is not a valid Arithmetic operator?

+

-

*

\

Which of the following operators has the highest precedence?

BINARY

NOT

<<

%

Which of the following are aggregate functions in SQL?

Note: Select more than 1 option as correct answer

AVG

SELECT

ORDER BY

SUM

Which one of the following must be specified in every DELETE statement?

TABLE NAME

DATABASE NAME

LIMIT CLAUSE

WHERE CLAUSE

Which of the following are not Numeric column types?

BIGINT

LARGEINT

SMALLINT

DOUBLE

Which of the following results in 0 (false)?

"EXPERTRATING" LIKE "EXP%"

BINARY "EXPERTRATING" LIKE "EXP%"

Which of the following statements are true?

Note: Select more than 1 option as correct answer

NAMES OF DATABASES, TABLES AND COLUMNS CAN BE UP TO 64 CHARACTERS IN LENGTH

ALIAS NAMES CAN BE UP TO 255 CHARACTERS IN LENGTH

NAMES OF DATABASES, TABLES AND COLUMNS CAN BE UP TO 256 CHARACTERS IN LENGTH

ALIAS NAMES CAN BE UP TO 64 CHARACTERS IN LENGTH

Which of the following is not a valid Bit operator?

&

&&

<<

|

In which sequence are queries and sub-queries executed by the SQL Engine?

PRIMARY QUERY -> SUB QUERY -> SUB SUB QUERY AND SO ON

THE WHOLE QUERY IS INTERPRETED AT ONE TIME

THERE IS NO FIXED SEQUENCE OF INTERPRETATION, THE QUERY PARSER TAKES A DECISION ON THE FLY

Which of the following is not a valid Comparison operator?

==

<=>

!=

<>

What is true about the ENUM data type?

Note: Select more than 1 option as correct answer

AN ENUM VALUE MAY BE A USER VARIABLE

AN ENUM MAY CONTAIN NUMBER ENCLOSED IN QUOTES

AN ENUM CANNOT CONTAIN AN EMPTY STRING

AN ENUM VALUE MAY BE NULL

Which of the following is not a MySQL Data type?

INT

INTEGER

BIT

NONE OF THE ABOVE

Which of the following statements is used to change the structure of a table once it has been created?

CHANGE TABLE

MODIFY TABLE

ALTER TABLE

UPDATE TABLE

Which operator will be evaluated first in the following statement: select (age + 3 * 4 / 2 - 8) from emp

+

-

/

*

What does DETERMINISTIC mean in the creation of a function?

THE FUNCTION RETURNS NO VALUE

THE FUNCTION ALWAYS RETURNS THE SAME VALUE FOR THE SAME INPUT

THE FUNCTION RETURNS THE INPUT VALUE

NONE OF THE ABOVE

What is wrong with the following statement? create table foo (id int auto_increment, name int);

NOTHING

THE ID COLUMN CANNOT BE AUTO INCREMENTED BECAUSE IT HAS NOT BEEN DEFINED AS A PRIMARY KEY

IT IS NOT SPELLED CORRECTLY. IT SHOULD BE: CREATE TABLE FOO (ID INT AUTO_INCREMENT, NAME INT);

NONE OF THESE

What is the maximum size of a row in a MyISAM table?

NO LIMIT

OS SPECIFIC

65,534

2'147'483'648

The Flush statement cannot be used for:

CLOSING ANY OPEN TABLES IN THE TABLE CACHE

CLOSING OPEN CONNECTIONS

FLUSHING THE LOG FILE

FLUSHING THE HOST CACHE

Which of the following queries is valid?

SELECT * FROM STUDENTS WHERE MARKS > AVG(MARKS);

SELECT * FROM STUDENTS ORDER BY MARKS WHERE SUBJECT = 'SQL';

SELECT * FROM STUDENTS HAVING SUBJECT ='SQL';

SELECT NAME FROM STUDENTS GROUP BY SUBJECT, NAME;

What kind of joins does MySQL support?

Note: Select more than 1 option as correct answer

DUAL JOIN

RIGHT JOIN

NATURAL JOIN

STRAIGHT_JOIN

Which of the following are not String column types?

BLOB

ENUM

SET

LONGCHAR

If you insert (00) as the value of the year in a date column, what will be stored in the database?

0000

1900

2000

AMBIGUOUS, CANNOT BE DETERMINED

Which of the following is not a SQL operator?

BETWEEN..AND..

LIKE

IN

ALL OF THE ABOVE ARE SQL OPERATORS

What is NDB?

AN IN-MEMORY STORAGE ENGINE OFFERING HIGH-AVAILABILITY AND DATA-PERSISTENCE FEATURES

A FILESYSTEM

AN SQL SUPERSET

MYSQL SCRIPTING LANGUAGE

What are MySQL Spatial Data Types in the following list?

Note: Select more than 1 option as correct answer

GEOMETRY

CIRCLE

POINT

POLYGON

What privilege do you need to create a function?

UPDATE

CREATE ROUTINE

SELECT

CREATE FUNCTION

Which of the following operators has the lowest precedence?

BINARY

NOT

<<

%

Which of the following commands will list the tables of the current database?

SHOW TABLES

DESCRIBE TABLES

SHOW ALL TABLES

LIST TABLES

To quote a string within a string, which of the following can you use?

Note: Select more than 1 option as correct answer

"THIS IS THE "QUOTED" MESSAGE"

"THIS IS THE ""QUOTED"" MESSAGE"

'THIS IS THE "QUOTED" MESSAGE'

"THIS IS THE \"QUOTED\" MESSAGE"

Your Name: (required)
Your Email: (required)
Skype Username:
Exams you want to pass:

Exam Type:	MySQL MCQ Skill Test
Questions Type:	Multiple Choice Questions
Total Questions:	34
Time Limit:	30 Minutes
Last Update	June, 2025

Pass MySQL Exam

MySQL Quiz

Which “MySQL” client utility option is useful for MySQL query execution on the command line?

Which of the following is the best way to store variable length text data in a MYSQL database?

Which of the following relational database management system is simple to embed in a layer program?

If you use NULL with Logical operators, NULL is considered as:

Which of the following are true in case of Indexes for MYISAM Tables?

Which of the following is not a valid Arithmetic operator?

Which of the following operators has the highest precedence?

Which of the following are aggregate functions in SQL?

Which one of the following must be specified in every DELETE statement?

Which of the following are not Numeric column types?

Which of the following results in 0 (false)?

Which of the following statements are true?

Which of the following is not a valid Bit operator?

In which sequence are queries and sub-queries executed by the SQL Engine?

Which of the following is not a valid Comparison operator?

What is true about the ENUM data type?

Which of the following is not a MySQL Data type?

Which of the following statements is used to change the structure of a table once it has been created?

Which operator will be evaluated first in the following statement: select (age + 3 * 4 / 2 - 8) from emp

What does DETERMINISTIC mean in the creation of a function?

What is wrong with the following statement? create table foo (id int auto_increment, name int);

What is the maximum size of a row in a MyISAM table?

The Flush statement cannot be used for:

Which of the following queries is valid?

What kind of joins does MySQL support?

Which of the following are not String column types?

If you insert (00) as the value of the year in a date column, what will be stored in the database?

Which of the following is not a SQL operator?

What is NDB?

What are MySQL Spatial Data Types in the following list?

What privilege do you need to create a function?

Which of the following operators has the lowest precedence?

Which of the following commands will list the tables of the current database?

To quote a string within a string, which of the following can you use?

MySQL Test Explained