Answer / chandonline

Basic difference between primary key and unique is that primary key is used to define a table in other tables for preventing data from anomalies,and unique key is used in a table to apply unifications among different values or columns of a tables and only in that table obviously.Their is no usage of unique key outward a table but primary key is often used to make relations between other tables.

Answer / ashish tyagi

The basic difference between primary key and unique key is that unique key allows null value but primary key did not allow null value.

how will I find the duplicate rows count from employees tablein oracle.

2 Answers  

---

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

0 Answers   IBM,

---

Which data type cannot be used as a parameter in a udf?

0 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,

---

How can you fix a poorly performing query?

0 Answers  

---

fact table and dimension table containg one to many relationship or many to one relastionship

0 Answers  

---

What is normalization? Explain different levels of normalization?

8 Answers   CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

---

Who are end users in dbms?

0 Answers  

---

what is the use of foreginkey

2 Answers  

---

explain detail about ftp in datastage?

0 Answers   IBM,

---

Explain the role of indexing in databases?

0 Answers  

---

Write short notes on manual refreshes.

0 Answers  

---