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) As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
1 1113You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
1 973While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
1 1121When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
1 1057Using the customer, and order table in northwind database, please write a query to produce xml?
1 1130Your table has a large character field there are queries that use this field in their search clause what should you do?
1 946
What is a coalesce function?
How to export data from database and import into another?
What kind of problems occurs if we do not implement proper locking strategy?
Which statement is used in a select query for partial matching?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
List the ways in which dynamic sql can be executed?
What are the types of database explain each of them briefly?
what is the command syntax for inserting a document?
Does group by remove duplicates?
What is current version of mysql?
please send me oracle pl/sql exp resume. and also faqs...
Why we use the openxml clause?
Have you created fact table and dimension tables?
Design database draw er diagram for a certain scenario ?