Answer / ravi kanth

In 10g i think using flashback command we can get back.

Answer / adhi

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

Answer / ravi

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;

Answer / anil panwar

tell me which command used for delete..

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 Answers  

---

What are commonly used odbc functions in php?

0 Answers  

---

What are the features of Embedded SQL

0 Answers   HCL,

---

What is intellisense?

0 Answers  

---

What is order of B+tree?

0 Answers   HCL,

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

what is index seek and index scan?

2 Answers  

---

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  

---

What to check if a User database is locked?

0 Answers   TCS,

---

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 Answers  

---

What do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

---