Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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)

Databases Interview Questions

Questions Answers Views Company eMail

Is it true, that there is no difference between a rule and a check constraint?

1072

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?

1052

You 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?

921

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1064

Explain a checkpoint?

1055

What is the exact numeric data type in sql?

1015

Which table keeps the locking information?

949

How many types of cursor type are there?

1113

How can you list all the columns in a database?

948

What is the difference between deallocate cursor and close cursor?

1275

When 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?

991

Using the customer, and order table in northwind database, please write a query to produce xml?

1089

What is mapping schema?

1044

What is the downside of using udf?

1125

Your table has a large character field there are queries that use this field in their search clause what should you do?

891

Un-Answered Questions { Databases }

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?

2523

What do you understand by check constraint in sql server?

962

What does ss stand for sexually?

1104

What is meant by truncate in sql?

1084

Why do we use sql constraints?

1185

Why mongodb is faster?

issues involved in modeling and building data werahouses

1977

What is the difference between a "where" clause and a "having" clause?

1179

What do you understand by a database object? Can you list a few of them?

1035

Is microsoft access being discontinued?

937

What is triggers?

975

What is the difference between truncate and delete? How would a full table scan behave after?

569

What is the role of tables in database?

979

How do you delete duplicates in sql query using rowid?

960

How to synchronize 2 schema's objects?

2197

For More Un-Answered { Databases } Questions Click Here