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. Which command is used for taking “server side help” in Mysql command line tool?

Answer

None of these

Question 2

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

Answer

LIKE ^.*ton$

Question 3

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

Answer

Perl, PHP or Java

Answer

FTP and Telnet

Answer

Some sort of client program to access the databases

Question 4

4. 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 ______ (that's six underscore characters)

Answer

LIKE ??????

Question 5

5. MySQL runs on which operating systems?

Answer

Unix, Linux, Windows and others

Answer

Any operating system at all

Answer

Linux and Mac OS-X only

Answer

Unix and Linux only

Question 6

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

Answer

None of these

Answer

SELECT now()

Answer

SELECT now();

Answer

Select now()

Question 7

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

Answer

Only Username

Answer

Both a) and b)

Question 8

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

Answer

Undetermined

Question 9

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

Answer

INSERT INTO

Answer

INSERT NEW

Question 10

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

Question 11

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

Question 12

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

Answer

both a) and b)

Question 13

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

Answer

Use database.name

Answer

None of these

Answer

USE databasename;

Question 14

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

Question 15

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

Answer

None of these

Question 16

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

Answer

None of the above

Question 17

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

Answer

None of the above

Answer

NO DUPLICATE

Question 18

18. MySQL is?

Answer

A technique for writing reliable programs

Answer

A Programming language

Answer

A Relational Database Management System

Answer

A Programming language

Question 19

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

Question 20

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

Answer

None of the above

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:

Related Content

Maan Ali

Leave a Reply Cancel reply