How you can make a parameterized view?

0 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  

---

In which database can extended stored procedures be added?

0 Answers  

---

What is dbms and its application?

0 Answers  

---

Explain about the database management systems.

0 Answers  

---

What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?

5 Answers   IBM,

---

Explain about the hierarchical model of the database?

0 Answers  

---

What are the 18 schemas?

0 Answers  

---

agregator gives one to many records or many to one record

1 Answers   IBM,

---

What is a join and explain different types of joins?

2 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

0 Answers  

---

Explain about network model?

0 Answers  

---