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

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  

---

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

0 Answers  

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

---

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

---

What is transparent data encryption? : sql server DBA

0 Answers  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

how can you enable flashback feature?

0 Answers   Oracle,

---

Why would you call update statistics? : sql server DBA

0 Answers  

---