RDBMS Test 4

In which scenario is a bitmap index most effective?

Which special data type is used to store large binary objects such as images or videos?

How do views improve database security?

What is the purpose of COMMIT and ROLLBACK in transactions?

A trigger is created to log changes whenever a row is deleted from a table. This type of trigger is an example of:

Which language is mainly used to interact with RDBMS?

Compared to the relational model, the network model:

If a table Students has columns (ID, Name, Age), then Name represents:

What is a composite primary key?

Which of the following shows a transitive dependency?

What is a disadvantage of too many indexes?

Which data type is suitable for storing very large text values such as articles or logs?

Which command is used to delete a view?

Which isolation level allows maximum concurrency but may cause dirty reads?

Which statement is true?

Which type of integrity ensures that a foreign key must match a primary key in another table?

Which of these is an advantage of object-oriented databases?

How do tables in a relational database establish relationships?

What happens if a foreign key value does not match a primary key in the referenced table?

Which situation requires BCNF instead of 3NF?