MySQL Quiz Online Test Mcqs Questions with Answers Objective Type PDF

Question 1 of 20

Uncategorized

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

False

None of the above

True

Question 1 of 20

Question 2 of 20

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

+-*

+-|

+-}

+-/

Question 2 of 20

Question 3 of 20

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

exit;

exit();

exit

exit()

Question 3 of 20

Question 4 of 20

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

USE databasename;

Use

None of these

Use database.name

Question 4 of 20

Question 5 of 20

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

Both a) and b)

Only Username

Password

Username

Question 5 of 20

Question 6 of 20

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

True

Depend

False

Undetermined

Question 6 of 20

Question 7 of 20

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

LIKE ton$

LIKE ^.*ton$

LIKE *ton

LIKE %qpt

Question 7 of 20

Question 8 of 20

8. MySQL is?

A Programming language

A Relational Database Management System

A technique for writing reliable programs

Question 8 of 20

Question 9 of 20

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

Update

Insert

Alter

Add

Question 9 of 20

Question 10 of 20

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

True

Fasle

None of the above

Question 10 of 20

Question 11 of 20

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

NO DUPLICATE

UNIQUE

DISTINCT

None of the above

Question 11 of 20

Question 12 of 20

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

COUNT

MAX

MIN

COMPUTE

Question 12 of 20

Question 13 of 20

13. MySQL runs on which operating systems?

Unix and Linux only

Any operating system at all

Unix, Linux, Windows and others

Linux and Mac OS-X only

Question 13 of 20

Question 14 of 20

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

SELECT now()

Select now()

SELECT now();

None of these

Question 14 of 20

Question 15 of 20

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

INSERT INTO

UPDATE

ADD

INSERT NEW

Question 15 of 20

Question 16 of 20

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

/h

None of these

/c

/e

Question 16 of 20

Question 17 of 20

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

Sphere

Rectangle

Square

None of these

Question 17 of 20

Question 18 of 20

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

Some sort of client program to access the databases

A Browser

Perl, PHP or Java

FTP and Telnet

Question 18 of 20

Question 19 of 20

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

LIKE ??????

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

LIKE ______ (that's six underscore characters)

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

Question 19 of 20

Question 20 of 20

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

exit;

both a) and b)

only a)

quit;

Question 20 of 20

Test Instructions
Test Name	:	Mysql MCQs
Subject	:	Computer General
Test Type	:	Mcqs
Total Question	:	20
Total Marks	:	40
Total Time	:	20 Minutes

Gotest

MySQL Quiz Online Test Mcqs

Test Instructions

MySQL Quiz Online Test Mcqs Questions with Answers Objective Type PDF

Uncategorized

Check Other Related Topics

Leave a Reply Cancel reply

Newspaper Jobs in Pakistan




All Daily Jobs in Pakistan click here