Home/Computer/MySQL Mcqs Test Online

MySQL Mcqs Test Online

Maan AliLast Updated: October 10, 2025

MySQL Mcqs Test

Total Questions:	20
Time Allowed:	10 Minutes
Total Marks:	20
How to Attempt Test:	Please choose the right Option in MCQ-type question.
Test Helpful For:	Computer Test Competitive exam Forces test Fpsc Entry test Recruitment test

MySQL Mcqs Test Practice Online

Please wait...

Page 1 of 1

1. In a LIKE clause, you can could ask for any value ending in "qpt" by writing?

LIKE %qpt

LIKE *ton

LIKE ^.*ton$

LIKE ton$

2. The “Mysql command line tool” formats are bounded by?

+-}

+-/

+-|

+-*

3. Which command is used for showing current date and time in Mysql command line tool?

None of these

SELECT now();

SELECT now()

Select now()

4. Which command is used in Mysql command line tool to return to window command shell?

both a) and b)

exit;

quit;

only a)

5. To use MySQL on your computer, you'll need?

Perl, PHP or Java

A Browser

Some sort of client program to access the databases

FTP and Telnet

6. Which authentications are required for login into Mysql command line tool?

Only Username

Username

Both a) and b)

Password

7. The result of a SELECT statement can contain duplicate rows?

None of the above

False

True

8. Which statement is used to access an existing Database?

Use

USE databasename;

Use database.name

None of these

9. Mysql command line tool is used to show “how many rows are returned and how long SQL command took to execute”?

Undetermined

True

Depend

False

10. MySQL runs on which operating systems?

Any operating system at all

Unix, Linux, Windows and others

Unix and Linux only

Linux and Mac OS-X only

11. Which SQL statement is used to insert a new data in a database?

ADD

INSERT INTO

INSERT NEW

UPDATE

12. A NULL value is treated as a blank or 0.?

Fasle

None of the above

True

13. To remove duplicate rows from the result set of a SELECT use the following keyword?

DISTINCT

NO DUPLICATE

None of the above

UNIQUE

14. Which of the following is not a valid aggregate function?

COUNT

COMPUTE

MAX

MIN

15. MySQL is?

A Relational Database Management System

A Programming language

A technique for writing reliable programs

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

Insert

Add

Update

Alter

17. The “Mysql command line tool” format the results in which of the following format?

Square

Sphere

None of these

Rectangle

18. Which command is used on Mysql command line tool to return to window command shell?

exit()

exit();

exit;

exit

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

LIKE ...... (that's six dots)

LIKE .{6} Answer 5: LIKE ^.{6}$

LIKE ______ (that's six underscore characters)

LIKE ??????

20. Which command is used for taking “server side help” in Mysql command line tool?

None of these

You Can Learn and Gain more Knowledge through our Online Quiz and Testing system Just Search your desired Preparation subject at Gotest.

Introduction to Computers Online Test
Computer File Handling in “C” Test Online
Computer Functions in “C” Test Online
Computer Loop Constructs Test Online
Computer Decision Constructs Test Online
Computer Input Output Test Online
Computer Elements of “C” Test Online
Computer Getting Started with “C” Test Online
Computer Microsoft Access-Forms and Reports Test Online
Computer Table and Query Test Online

Maan AliLast Updated: October 10, 2025

MySQL Mcqs Test Online

MySQL Mcqs Test

MySQL Mcqs Test Practice Online

Related Posts

Maan Ali

Leave a Reply Cancel reply