MySQL Questions and Answers – Using MySQL Command Line Tool

This set of MySQL Multiple Choice Questions & Answers (MCQs) focuses on “Using MySQL Command Line Tool”.

1. Which statement is used to access an existing Database?
a) Use
b) use database.name
c) USE databasename;
d) None of the mentioned
View Answer

2. The “Mysql command line tool” format the results in which of the following format?
a) Rectangle
b) Square
c) Sphere
d) None of the mentioned
View Answer

3. The “Mysql command line tool” formats are bounded by ______________
a) +-|
b) +-*
c) +-/
d) +-}
View Answer

4. Which command is used on Mysql command line tool to return to window command shell?
a) exit
b) exit;
c) exit()
d) exit();
View Answer

5. Which command is used in Mysql command line tool to return to window command shell?
a) exit;
b) quit;
c) both exit; and quit;
d) only exit;
View Answer

6. Which command is used for taking “server side help” in Mysql command line tool?
a) /h
b) /c
c) /e
d) None of the mentioned
View Answer

7. Which authentications are required for login into Mysql command line tool?
a) Username
b) Password
c) Only Username
d) Both Username and Password
View Answer

8. Mysql command line tool is used to show “how many rows are returned and how long SQL command took to execute”.
a) True
b) False
c) Undetermined
d) Depend
View Answer

9. Which command is used for showing current date and time in Mysql command line tool?
a) select now()
b) SELECT now();
c) SELECT now()
d) None of the mentioned
View Answer

Sanfoundry Global Education & Learning Series – MySQL Database.

To practice all areas of MySQL Database, here is complete set of 1000+ Multiple Choice Questions and Answers.