How can you fix a poorly performing query?
No Answer is Posted For this Question
Be the First to Post Answer
What is DB Development software?
Can you have a nested transaction?
Explain the general syntax for a SELECT statements covering all the options.
What are triggers? How many triggers you can have on a table?
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?
Define candidate key, alternate key, composite key?
30 Answers IAS, IBM,
Can you instantiate a COM object by using T-SQL?
Explain about the database management systems.
What are the disadvantages of cursors? How can you avoid cursors?
How to use timestamp datatypes
fact table and dimension table containg one to many relationship or many to one relastionship
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
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)