Question 11

Recently performance in the database has slowed and things take longer to complete. The database administrator has determined the problem is the database tables are stored on disk and the available disk space is broken into a large number of small fragmented disk segments instead of a relatively few number of large contiguous disk segments. Which of the following is the term for this situation?

disk corruption

disk degeneration

disk disintegration

disk fragmentation

Question 12

Which level of isolation forces every transaction to process one after the other?

read uncommited

read committed

serializable

repeatable read

Question 13

Rollback recovery uses which of the following?

after images

both before and after images

neither before nor after images

before images

Question 14

Rollforward recovery uses which of the following?

neither before nor after images

both before and after images

after images

before images

Question 15

Which one of the following is used in a SQL transaction to indicate the transaction has finished and the changes should be applied to the database?

COMMIT

ROLLBACK

SAVE

BEGIN