You Scored:
Ranking:
Past Papers MySQL Solved Questions Answers
1. Which command is used on Mysql command line tool to return to window command shell?
exit()
exit();
exit (Answer)
exit;
2. The result of a SELECT statement can contain duplicate rows?
None of the above
True (Answer)
False
3. Which command is used for taking “server side help” in Mysql command line tool?
None of these
/c
/e
/h (Answer)
4. The “Mysql command line tool” format the results in which of the following format?
None of these
Rectangle (Answer)
Square
Sphere
5. Which authentications are required for login into Mysql command line tool?
Password
Username
Both a) and b) (Answer)
Only Username
6. Which command is used in Mysql command line tool to return to window command shell?
both a) and b) (Answer)
quit;
exit;
only a)
7. Which command is used for showing current date and time in Mysql command line tool?
None of these
SELECT now(); (Answer)
SELECT now()
Select now()
8. A NULL value is treated as a blank or 0.?
True
None of the above
Fasle (Answer)
9. Which SQL statement is used to insert a new data in a database?
ADD
INSERT INTO (Answer)
UPDATE
INSERT NEW
10. MySQL runs on which operating systems?
Any operating system at all
Unix, Linux, Windows and others (Answer)
Linux and Mac OS-X only
Unix and Linux only