Database Management Quiz

What can you do while a database is being backed up?

• Anything that doesn’t affect the log.

• All normal processing.

• All transactions, expect non-logged operations.

• Queries only.

• Absolutely nothing. All users are blocked during a backup.

In client/server architecture, what is the normal purpose of a server?

• Enforce data integrity

• Format data for displaying to the end user

• Control the graphical user interface

• Handle data storage

• Supply the end user with automatic corrections to misspelled words as they are typed

Which database maintenance tasks can be automated?

• Database backups

• Updating of index statistics

• Transaction log backups

• Index rebuilds

When is a trigger fired?

• a. Before constraint validation

• b. After the transaction completes

• c. Before data modification

• d. After constraint validation but before the transaction commits

Choose the wrong answers. DML trigger runs each time when the data in the base table is changed by any operator:

• INSERT

• DROP

• DELETE

• UPDATE

• ALTER

Which command(-s) provide stored procedure execution?

• sp_dboption

• EXECUTE proc_name

• F5

• proc_name

• EXEC proc_name

What is the state which requires duplication to provide mutual independence of multi-value attributes? (kop zhauapti)

• Concretization

• Multi-value independency

• Denormalization

• Generalization

• Multi-value dependency

A foreign key constraint can be created provided that: (kop zhauapti)

• a. No correct answers

• b. The referenced table already exists

• c. The constraint name is unique within the database

• d. Not enough correct answers

• e. Its referenced column(s) have a primary key or unique constraint

Can a software design tool identify functional dependencies?

• Дурыс True

• Бурыс False

What is the purpose of normalization? (kop zhauapti)

• a. Reduce data inconsistencies

• d. Eliminate redundant data

• b. Increase data inconsistencies

• c. Produce redundant data