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
explain detail about ftp in datastage?
Explain the family trees and connection by clause.
State the acid rules?
Who are naive users?
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?
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
1 Answers Flextronics, Hexaware, SQL Star,
Explain about post-relational databases?
What is the system function to get the current user's user id?
Write the difference between case version and decode version.
what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me
What is the physical representation for a many-to-many relationship?
Oracle (3259)
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)