Answer:- MySQL server is an open-source relational database management system (RDBMS) backed by oracle, based on SQL. Usually assessed using PHP. It is written in C, C++ language.

Answer:- These MySQL interview questions are best suited for beginners and intermediate users. • Mysql server is fast, reliable and easy to use • Protects sensitive data from intruders • Scalable and can handle huge amount of data • Compatible with almost every OS • PHP friendly • Large and extensive community support

Answer:- Listed below are disparate MySQL table: • MyISAM – default database engine • Heap – used for fast database access • Merge – removes the size limitation from MYISAM tables • InnoDB – supports transaction using COMMIT and Rollback • ISAM – deprecated and removed from version 5.x

Answer:- It is one of the most dealt MySQL interview questions • From and Joins • Where • Group by • Having • Select • Order By • Limit

Answer:- This MySQL interview questions could be answered in the below-mentioned way: • Inner Join : SELECT column_name(s) FROM table1 INNER JOIN table 2 ON table1.column_name = table2.column_name; • Left Join: SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name; • Right Join: SELECT column_name(s) FROM table1 RIGHT JOIN table2 ON table2.column_name = table2.column_name;

Answer:- Now this question is one of the MySQL interview questions that should be understood carefully. • Use Indexes • Don’t use “*” • Avoid unnecessary columns • Use DISTINCT and Union solely if necessary • Use short table aliases • Avoid wildcard (%) at the start of LIKE pattern

Answer:- This is among beginner MySQL interview questions. • BEFORE INSERT • AFTER INSERT • BEFORE UPDATE • AFTER UPDATE • BEFORE DELETE • AFTER DELETE

Answer:- • UNION : Combines results from SELECT queries. Returns all distinct rows. • UNION ALL: Returns all rows from all tables meeting the query. • MINUS: Returns all distinct rows selected by the first query but not the second query. • INTERSECT: Intersection of both the queries

Answer:- A null value is a field with no value present in that particular field. Moreover, the primary key does not allow null value. • = NULL or !=NULL can’t be used • IS NULL: SELECT column_names FROM table_name WHERE column_name IS NULL; • IS NOT NULL: SELECT column_names FROM table_name WHERE column_name IS NOT NULL;

Answer:- BLOB is Binary Large Objects. It is used to store binary data • Examples: TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB TEXT is Non-binary, character-based string data type • Example: TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT

Answer:- • DELETE • Deletes the data of a table • Data can be retrieved by Commit and Rollback • Where condition can be used • TRUNCATE • Deletes the data permanently • Commit and Rollback not possible • Where condition cant be used

Answer:- • CHAR • Stores the data in fixed-length format • Strings smaller than specified length are padded with space characters • Used for small data • VARCHAR • Stores values in variable length • No padding of spaces • Used to store large data

Answer:- Microsoft SQL server is a structured query language that is one of the database management systems ( DBMS) and is designed by Microsoft. DBMS are computer software applications with the capability of interacting with users, various other applications, and databases. The objective of SQL Server is capturing and analyzing data and managing the definition, querying, creation, updating, and administration of the database.

Answer:- It provides cross-platform support, a wide range of interfaces for application programming, and has many stored procedures like triggers and cursors that help in managing the MySQL database.