MySQL INTERVIEW QUESTIONS

S.No	Chapter Name - Lesson Name	Action	Question Count#
1	Chapter 2 - Introduction to Software Applications - Application Software	View Questions	10
2	Chapter 2 - Introduction to Software Applications - Software Development Life Cycle	View Questions	10
3	Chapter 2 - Introduction to Software Applications - Database Components	View Questions	10
4	Chapter 2 - Introduction to Software Applications - Database Platforms	View Questions	10
5	Chapter 2 - Introduction to Software Applications - GUI tools for SQL Development	View Questions	10
6	Chapter 3 - Database Tables, Columns and Rows - SQL	View Questions	10
7	Chapter 3 - Database Tables, Columns and Rows - ROWs and COLUMNs	View Questions	10
8	Chapter 3 - Database Tables, Columns and Rows - Database Table	View Questions	10
9	Chapter 4 - Setup Sample Database - Database Hosting	View Questions	15
10	Chapter 5 - DDL (Data Definition Language) - DROP TABLE	View Questions	10
11	Chapter 5 - DDL (Data Definition Language) - Data Types	View Questions	10
12	Chapter 5 - DDL (Data Definition Language) - JSON Data Type	View Questions	10
13	Chapter 5 - DDL (Data Definition Language) - NUll vs NOT NULL	View Questions	10
14	Chapter 5 - DDL (Data Definition Language) - CHECK Constraint	View Questions	10
15	Chapter 5 - DDL (Data Definition Language) - DEFAULT Constraint	View Questions	10
16	Chapter 5 - DDL (Data Definition Language) - UNIQUE Constraint	View Questions	10
17	Chapter 5 - DDL (Data Definition Language) - AUTO INCREMENT	View Questions	10
18	Chapter 5 - DDL (Data Definition Language) - CREATE TABLE	View Questions	10
19	Chapter 5 - DDL (Data Definition Language) - ALTER TABLE	View Questions	10
20	Chapter 6 - DML (Data Manipulation Language) - TRUNCATE	View Questions	10
21	Chapter 6 - DML (Data Manipulation Language) - UPSERT	View Questions	10
22	Chapter 6 - DML (Data Manipulation Language) - SELECT INTO	View Questions	10
23	Chapter 6 - DML (Data Manipulation Language) - INSERT	View Questions	10
24	Chapter 6 - DML (Data Manipulation Language) - DELETE	View Questions	15
25	Chapter 6 - DML (Data Manipulation Language) - UPDATE	View Questions	15
26	Chapter 7 - DQL (Data Query Language) - SELECT *	View Questions	58
27	Chapter 7 - DQL (Data Query Language) - WHERE Clause	View Questions	10
28	Chapter 7 - DQL (Data Query Language) - DISTINCT	View Questions	10
29	Chapter 7 - DQL (Data Query Language) - LIMIT	View Questions	10
30	Chapter 7 - DQL (Data Query Language) - ORDER BY	View Questions	10
31	Chapter 7 - DQL (Data Query Language) - BETWEEN Operator	View Questions	10
32	Chapter 7 - DQL (Data Query Language) - CONCAT	View Questions	10
33	Chapter 7 - DQL (Data Query Language) - IN Operator	View Questions	10
34	Chapter 7 - DQL (Data Query Language) - NOT IN Operator	View Questions	10
35	Chapter 7 - DQL (Data Query Language) - IS NULL Operator	View Questions	10
36	Chapter 7 - DQL (Data Query Language) - IS NOT NULL Operator	View Questions	10
37	Chapter 7 - DQL (Data Query Language) - 'AND' and 'OR' Operators	View Questions	10
38	Chapter 7 - DQL (Data Query Language) - '>' and '<' Operator (greater than, less than)	View Questions	10
39	Chapter 7 - DQL (Data Query Language) - '< >' or '!=' Operator (not equal)	View Questions	10
40	Chapter 7 - DQL (Data Query Language) - '=' (equal to) Operator	View Questions	10
41	Chapter 7 - DQL (Data Query Language) - LIKE Operator	View Questions	10
42	Chapter 7 - DQL (Data Query Language) - NOT LIKE Operator	View Questions	10
43	Chapter 7 - DQL (Data Query Language) - EXISTS, ANY and ALL Clause	View Questions	10
44	Chapter 7 - DQL (Data Query Language) - SQL Aliases	View Questions	10
45	Chapter 7 - DQL (Data Query Language) - GROUP BY	View Questions	10
46	Chapter 7 - DQL (Data Query Language) - HAVING Clause	View Questions	10
47	Chapter 7 - DQL (Data Query Language) - COUNT, SUM, AVG, MIN, MAX Functions	View Questions	10
48	Chapter 7 - DQL (Data Query Language) - CASE statement	View Questions	10
49	Chapter 7 - DQL (Data Query Language) - INNER JOIN	View Questions	10
50	Chapter 7 - DQL (Data Query Language) - LEFT JOIN	View Questions	10
51	Chapter 7 - DQL (Data Query Language) - RIGHT JOIN	View Questions	10
52	Chapter 7 - DQL (Data Query Language) - UNION and UNION ALL	View Questions	10
53	Chapter 7 - DQL (Data Query Language) - PIVOT	View Questions	10
54	Chapter 7 - DQL (Data Query Language) - Sub Queries	View Questions	10
55	Chapter 7 - DQL (Data Query Language) - GROUP RANK	View Questions	10
56	Chapter 7 - DQL (Data Query Language) - JSON SELECT	View Questions	10
57	Chapter 7 - DQL (Data Query Language) - Arithmetic Operators	View Questions	10
58	Chapter 7 - DQL (Data Query Language) - Comparison Operators	View Questions	10
59	Chapter 7 - DQL (Data Query Language) - Logical Operators	View Questions	10
60	Chapter 7 - DQL (Data Query Language) - STRING functions	View Questions	10
61	Chapter 7 - DQL (Data Query Language) - DATE functions	View Questions	10
62	Chapter 7 - DQL (Data Query Language) - NUMERIC functions	View Questions	10
63	Chapter 7 - DQL (Data Query Language) - SQL Execution Order	View Questions	10
64	Chapter 7 - DQL (Data Query Language) - COALESCE	View Questions	10
65	Chapter 7 - DQL (Data Query Language) - CAST	View Questions	10
66	Chapter 8 - RDBMS Concepts - Normalization	View Questions	10
67	Chapter 8 - RDBMS Concepts - Second Normal Form	View Questions	10
68	Chapter 8 - RDBMS Concepts - What is RDBMS	View Questions	20
69	Chapter 8 - RDBMS Concepts - Structured VS Unstructured	View Questions	10
70	Chapter 8 - RDBMS Concepts - Primary Key	View Questions	10
71	Chapter 8 - RDBMS Concepts - Foreign Key	View Questions	10
72	Chapter 8 - RDBMS Concepts - Database Index	View Questions	10
73	Chapter 8 - RDBMS Concepts - Surrogate Key	View Questions	10
74	Chapter 8 - RDBMS Concepts - Business key, Natural key and Candidate Key	View Questions	10
75	Chapter 8 - RDBMS Concepts - Cardinality	View Questions	10
76	Chapter 8 - RDBMS Concepts - Index Types	View Questions	10
77	Chapter 8 - RDBMS Concepts - ERD (Data Model)	View Questions	10
78	Chapter 8 - RDBMS Concepts - Third Normal Form	View Questions	10
79	Chapter 9 - Advanced Topics - Database View	View Questions	10
80	Chapter 9 - Advanced Topics - DB Function	View Questions	10
81	Chapter 9 - Advanced Topics - MySQL Stored Procedure	View Questions	20
82	Chapter 9 - Advanced Topics - DB Trigger	View Questions	10