RDBMS Test 2

    Question 1: Primary Key and Index

    By default, what type of index is created on a Primary Key?

    Question 2: RDBMS Data Types - String Storage

    Which data type is used to store variable-length character strings?

    Question 3: View Usage - Querying

    How can you retrieve data from a view?

    Question 4: ACID - Consistency Concept

    Which statement best describes Consistency in ACID?

    Question 5: RDBMS - Trigger Definition

    What is a trigger in RDBMS?

    Question 6: RDBMS - Advantages

    Which of the following is not an advantage of RDBMS?

    Question 7: Database Models - Network Model

    Which type of structure is used in the network database model?

    Question 8: Columns in RDBMS - Definition

    In relational databases, a column is also known as:

    Question 9: NOT NULL Constraint - Column Rules in RDBMS

    Which constraint ensures that a column must always have a value?

    Question 10: Normalization - 3NF Requirement

    A table is in Third Normal Form (3NF) if:

    Question 11: Creating a Unique Index

    You need to ensure that the combination of product_id and supplier_id in a product_suppliers table is always unique, while also improving query performance on these columns. Which statement achieves both goals?

    Question 12: RDBMS Data Types - Fixed String

    Which data type is most suitable for storing 2-letter country codes (e.g., IN, US)?

    Question 13: Updatable Views - Condition

    Which type of view allows INSERT, UPDATE, or DELETE operations?

    Question 14: ACID - Isolation Concept

    What does Isolation mean in database transactions?

    Question 15: RDBMS - Advantages of Stored Procedures

    Which of the following is an advantage of using stored procedures?

    Question 16: RDBMS - Components

    Which of these is a component of RDBMS?

    Question 17: Database Models - Object-Oriented Model

    What is the key feature of the object-oriented database model?

    Question 18: Table Structure in RDBMS

    Which of the following best describes a table in RDBMS?

    Question 19: UNIQUE Constraint - Data Integrity in RDBMS

    What is the purpose of the UNIQUE constraint?

    Question 20: Normalization - BCNF Condition

    Boyce-Codd Normal Form (BCNF) is a stricter version of which normal form?