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 to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

---

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 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  

---

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

---

what r the types of backup?

5 Answers   CSC,

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

---

what is asm?

0 Answers   Oracle,

---

How do you add a data file to a tablespace?

3 Answers  

---

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

1 Answers  

---