MySQL Client/Server Concepts
2 Questions
| Attempts: 260
Quiz to review the MySQL 5.0 Certification Study Guide for Chapter 1 (MySQL Client/Server Concepts)
Questions and Answers
- 1.
Which of the following is a valid MySQL connection?
- A.
Mysql> mysql --host = localhost --password --user = name
- B.
Mysql> mysql -h localhost -u username -p password
- C.
Mysql> mysql -h localhost -u username -p --defaults-file=C:\my-opts
- D.
Mysql> mysql --host=loaclhost --user=username --password=password
Correct Answer
D. Mysql> mysql --host=loaclhost --user=username --password=passwordExplanation
A is incorrect because you can't have spaces around the equals sign using the long syntax for options
B is incorrect because if you use the short option (-p) to specify the password, the password must immediately follow (ex: -ppassword is syntactically valid)
C is incorrect because if you specify an option file, it must be the first parameter
D is correctRate this question:
-
- 2.
Which SQL modes are composite modes (have more than one value)?
- A.
ANSI
- B.
ANSI_QUOTES
- C.
TRADITIONAL
- D.
ERROR_FOR_DIVISION_BY_ZERO
- E.
IGNORE_SPACE
Correct Answer(s)
A. ANSI
C. TRADITIONALExplanation
ANSI and TRADITIONAL SQL modes are composite modes.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Dec 13, 2012Quiz Edited by
ProProfs Editorial Team -
Jul 10, 2008Quiz Created by
Mysql123
Back to top