How can you fix a poorly performing query?
No Answer is Posted For this Question
Be the First to Post Answer
how to find the first two highest salaries in deptno in emp table
Write the fastest query to find out how many rows exist in a table?
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 database development process?
Can you have a nested transaction?
How long can an error message be in raiseerror function?
What are cursors? Explain different types of cursors?
Explain about network model?
What are the disadvantages of cursors? How can you avoid cursors?
Given an employee table, how would you find out the second highest salary?
Explain the process of the user request and data generating?
Explain about post-relational databases?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)