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   To Refer this Site to Your Friends   Click Here
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 
Accidentally i deleted my table. How can i get that table?
 Question Submitted By :: Siva
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Accidentally i deleted my table. How can i get that table?
Answer
# 1		 
tell me which command used for delete..
 
Is This Answer Correct ?    1 Yes 4 No
Anil Panwar
 
  Re: Accidentally i deleted my table. How can i get that table?
Answer
# 2		 
In 10g i think using flashback command we can get back.
 
Is This Answer Correct ?    4 Yes 2 No
Ravi Kanth
 
 
 
  Re: Accidentally i deleted my table. How can i get that table?
Answer
# 3		 
In this case data only deleted but table structure is there.
so can flashback the the data.
example:-

delete * from emp;  

ans:- insert into emp select * from emp as of timestamp
sysdate -3/1440;
 
Is This Answer Correct ?    0 Yes 1 No
Ravi
 
  Re: Accidentally i deleted my table. How can i get that table?
Answer
# 4		 
IN MS SQL SERVER 2005.

1.Take Tail Log backup 
2.Restore Full backup
3.Restore Diff (If u have)or Log backup in sequence order
4.Restore Tail Log backup
 
Is This Answer Correct ?    1 Yes 0 No
Adhi
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Explain different isolation levels?  3
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL? HCL3
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?  2
logshipping is Any difference 2000 and 2005?  1
WHAT OPERATOR PERFORMS PATTERN MATCHING? CTS2
How would you Update the rows which are divisible by 10, given a set of numbers in column?  1
Explain Active/Active and Active/Passive cluster configurations  1
Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000? Infosys1
i want table name basis on column name.  5
can we call functions from stored procedure in SQL Server 2005 ? How?  2
What is normalization?  6
what is mean by crystal repoart? ahere we will mainly use that?  1
How can u convert the Date to String? TCS4
What is Report Server,Report Manager and Report Builder in SSRS 2005?  1
from the table display the 2nd highest salary? and also the least 2nd salay?  6
How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me. 247Customer1
can we call stored Procedure in Function in Sql Server 2000 and vice versa. eSoft2
What is the basic functions for master, msdb, tempdb databases? CSC2
What is a Stored Procedure?  7
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..  2
 
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