MySQL Interview Questions

Question 1 : Explain Normalization & Denormalization? Question 2 : Explain 1st,2nd and 3rd Normal Form in MYSQL Database Normalization? Question 3 : Primary Key vs Foreign Key? Question 4 : Primary Key vs Candidate Key vs Unique Key? Question 5 : What is a trigger? How you can create a trigger in MYSQL? Question 6 : Explain Transactions and How to Implement it in MYSQL? Question 7 : What is an index? How can an index be declared in MYSQL? Question 8 : What is the view? How can you create and drop view in MYSQL? Question 9 : Explain Inner Join? Question 10 : Explain Left Join? Question 11 : Explain Right Join? Question 12 : Explain Cross Join? Question 13 : MYSQL Union vs Union All? Question 14 : What are MYSQL Aliases? Question 15 : Explain MYSQL Subquery? Question 16 : Blob vs Text data types in MYSQL? Question 17 : CHAR vs VARCHAR data types? Question 18 : What are the differences between InnoDB and MyISAM engines? Question 19 : What are some of the common MYSQL COMMANDS? Question 20 : What are aggregate functions in MYSQL? Question 21 : How can ENUM be used in MySQL? Question 22 : Explain GRANT Command in MySQL? Question 23 : What is the difference between Truncate and Delete? Question 24 : Explain MySQL Stored Procedures ? Question 25 : Explain MySQL Stored Function ? Question 26 : MySQL - Stored Procedures VS Stored Function Question 27 : What is self-referencing foreign key? Question 28 : What is the difference between the LIKE and REGEXP Operators? Question 29 : How does query cache work in MySQL? Question 30 : Explain the SAVEPOINT statement in MySQL Transactions? Question 31 : How does database import or export work in MySQL? Question 32 : Explain difference between IFNULL & ISNULL functions in MySQL?

Comments

Post a Comment

Popular posts from this blog

Php Interview Questions for Freshers

Image
Php Interview Questions for Freshers: Basic PHP Interview Questions as follows: 1. What is PHP? Answer: PHP stands for Hypertext Preprocessor. It is an open-source, general-purpose, server side scripting language that is especially used for web development.  2. What are some of the key features of PHP? Answer: Some of the key features of PHP are: It is completely open-source. It is compatible with many databases, like MySQL, SQLite, etc. It is platform-independent, that is, it can be run on any operating system like Linux, Unix, Windows, etc. It is object-oriented, that is it supports object oriented functionalities like encapsulation, inheritance, abstraction, and polymorphism. 3. What are superglobals in PHP? Answer: Superglobal variables in PHP are predefined global variables. Global variables are accessible from any part of a PHP script. Some examples of superglobal variables are $_GET, $_POST, $_REQUEST, $_FILES, $_COOKIE, $_SESSION, $_SERVER, $_ENV, and $GLOBALS.  4...
Read more

Singleton in PHP

Singleton is a creational design pattern, which ensures that only one object of its kind exists and provides a single point of access to it for any other code. Singleton has almost the same pros and cons as global variables. Although they’re super-handy, they break the modularity of your code. You can’t just use a class that depends on a Singleton in some other context, without carrying over the Singleton to the other context. Most of the time, this limitation comes up during the creation of unit tests.
Read more

db socket in mysql

A database socket is a communication endpoint that allows programs to connect to a database server over a network. MySQL manages connections to the database server through a socket file, a special kind of file that facilitates communications between different processes. The MySQL server's socket file is named mysqld.sock and is usually stored in the /var/run/mysqld/ directory on Ubuntu systems. For some distribution formats, the directory might be different, such as /var/lib/mysql for RPMs. Here are some things you can try if you're having trouble with socket errors: Ensure that the database service is started Check the location where your MySQL installation is looking for the socket file Ensure that MySQL has the permissions to create the socket file Restart the MySQL service Review the error log to see if you get any clues
Read more