ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
Explian different types of BACKUPs avaialabe in SQL Server? 
Given a particular scenario, how would you go about 
choosing a backup plan? 
 Question Submitted By :: Swapna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Answer
# 1
Types of backups you can create in SQL Sever 7.0+ are Full 
database backup, differential database backup, transaction 
log backup, filegroup backup.
 
Is This Answer Correct ?    7 Yes 0 No
Swapna
 
  Re: Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Answer
# 2
different types of BACKUPS available in sql server are full 
database backup, differential database backup, 
transactional log backup, files and filegroup backup.
for new database we will go for full database backup, and 
if the the database is in full database backup type,then we 
do differential database backup or transactional log backup.
if the database size is too heavy means the database is 
VLDB then we go for files and filegroup database backup.
 
Is This Answer Correct ?    1 Yes 0 No
Raghuram
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output  5
How can your resolve deadlocks? IBM3
select empid empname from employee What is the result for the about query?  4
i want table name basis on column name.  5
What is the difference between Userdefined function and stored procedure? Explain and give the example also  4
what is IDE,DMV in sql server? Value-Labs1
Is trigger fired implicitely?  2
Which virtual table does a trigger use?  3
I have to display ten columns values from diffrent ten tables. how many joins are require? HCL8
What is the difference between IN and EXISTS operators in SQL Server? Intelligroup3
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))????? SAP-Labs2
How can u convert the Date to String? TCS4
What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning TCS2
How do you simulate a deadlock for testing purposes  1
one table has four field id,name,design,salary. i have to find maximum salary .  6
what are the new features of sql server 2005? HP5
Which is best Subquery (or) joins in sql server? explain why  2
what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1; Patni9
what is a cursor and what is its use?  1
there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C vsworx7
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com