Explain about post-relational databases?
Explain about normal forms?
What are the disadvantages of cursors? How can you avoid cursors?
Where is dbms used?
What is a self join? Explain it with an example?
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?
how to find the first two highest salaries in deptno in emp table
How can you log an error to the server event log from a stored procedure?
In which table collections errors are stored.
Explain about a primary key?
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?
What is the system function to get the current user's user id?
How can you fix a poorly performing query?