Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Practice InterviewNew Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

MySQL Interview Questions and Answers

Ques 31. How To Check Server Status with "mysqladmin"?

Ans. If you want to check the server status by with "mysqladmin", you can following this tutorial example:

>cd mysqlbin
>mysqladmin -u root status
Uptime: 223 Threads: 1 Questions: 1 Slow queries: 0
Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.004

The returning message indicates that the server is almost doing nothing at this moment.

Is it helpful? Add Comment View Comments
Ques 32. How To Shut Down the Server with "mysqladmin"?
Ans. If you want to shut down the server with "mysqladmin", you can use the command "mysqladmin shutdown" as shown in the following tutorial example:

>cd mysqlbin
>mysqladmin -u root shutdown

If this command returns no messages, your MySQL server should be terminated successfully.
Is it helpful? Add Comment View Comments
Ques 33. How To Use "mysql" to Run SQL Statements?
Ans. If you want to run SQL statement to your server with "mysql", you need to start "mysql" and enter your SQL statement at the "mysql" prompt. Here is a good tutorial exercise that shows you how to run two SQL statements with "mysql":

>cd mysqlbin
>mysql -u root test
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 4 to server version: 5.0.24

mysql> CREATE TABLE links (name VARCHAR(80));
Query OK, 0 rows affected (0.10 sec)

mysql> INSERT INTO links VALUES ('www.GlobalGuideLine.com');
Query OK, 1 row affected (0.02 sec)

mysql> quit;
Bye
Is it helpful? Add Comment View Comments
Ques 34. How To Show All Tables with "mysql"?
Ans. If you want to see all the tables in a database, you run the non-SQL command "SHOW TABLES" at the "mysql" prompt. See the following tutorial exercise for example:

>cd mysqlbin
>mysql -u root test
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 14 to server version: 5.0.24

mysql> SHOW TABLES; +----------------+

| WB_Test |

+----------------+

| EMP_List |

+----------------+

1 row in set (0.01 sec)

The output shows you that there is only one table in the "test" database.
Is it helpful? Add Comment View Comments
Ques 35. What Is "mysqlcheck"?
Ans. "mysqlcheck" is a command-line interface for administrators to check and repair tables. Here are some sample commands supported by "mysqlcheck":

► "mysqlcheck databaseName tableName" - Checks the specified table in the specified database.
► "mysqlcheck databaseName" - Checks all tables in the specified database.
► "mysqlcheck --all-databases" - Checks all tables in all databases.
► "mysqlcheck --analyze databaseName tableName" - Analyzes the specified table in the specified database.
► "mysqlcheck --repair databaseName tableName" - Repairs the specified table in the specified database.
Is it helpful? Add Comment View Comments

Most helpful rated by users:

©2020 WithoutBook