Answer / monal

RELATIONSHIP BETWEEN CUSTOMERS AND ORDERS &
RELATIONSHIP BETWEEN ORDERS AND ORDERDETAILS

Answer / kalyan maddipati

Emp and Dept tables is the good example fro referential integrity as DeptNo in Dept table refers DeptNO of Emp table.

ie. You have a PK(Primary key) on Deptno of Dept table and FK(Foreign key) on Deptno of EMP Table

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

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

3 Answers  

---

Hot backup procedure?

2 Answers  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

how to restore files with rman?

0 Answers  

---

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

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,

---

How many memory layers are in the shared pool?

3 Answers  

---