MYSQL DBA INTERVIEW QUESTIONS & ANSWERS
MYSQL DBA INTERVIEW QUESTIONS & ANSWERS Questions: 1 How to do login in mysql with unix shell? Ans. By below method if password is pass and user name is root # [mysql dir]/bin/mysql -h hostname -u root -p pass Questions : 2 how you will Create a database on the mysql server with unix shell. Ans. mysql> create database databasename; Questions : 3 how to list or view all databases from the mysql server. Ans. mysql> show databases; Questions : 4 How Switch (select or use) to a database. Ans. mysql> use databasename; Questions : 5 How To see all the tables from a database of mysql server. Ans. mysql> show tables; Questions : 6 How to see table’s field formats or description of table . Ans. mysql> describe tablename; Questions : 7 How to delete a database from mysql server. Ans. mysql> drop database databasename; Questions : 8 How we get Sum of column. Ans. mysql> SELECT SUM(*) FRO...