MySQL Mcqs Test Online

Q: How can I prepare for MySQL Mcqs Test Online?

You can prepare for MySQL Mcqs Test Online by attempting the free online quizzes at Gotest.com.pk. We provide instant results, performance reports, and detailed explanations for every question.

Question 1

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

Answer

FTP and Telnet

Answer

Some sort of client program to access the databases

Answer

Perl, PHP or Java

Question 2

2. MySQL runs on which operating systems?

Answer

Unix and Linux only

Answer

Any operating system at all

Answer

Unix, Linux, Windows and others

Answer

Linux and Mac OS-X only

Question 3

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

Question 4

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

Answer

None of these

Question 5

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

Question 6

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

Answer

Undetermined

Question 7

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

Answer

None of these

Question 8

8. MySQL is?

Answer

A Programming language

Answer

A Programming language

Answer

A technique for writing reliable programs

Answer

A Relational Database Management System

Question 9

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

Answer

Use database.name

Answer

USE databasename;

Answer

None of these

Question 10

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

Answer

None of the above

Question 11

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

Answer

Only Username

Answer

Both a) and b)

Question 12

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

Answer

Select now()

Answer

SELECT now()

Answer

None of these

Answer

SELECT now();

Question 13

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

Answer

both a) and b)

Question 14

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

Answer

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

Answer

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

Answer

LIKE ??????

Answer

LIKE ______ (that's six underscore characters)

Question 15

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

Answer

LIKE ^.*ton$

Question 16

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

Answer

INSERT INTO

Answer

INSERT NEW

Question 17

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

Answer

None of the above

Question 18

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

Question 19

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

Answer

None of the above

Answer

NO DUPLICATE

Question 20

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

Question 21

Loading...

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 Online

MySQL Mcqs Test

MySQL Mcqs Test Practice Online

Study Plan for MySQL Mcqs Test Online

How to Use GoTest for Preparation:

Maan Ali

Leave a Reply Cancel reply

MySQL Mcqs Test

MySQL Mcqs Test Practice Online

Study Plan for MySQL Mcqs Test Online

How to Use GoTest for Preparation:

Latest Updates

Maan Ali

Leave a Reply Cancel reply