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

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

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 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  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

when does an alert gets signaled?

0 Answers   Oracle,

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

how can you create a user-defined lock?

0 Answers   Oracle,

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

How can we see the database version in os level

6 Answers   Oracle,

---