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) 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?
1052You 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?
921While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
1064When 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?
991Using the customer, and order table in northwind database, please write a query to produce xml?
1089Your table has a large character field there are queries that use this field in their search clause what should you do?
891
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What do you understand by check constraint in sql server?
What does ss stand for sexually?
What is meant by truncate in sql?
Why do we use sql constraints?
Why mongodb is faster?
issues involved in modeling and building data werahouses
What is the difference between a "where" clause and a "having" clause?
What do you understand by a database object? Can you list a few of them?
Is microsoft access being discontinued?
What is triggers?
What is the difference between truncate and delete? How would a full table scan behave after?
What is the role of tables in database?
How do you delete duplicates in sql query using rowid?
How to synchronize 2 schema's objects?