SQL & RDBMS Interview Questions
↓
↓
Series: 1️⃣
Level: Beginner
Topics:
1️⃣ Introduction to RDBMS
2️⃣ Normalisation
3️⃣ Introduction to SQL
4️⃣ Tables and Fields
5️⃣ Constraints
6️⃣ Index
7️⃣ DML Operations
8️⃣ Joins
9️⃣ Set Operations
Level: Beginner
Topics:
1️⃣ Introduction to RDBMS
2️⃣ Normalisation
3️⃣ Introduction to SQL
4️⃣ Tables and Fields
5️⃣ Constraints
6️⃣ Index
7️⃣ DML Operations
8️⃣ Joins
9️⃣ Set Operations
1️⃣ Introduction to RDBMS
✪ What is a Database?
✪ What are different types of Databases?
✪ What is DBMS?
✪ What is difference between Database and DBMS?
✪ What is RDBMS?
✪ Which are popular RDBMS vendors?
✪ What is ACID property in Database?
✪ What is a Database?
✪ What are different types of Databases?
✪ What is DBMS?
✪ What is difference between Database and DBMS?
✪ What is RDBMS?
✪ Which are popular RDBMS vendors?
✪ What is ACID property in Database?
2️⃣ Normalisation
✪ What is Normalisation?
✪ Why is Normalisation necessary?
✪ What are the disadvantages of not performing Normalisation?
✪ What are different Normal Forms (NF)?
✪ What is Denormalisation?
✪ What is Normalisation?
✪ Why is Normalisation necessary?
✪ What are the disadvantages of not performing Normalisation?
✪ What are different Normal Forms (NF)?
✪ What is Denormalisation?
3️⃣ Introduction to SQL
✪ What is SQL?
✪ What is the use of SQL?
✪ Is SQL a programming language?
✪ Which languages are part of SQL? (DDL, DML, DCL, TCL)
✪ What is DDL?
✪ What is DCL?
✪ What is DML?
✪ What is TCL?
✪ What is SQL?
✪ What is the use of SQL?
✪ Is SQL a programming language?
✪ Which languages are part of SQL? (DDL, DML, DCL, TCL)
✪ What is DDL?
✪ What is DCL?
✪ What is DML?
✪ What is TCL?
4️⃣ Tables and Fields
✪ What is a Table?
✪ What is a field in a Table?
✪ Write a SQL command to create a Table.
✪ How to change the name of a Table?
✪ How to truncate a table?
✪ How to drop a table?
✪ What is a Table?
✪ What is a field in a Table?
✪ Write a SQL command to create a Table.
✪ How to change the name of a Table?
✪ How to truncate a table?
✪ How to drop a table?
5️⃣ Constraints
✪ What is a constraint?
✪ What are different levels of constraints?
✪ Give examples of various constraints?
✪ What is a primary key?
✪ What is a unique key?
✪ What is a constraint?
✪ What are different levels of constraints?
✪ Give examples of various constraints?
✪ What is a primary key?
✪ What is a unique key?
✪ Difference between a primary key and a unique key.
✪ What is a foreign key?
✪ What is NULL value?
✪ What is NOT NULL constraint?
✪ Is blank space or Zero (0) same as NULL?
✪ What is a foreign key?
✪ What is NULL value?
✪ What is NOT NULL constraint?
✪ Is blank space or Zero (0) same as NULL?
6️⃣ Index
✪ What is an index?
✪ What are different types of Indexes?
✪ What is the unique index?
✪ What is clustered index?
✪ What is non-clustered index?
✪ What is the difference between clustered and non-clustered index?
✪ What is an index?
✪ What are different types of Indexes?
✪ What is the unique index?
✪ What is clustered index?
✪ What is non-clustered index?
✪ What is the difference between clustered and non-clustered index?
7️⃣ DML Operations
✪ How to insert rows into a table?
✪ How to update data in a table?
✪ How to delete a row in a table?
✪ Difference between DELETE and TRUNCATE?
✪ How to fetch rows of a table?
✪ What is a query condition? How to write it in SQL?
✪ How to insert rows into a table?
✪ How to update data in a table?
✪ How to delete a row in a table?
✪ Difference between DELETE and TRUNCATE?
✪ How to fetch rows of a table?
✪ What is a query condition? How to write it in SQL?
✪ How to sort the fetched records?
✪ What is grouping? How to write in SQL?
✪ How to find how many records being fetched?
✪ How to find maximum and minimum value for a field in fetched records?
✪ How to sum values in a field for all records?
✪ What is grouping? How to write in SQL?
✪ How to find how many records being fetched?
✪ How to find maximum and minimum value for a field in fetched records?
✪ How to sum values in a field for all records?
8️⃣ Joins
✪ What is a join?
✪ What are different types of joins?
✪ What is Inner Join?
✪ What is a Self Join?
✪ What is Left Outer Join?
✪ What is Right Outer Join?
✪ What is Full Outer Join?
✪ What is Cross Join?
✪ What is a join?
✪ What are different types of joins?
✪ What is Inner Join?
✪ What is a Self Join?
✪ What is Left Outer Join?
✪ What is Right Outer Join?
✪ What is Full Outer Join?
✪ What is Cross Join?
9️⃣ Set Operations
✪ What is UNION?
✪ What is UNION ALL?
✪ What is INTERSECTION?
✪ What is MINUS?
✪ What is UNION?
✪ What is UNION ALL?
✪ What is INTERSECTION?
✪ What is MINUS?
The next 🧵 of this series will provide questions from
1️⃣ Data Types
2️⃣ Operators
3️⃣ Functions
4️⃣ Views
5️⃣ Aggregation
1️⃣ Data Types
2️⃣ Operators
3️⃣ Functions
4️⃣ Views
5️⃣ Aggregation
Loading suggestions...