What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Explain about the relational database?
How to use timestamp datatypes
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?
Explain the role of indexing in databases?
How to read and create .LDC data files which are used by linguatic dictionary.
How would you design a database for an online site, which would average a million hits a day?
what is Normalization?
What are the main phases of database development?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
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?
Explain about network model?
What are the types of database model?