Question 1: Index - Purpose
What is the primary purpose of using an index in a database?
Question 2: RDBMS Data Types - Numeric Basics
Which of the following is a numeric data type in most RDBMS?
Question 3: Views in RDBMS - Definition
What is a view in a relational database?
Question 4: Transactions in RDBMS - Definition
What is a transaction in the context of RDBMS?
Question 5: RDBMS - Stored Procedure Definition
What is a stored procedure in RDBMS?
Question 6: RDBMS - Basic Definition
What does RDBMS stand for?
Question 7: Database Models - Relational Model
In the relational model, data is organized into:
Question 8: Tables in RDBMS - Structure
In a relational database, a table is also known as:
Question 9: Primary Key - Uniqueness in RDBMS
What is the main purpose of a Primary Key in a relational table?
Question 10: Normalization - 1NF Rule
What is the main requirement of First Normal Form (1NF)?
Question 11: Index - Clustered vs Non-clustered
How does a clustered index differ from a non-clustered index?
Question 12: RDBMS Data Types - Decimal Usage
Which numeric data type is best suited for storing currency values?
Question 13: View Creation - Syntax
Which SQL command is used to create a view?
Question 14: ACID - Atomicity Concept
What does Atomicity ensure in a database transaction?
Question 15: RDBMS - Function Definition
How does a function differ from a stored procedure in RDBMS?
Question 16: RDBMS - Key Feature
Which feature differentiates RDBMS from DBMS?
Question 17: Database Models - Hierarchical Model
What structure is used in the hierarchical database model?
Question 18: Rows in RDBMS - Definition
What is another term used for a row in a relational table?
Question 19: Foreign Key - Relationships in RDBMS
What does a Foreign Key in a table do?
Question 20: Normalization - 2NF Condition
Which of the following must be eliminated to achieve Second Normal Form (2NF)?