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

1 Answers   Flextronics, Hexaware, SQL Star,

---

What are the constraints on severity level in raiseerror?

0 Answers  

---

Explain the family trees and connection by clause.

1 Answers  

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

0 Answers  

---

Explain the process of the user request and data generating?

0 Answers  

---

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

0 Answers  

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

0 Answers  

---

What is the maximum length of an extended property?

0 Answers  

---

how to find the first two highest salaries in deptno in emp table

2 Answers  

---

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

Explain the role of indexing in databases?

0 Answers  

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

0 Answers  

---