Explain the various types of normalization.

0 Answers  

---

What is the role of driver manager?

0 Answers  

---

What does new grouping sets enables you to do?

0 Answers   ADITI,

---

Explain artificial key?

0 Answers  

---

How do you pass parameter in stored procedure?

0 Answers   CGI,

---

utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN

2 Answers   Accenture,

---

What is the Difference Primary key and Unique Key

0 Answers   HCL,

---

How heap is implemented in database?

0 Answers   Amazon,

---

What is database server and how it works?

0 Answers  

---

What is the main difference b/w Teradata and Oracle?

1 Answers   TCS,

---

How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

0 Answers  

---

What will happen non-clustered index will be created on clustered index?

0 Answers   Abacus,

---