MySQL

MySQL Interview questions

MySQL Interview August 09, 2008 at 18:10 pm by Rajmeet Ghai Explain about MySQL and its features. Answer - MySQL is a relational database management system which........             What are the disadvantages of MySQL? Answer - MySQL does not support a very large database size as efficiently........ What are the security recommendations while using MySQL? Answer - Access to the user table should never be given to avoid SQL injection attacks.......... Describe MyISAM table. Answer - In MySQL MyISAM is the default storage engine. MyISAM tables........ What is HEAP table? Answer - Tables that are present in the memory are called as HEAP tables. When creating a HEAP table........ What is Query Cache in MySQL? Answer - Query Cache in MySQL is used in scenarios when the same queries need to be executed.......... How is Exception Handling handled in MySQL? Answer - Exception handling means changing the usual expected flow of the code.......... What are the Performance and Scalability characteristics of MySQL? Answer - MySQL has a unique storage engine architecture that makes it adaptable to most......... What are the limitations of mysql in Comparison of Oracle? Answer - Transactions are better supported in Oracle as compared to Mysql.......... What is a Trigger in MySQL? Define different types of Trigger? Answer - A trigger is a set of code which is executed in response to some event. .......... What is the difference between CHAR_LENGTH and LENGTH? Answer - CHAR_LENGTH includes leading and trailing blanks and the string-termination....... Explain the difference between BOOL, TINYINT and BIT. Answer - BIT data type can store up to 8 bytes from My SQL version 5.0.3....... What are ENUMs used for in MySQL? Answer - Using Enum can restrict the number of values that can be allowed to go inside a table. If there is an ENUM for Colors ..... Explain MySQL Aggregate Functions. Answer - Aggregate functions in MySQL are a group of functions that are used to operate....... Describe Transaction-Safe Table Types in MySQL Answer - While using transactions in MySQL a transaction –safe table type must....... Describe MySQL Connection using mysql binary. Answer - Establishing connection to MySQL database using Mysql binary........ Describe MySQL Connection using PHP Script. Answer - Establishing connection to MySQL database using PHP can be done...........