What happens on checkpoint? : sql server DBA

Question Posted / javed siddique

No Answer is Posted For this Question
Be the First to Post Answer

More DB Administration Interview Questions

What are the steps you will take, if you are tasked with securing an SQL Server?

What authentication modes does sql server support? : sql server DBA

How will u copy the objects of one schema to another schema in datapump & export/import?

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

what are the benefits of flashback feature?

How can you gather statistics on a table?

Name a tablespace automatically created when you create a database.

what is the differnce between process and thread ?

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

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?

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

For more DB Administration Interview Questions Click Here