RDBMS Test 5

What is a covering index?

Which data type is commonly used to store true/false (yes/no) values?

Which statement is true about views compared to tables?

What is the main benefit of enforcing ACID properties in RDBMS transactions?

Why are parameters used in stored procedures?

Which of the following is an example of RDBMS software?

The relational model was proposed by:

Which constraint ensures that a column cannot have NULL values?

Which of the following is true about Primary Key vs Unique?

What is the purpose of denormalization in databases?

Which type of queries benefit most from indexes?

Which numeric type is often used with AUTO INCREMENT for primary keys?

How does a materialized view differ from a normal view?

In a banking application, transferring money between accounts is a transaction. Why must it follow ACID principles?

How do stored procedures, functions, and triggers help in database automation?

Why is normalization used in RDBMS?

Which database model is most suitable for real-time applications requiring navigation through relationships?

What does the schema of a table define?

Why are constraints like Primary Key, Foreign Key, and NOT NULL important?

Which statement is true?