Answer / Sheelvant

The Flashback feature in Oracle databases provides several benefits, including the ability to undo changes made to a table (Flashback Table), retrieve previous versions of rows (Flashback Version Query), and restore the database to a specific point in time (Flashback Database). These features are crucial for data recovery, error correction, and auditing purposes.

What is the difference between Datapump & export/import?

2 Answers  

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---

what is a crs resource?

1 Answers   Oracle,

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

How can you rebuild an index?

6 Answers  

---

Give two examples of referential integrity constraints.

2 Answers  

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

Hot backup procedure?

2 Answers  

---

Can we take incremental backups in datapump?

1 Answers  

---

How to start SQL Server in minimal configuration mode?

2 Answers  

---

Why does Oracle not permit the use of PCTUSED with indexes?

1 Answers  

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---