Practice Mysql Multiple Choice Questions with Answers Quiz-1

Q.1.

Which of the following is not a date function?

Month
Year
Now
Pow

Q.2.

MySQL is

A Programming language
A technique for writing reliable programs
A Relational Database Management System
None of the Above

Q.3.

Which type of database management system is MySQL?

Object-oriented
Hierarchical
Relational
Network

Q.4.

What is the full form of SQL?

Structured Query Language
Structured Query List
Simple QueryLanguage
None of these

Q.5.

What will be the output of the following query:Select round(59999.99,-2);

59999
59900
60000
59990

Q.6.

Which of the following scripts will run successfully?

SELECT customer name FROM customers;
SELECT FROM `customers` 'customer name';
SELECT `customer name` FROM customers ORDER BY zone WHERE cat_id = 12;
SELECT `customer name` FROM customers WHERE cat_id = 12 ORDER BY cat_id;

Q.7.

Which of the following can add a row to a table?

Add
Insert
Update
Alter

Q.8.

What will be returned by the given query? SELECT INSTR("INDIA", "DI");

2
3
-2
-3

Q.9.

What will be printed by the given query? SELECT LENGTH("WINNER");

7
6
8
9

Q.10.

What will be returned by the given query? SELECT round(153.2);

153.6
153.66
153.67
153.7

Q.11.

Which of the following is not a numeric function?

MOD
SIGN
MID
POW

Q.12.

With SQL, how do you select all the columns from a table named "Persons"?

SELECT * FROM Persons
SELECT Persons
SELECT [all] FROM Persons
SELECT *.Persons

Q.13.

What will be returned by the given query? SELECT concat("It", "was", "ok");

"It was ok"
"Itwasok"
"Itwas ok"
"Tt wasok"

Q.14.

Which of the following is not a relational operator?

&&
>=
!=
=

Q.15.

In a LIKE clause, you can ask for any 6 letter value by writing

LIKE ______ (that's six underscore characters)
LIKE ...... (that's six dots)
LIKE .{6}
LIKE ??????

Q.16.

Which of the following is not a valid aggregate function?

COUNT
MIN
COMPUTE
MAX

Q.17.

Which of the following are valid column names?

Marks Eng
66_Marks
Marks_Eng
#Eng_Marks

Q.18.

What will be returned by the given query? SELECT month('2020-05-11');

5
11
May
November

Q.19.

What will be returned by the given query? SELECT sign(26);

1
-1
0
none

Q.20.

Which of the following is not a text function?

TRIM()
TRUNCATE()
LEFT()
MID()

Support mcqgeeks.com by disabling your adblocker.