Answer / kittu_chintu2005

Export/Import: traditional backup of oracle database, we can't resume the export/import job if we stop the job in middle. We can't attach any job to running job @ exp/imp. We need not to create a file structure @ oracle level

Datapump: It's introduced from 10g. We can resume the datapump job if we stop the job in middle. We can attach a datapump job to running job. We need create file structure @ oracle level and OS level.

Answer / kranthi shiva

Datapump is having better performance than export/import
Datapump--it is having byte
it is having parallelism concept
Incremental backups
we can restart the job, kill and resume the job.
Export/Import-- here we cannot resume the job
it is having bit level or block level
it is not having incremental backup

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

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  

---

Name two files used for network connection to a database.

5 Answers  

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

What is replication? : sql server DBA

0 Answers  

---

What are the recovery models for a database? : sql server DBA

0 Answers  

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---