Data Recovery Interview Questions

Data Recovery interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. SQL Server backup and restore operations occur within the context of the _______ model of the database.

A. backup

B. recovery

C. restore

D. None of the mentioned

Correct Answer is : recovery

2. Point out the correct statement :

A. Backup models are designed to control transaction log maintenance

B. Restore models are designed to control transaction log maintenance

C. Recovery models are designed to control transaction log maintenance

D. None of the mentioned

Correct Answer is : Recovery models are designed to control transaction log maintenance

3. How many types of recovery model is provided by SQL Server ?

A. 2

B. 3

C. 4

D. 5

Correct Answer is : 3

4. No log backups is a feature of __________ recovery model.

A. Simple

B. Full

C. Bulk-logged

D. All of the mentioned

Correct Answer is : Simple

5. Point out the wrong statement :

A. Managing databases with simple recovery model is much easier

B. Managing databases with full recovery model is much easier

C. Managing databases with bulk-logged recovery model is much easier

D. All of the mentioned

Correct Answer is : Managing databases with simple recovery model is much easier

Data Recovery interview questions