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

Answer: c
Explanation: None.

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

Answer: a
Explanation: None.

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

Answer: a
Explanation: None.
advertisement
advertisement

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

Answer: a
Explanation: None.

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

Answer: c
Explanation: None.

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

Answer: a
Explanation: /h represents help contents for Mysql.

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

Answer: d
Explanation: None.
advertisement

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

Answer: c
Explanation: None.

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

Answer: b
Explanation: None.
advertisement

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.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.