Mysql Interview Questions and Answers | Mysql Interview Questions Answers | Mysql Interview Questions and Answers PDF | Mysql Interview Questions and Answers for Experienced | Mysql Faqs Interview Questions | Mysql Technical Interview Questions and Answers | Advanced Mysql Interview Questions with Answers | Mysql Interview Questions and Answers for Testers | Mysql Interview Questions and Answers for QA | Mysql query interview questions and answers | Mysql Interview Questions with Answers PDF Free Download | Frequently Asked Mysql Questions and Answers | Mysql Tutorial for Beginners Pdf | Mysql Interview Questions | Latest Mysql Interview Questions and Answers | Mysql Interview Questions with Answers for Freshers Pdf | Common MYSQL Interview Questions and Answers | Mysql Ebooks Free Download Pdf | Mysql Questions and Answers for Testing Interview | MYSQL Interview Questions and Answers for Testers

21.	How many levels that privileges can be granted?
	There are five levels that privileges can be granted. Global - Global privileges apply to all databases on a MySQL server. These privileges are stored in the mysql.user table. Database - Database privileges apply to all objects of a specified database. These privileges are stored in the mysql.db and mysql.host tables. Table - Table privileges apply to all columns in a given table. These privileges are stored in the mysql.tables_priv table. The GRANT ALL ON db_name.table_name and REVOKE ALL ON db_name.table_name commands grant and revoke only table level privileges. Column - Column level privileges apply to one or more columns in a given table. These privileges are stored in the mysql.columns_priv table. When using the REVOKE command to remove column level privileges, you must specify the same columns that were granted. The column or columns for which the privileges are to be granted are enclosed within parentheses. Routine - The CREATE ROUTINE, ALTER ROUTINE, EXECUTE, and GRANT privileges apply to stored routines (functions and procedures). They can be granted at the global and database levels. Also, except for CREATE ROUTINE, these privileges can be granted at the routine level for individual routines. The privileges are stored in the mysql.procs_priv table.

21.

How many levels that privileges can be granted?

There are five levels that privileges can be granted.

Global - Global privileges apply to all databases on a MySQL server. These privileges are stored in the mysql.user table.
Database - Database privileges apply to all objects of a specified database. These privileges are stored in the mysql.db and mysql.host tables.
Table - Table privileges apply to all columns in a given table. These privileges are stored in the mysql.tables_priv table. The GRANT ALL ON db_name.table_name and REVOKE ALL ON db_name.table_name commands grant and revoke only table level privileges.
Column - Column level privileges apply to one or more columns in a given table. These privileges are stored in the mysql.columns_priv table. When using the REVOKE command to remove column level privileges, you must specify the same columns that were granted. The column or columns for which the privileges are to be granted are enclosed within parentheses.
Routine - The CREATE ROUTINE, ALTER ROUTINE, EXECUTE, and GRANT privileges apply to stored routines (functions and procedures). They can be granted at the global and database levels. Also, except for CREATE ROUTINE, these privileges can be granted at the routine level for individual routines. The privileges are stored in the mysql.procs_priv table.

22.	What are the features designed for Database Management?
	Create new tables Manage table indexes Manage users Synchronize databases Back up and restore databases Create triggers, views, events, and stored procedures

23.	What is SQLyog?
	The SQLyog program is probably the most popular GUI tool for MySQL. The program has been around since August 2002 and the maturity of the product is evident when we use the tool. For people who come from a Windows desktop background this can be a very useful and practical tool. Though it only runs on Windows desktops, there is both a free community version that is somewhat limited.

24.	Tell me how do you backup a database in MYSQL?
	Backing up databases is easy with phpMyAdmin. we select the database we want to back up by clicking the database name in the left-hand navigation bar. Next we click the Export button and then make sure all tables are highlighted that we want to back up. We can then specify the options we want under Export. Make sure that we can enter a filename so we can save the output.

25.	Is phpMyAdmin user-friendly interface?
	The phpMyAdmin program has a fairly user-friendly interface. Because it is used by a number of web-hosting providers, many administrators are at least somewhat familiar with it. Although it has a modest range of abilities, it does have some flexibility in that we can access the program from anywhere with a web browser.

FeedBack Form