Answer Posted / 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;

What is a scheduled job or what is a scheduled task?

952

---

What is dbcc? Give few examples.

1033

---

How do I save a stored procedure in sql server?

996

---

How to generate create view script on an existing view?

988

---

What do you mean by normalisation?

1041

---

What are subquery and its properties?

1049

---

How to view existing indexes on an given table using sys.indexes?

1091

---

How to create new table with "create table" statements?

1107

---

What are the main differences between #temp tables and @table variables and which one is preferred?

1083

---

Can an entity have two primary keys?

980

---

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1027

---

What is the difference between dbcc indexdefrag and dbcc reindex?

987

---

when would you go for denormalization? : Sql server database administration

870

---

Can we write trigger for view?

1009

---

Why should we go for stored procedures? Why not direct queries?

1096

---