Explian different types of BACKUPs avaialabe in

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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

Types of backups you can create in SQL Sever 7.0+ are Full database backup, differential database backup, transaction log backup, filegroup backup. .....

(Continued on next question...)

Other Job Interview Questions

• Let’s assume you have data that resides on SQL Server 6.5. You have to move it SQL Server 7.0. How are you going to do it?
• Define candidate key, alternate key, composite key.
• What is the system function to get the current user's user id?
• How many bits IP Address consist of?
• What is blocking and how would you troubleshoot it?
• Database design - What is normalization? Explain different levels of normalization?
• Database design - What is denormalization and when would you go for it?
• Explain CREATE DATABASE syntax
• There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
• How many layers of TCP/IP protocol combined of?
• More...