1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

What is the importance of a recovery model? : sql server DBA

Question Posted / javed siddique


What is the importance of a recovery model? : sql server DBA..

Answer / Deepshikha Raghav

The recovery model in SQL Server determines how transaction logs are handled and how database recovery will occur. Choosing the right recovery model (Full, Bulk-Logged, or Simple) can affect the performance, backup strategies, and data consistency of your databases.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

If CPU is very slow What can u do to speed up?

1 Answers  

What is the default fill factor value? : sql server DBA

1 Answers  

What is RAID and what are different types of RAID configurations?

1 Answers  

What is dbcc? : sql server DBA

1 Answers  

How to determine the service pack currently installed on SQL Server?

1 Answers  

What is checkpoint?

3 Answers   Accenture,

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

How do you add a data file to a tablespace?

3 Answers  

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

1 Answers  

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1 Answers  

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

how can you create a user-defined lock?

1 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories