Quiz

  • Question 1

4 out of 4 points

A point in time database recovery is good when:
Selected Answer:  

a. You don’t know the precise time that the database was corrupted

Correct Answer:  

a. You don’t know the precise time that the database was corrupted

  • Question 2

4 out of 4 points

This particular error occurs when a page that should have been constant changed. This typically occurs from a memory failure or hardware or OS corruption.
Selected Answer:  

d. Error 832

Correct Answer:  

d. Error 832

  • Question 3

0 out of 4 points

Page restore can be used for transaction log corruptions.
Selected Answer:  

a. True

Correct Answer:  

b. False

  • Question 4

0 out of 4 points

This mode should be used as a absolute last resort to recover from a database corruption.
Selected Answer:  

c. SQL corruption wizard

Correct Answer:  

a. Emergency repair mode

  • Question 5

4 out of 4 points

This recovery model automatically truncates the database’s transaction log when records are no longer required for recovery purposes.
Selected Answer:  

c. Simple

Correct Answer:  

c. Simple

  • Question 6

4 out of 4 points

The NORECOVERY restore option allows further backups to be restored and keeps the database unavailable
Selected Answer:  

a. TRUE

Correct Answer:  

a. TRUE

  • Question 7

4 out of 4 points

The full recovery model does not capture all of the modifications made to a database in its transaction log.
Selected Answer:  

b. FALSE

Correct Answer:  

b. FALSE

  • Question 8

4 out of 4 points

A restore procedure may have to be initiated because:
Selected Answer:  

d. All of the above

Correct Answer:  

d. All of the above

  • Question 9

4 out of 4 points

A full backup is required before you can perform log backups
Selected Answer:  

a. TRUE

Correct Answer:  

a. TRUE

  • Question 10

4 out of 4 points

The RECOVERY function performs recovery on the database, rolling back all uncommitted transactions an makes the database available:
Selected Answer:  

a. TRUE

Correct Answer:  

a. TRUE

 

"Get Help With Your Essay
. If you need assistance with writing your essay, our professional essay writing service is here to help!

Order Now