Given an employee table, how would you find out the second highest salary?

9 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  

---

Who are end users in dbms?

0 Answers  

---

Where is dbms used?

0 Answers  

---

State the acid rules?

0 Answers  

---

---

How to use timestamp datatypes

0 Answers  

---

Write short notes on XSU and JAVA

1 Answers  

---

What are the 18 schemas?

0 Answers  

---

Write the fastest query to find out how many rows exist in a table?

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,

---

What is data modeling with example?

0 Answers  

---

Explain about relational database management systems?

0 Answers  

---