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

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

---

How can you enable a trace for a session?

1 Answers  

---

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

1 Answers  

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

how can you initialize log miner?

0 Answers   Oracle,

---

Why would you call update statistics? : sql server DBA

0 Answers  

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---