RDBMS iMScIT Div A

Which of the following anomalies can occur when data redundancy is present in a database?

• Insertion Anomaly

• Update Anomaly

• Deletion Anomaly

• All of the above

Which of the following ensures referential integrity in a relational database?

• CHECK constraint

• FOREIGN KEY constraint

• PRIMARY KEY constraint

• UNIQUE constraint

Which of the following relational algebra operations requires the union compatibility of the relations involved?

• SELECT

• PROJECT

• UNION

• JOIN

In SQL, what is the purpose of the WITH CHECK OPTION clause in views?

• To automatically update base tables

• To restrict INSERT and UPDATE operations violating the view's WHERE clause

• To allow triggers on views

• To ignore constraints on base tables

The concept of normalization is aimed at:

• Data redundancy

• Data dependency

• Anomalies

• All of the above

What is the result of a NATURAL JOIN in relational algebra?

• Cartesian product

• Theta join

• Join using common attributes

• Self join

In SQL, which of the following is not a valid isolation level?

• READ COMMITTED

• SERIALIZABLE

• READ PERSISTENT

• REPEATABLE READ

Which of the following indexing techniques is commonly used in B-trees for databases?

• Hash-based indexing

• Flat indexing

• Balanced multi-way tree indexing

• Vector indexing

Which SQL keyword is used to enforce the uniqueness of values in a column but allows NULL values?

• PRIMARY KEY

• UNIQUE

• INDEX

• FOREIGN KEY

Which normal form is achieved when there are no transitive dependencies?

• 1NF

• 2NF

• 3NF

• BCNF