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
جاري تحميل الاقتراحات...