What are four capabilities of the mysql client program?
A.
Creating and dropping databases
B.
Creating, dropping, and modifying tables and indexes
C.
Shutting down the server by using the SHUTDOWN command
D.
Creating and administering users
E.
Displaying replication status information
F.
Initiating a binary backup of the database by using the START BACKUP command
Explanation:
A, B, D, E.
ABDE
only mysql server can create and dropping the database
so BDEF is correct…
ABDE, mysqladmin can also create and drop database.
With mysql (client) you can create and drop databases:
mysql> create database mydb;
Query OK, 1 row affected (0.00 sec)
mysql> drop database mydb;
Query OK, 0 rows affected (0.00 sec)
You can’t start backups:
mysql> START BACKUP;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘BACKUP’ at line 1
e. Displaying replication status information
MariaDB [(none)]> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: myhostmachine
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000249
……
……
……
why C is not the answer?
#mysqladmin shutdown => mysqladmin can shutdown the server
mysql client is different from mysqladmin client.
mysql client cannot shutdown the server whereas mysqladmin client can.
I think ABCDE :)…
Why not A ..use mysql client program login to the database and issue create database.
A B D E