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

Datapump backup steps?

1 Answers  

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

what is incremental checkpoint?

1 Answers   CTS,

---

how can you record information about current session?

0 Answers   Oracle,

---

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

2 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---