Which of the following are some general capabilites of the mysql client program?

The correct answer is A. Create and Drop databases. C. Create, Drop, and modify tables and indexes. E. Create users. F. Display replication server status. The mysql program is a general-purpose client that sends SQL statements to the server, and thus can perform any administrative operation that can be expressed using SQL. The following list describes some of its administrative capabilities:

Using MySQL Client Programs

Question

Options

ACreate and Drop databases.
BPing the server.
CCreate, Drop, and modify tables and indexes.
DShutdown the server.
ECreate users.
FDisplay replication server status.

How the community answered

(35 responses)

A
77% (27)
B
17% (6)
D
6% (2)

Explanation

The mysql program is a general-purpose client that sends SQL statements to the server, and thus can perform any administrative operation that can be expressed using SQL. The following list describes some of its administrative capabilities:

Topics

#mysql client#DDL operations#user management#replication status

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice