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

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

What view would you use to look at the size of a data file?

3 Answers  

---

What is dcl? : sql server DBA

0 Answers  

---

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

0 Answers  

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

---

---

Explain materialized views and how they are used.

0 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

Why would you call update statistics? : sql server DBA

0 Answers  

---

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

---

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

---

How can you gather statistics on a table?

3 Answers  

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---