250+ TOP MCQs on Using MySQL Command Line Tool and Answers

MySQL Multiple Choice Questions 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

Answer: c

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

Answer: a

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

Answer: a

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

Answer: a

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;

Answer: c

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

Answer: a
Clarification: /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

Answer: d

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

Answer: c

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

Answer: b