Answer / Aditya Pratap Singh

In a DBMS, data is stored in tables. Each table consists of rows (records) and columns (fields).

what is difference between primary key and unique key ?

2 Answers  

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

1 Answers  

---

What are the 18 schemas?

1 Answers  

---

Explain about network model?

1 Answers  

---

Can an extended stored procedure be called from inside a user-defined function?

1 Answers  

---

What is a self join? Explain it with an example?

16 Answers   TCS,

---

What are the types of database model?

1 Answers  

---

Explain the family trees and connection by clause.

1 Answers  

---

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me

1 Answers   IBM,

---

What is normalization? Explain different levels of normalization?

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

---

Can you instantiate a COM object by using T-SQL?

1 Answers  

---

Which four data types cannot be used as a return type from a user-defined function?

1 Answers  

---