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 you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,

---

What type of index should you use on a fact table?

1 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  

---

How would you force a log switch?

4 Answers  

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

---

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  

---