Explain about normal forms?

0 Answers  

---

What are the disadvantages of cursors? How can you avoid cursors?

2 Answers  

---

Where is dbms used?

0 Answers  

---

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

16 Answers   TCS,

---

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  

---

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

2 Answers  

---

How can you log an error to the server event log from a stored procedure?

0 Answers  

---

In which table collections errors are stored.

0 Answers  

---

Explain about a primary key?

0 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  

---

What is the system function to get the current user's user id?

4 Answers  

---

How can you fix a poorly performing query?

0 Answers  

---