УПР 1-30

What is the primary role of a database transaction?

• To backup the database regularly

• To create new tables

• To ensure atomicity, consistency, isolation, and durability (ACID)

• To improve indexing speed

Which indexing type is most commonly used for improving search performance in a relational database?

• Bitmap index

• Reverse index

• B-tree index

• Full-text index

What is the main benefit of using database normalization?

• Increases redundancy for faster queries

• Reduces security vulnerabilities

• Eliminates data redundancy and ensures data integrity

• Allows data replication across multiple servers

Which SQL clause is used to retrieve only distinct values from a column?

• GROUP BY

• FILTER

• ORDER BY

• DISTINCT

What is the primary purpose of a database trigger?

• To prevent deadlocks

• To automatically execute a predefined action when a specified event occurs

• To encrypt sensitive data

• To improve query performance

What is the main advantage of using a nosql database over a relational database?

• It requires structured tables with predefined schemas

• It strictly enforces ACID compliance

• It provides better scalability for large and unstructured data

• It only supports SQL queries

What is a foreign key primarily used for in a relational database?

• To store unique values only

• To enforce referential integrity between tables

• To improve query performance

• To automatically generate primary keys

Which SQL operation is used to add new data into an existing table?

• UPDATE

• SELECT

• DELETE

• INSERT

In a database, what does the term 'denormalization' refer to?

• Converting a relational database into a nosql database

• Removing duplicate records from tables

• Adding redundancy to improve read performance

• Compressing large database files

Which type of database backup includes all the data and logs to allow full recovery?

• Differential backup

• Incremental backup

• Full backup

• Snapshot backup