Question 1: Composite Index
What does a composite index refer to?
Question 2: RDBMS Data Types - Date Storage
Which data type is used to store calendar dates in RDBMS?
Question 3: Advantages of Views
What is an advantage of using a view?
Question 4: ACID - Durability Concept
Which property ensures that once a transaction is committed, its changes remain permanent, even in case of system failure?
Question 5: RDBMS - Advantages of Functions
Why are functions useful in RDBMS?
Question 6: RDBMS - Primary Key Concept
What is the role of a primary key in RDBMS?
Question 7: Database Models - Relational Model Example
Which of the following is a popular relational database system?
Question 8: Uniqueness in Rows - RDBMS
What ensures that each row in a table is unique?
Question 9: CHECK Constraint - Validation in RDBMS
Which constraint can be used to validate values before inserting into a column?
Question 10: Normalization - 1NF Example
Which table violates 1NF?
Question 11: Full-Text Index
Which index type is best for searching large text fields?
Question 12: RDBMS Data Types - Date & Time Combination
Which data type stores both date and time values?
Question 13: View with Joins
Can a view be created from multiple tables using JOINs?
Question 14: Transaction States
Which of the following is a valid state of a transaction in RDBMS?
Question 15: RDBMS - Types of Triggers
Which are common types of triggers in RDBMS?
Question 16: RDBMS - Foreign Key Usage
In RDBMS, a foreign key is used to:
Question 17: Database Models - Hierarchical Model Limitation
A major limitation of the hierarchical database model is:
Question 18: Column Domain in RDBMS
Each column in a table has an associated:
Question 19: DEFAULT Constraint - Automatic Values in RDBMS
What does the DEFAULT constraint do?
Question 20: Normalization - 2NF Example
In table Enrollment(StudentID, CourseID, StudentName), why is it not in 2NF?