What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
No Answer is Posted For this Question
Be the First to Post Answer
What are the main phases of database development?
Write the difference between case version and decode version.
Explain about a primary key?
What is a database development?
How to generate OIDS
how will I find the duplicate rows count from employees tablein oracle.
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 difference between primary key and unique key ?
Where is dbms used?
Explain about xml databases?
Explain the rollup operator?
agregator gives one to many records or many to one record
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)