Posts

Showing posts from December, 2013

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(*) FROM [table name]; Questions