Answer / kittu_chintu2005

Impdp directory=dpump_dir1 dumpfile=xxxxx.dmp remap_schema=user1:user2
Imp file=xxxxxx.dmp \ from user=user1 touser=user2

what are the benefits of flashback feature?

0 Answers   Oracle,

---

Can we take incremental backups in datapump?

1 Answers  

---

Give two examples of referential integrity constraints.

2 Answers  

---

what is logical system in sap basis

0 Answers  

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---