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

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)

Databases Interview Questions

Questions Answers Views Company eMail

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

1 1149

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 1113

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?

1 973

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

1 1121

Explain a checkpoint?

1 1096

What is the exact numeric data type in sql?

1 1072

Which table keeps the locking information?

1 1007

How many types of cursor type are there?

1 1194

How can you list all the columns in a database?

1 989

What is the difference between deallocate cursor and close cursor?

1 1365

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?

1 1057

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

1 1130

What is mapping schema?

1 1088

What is the downside of using udf?

1 1195

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

1 946

Un-Answered Questions { Databases }

What is a coalesce function?

1275

How to export data from database and import into another?

989

What kind of problems occurs if we do not implement proper locking strategy?

1493

Which statement is used in a select query for partial matching?

1239

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

2099

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2346

List the ways in which dynamic sql can be executed?

1079

What are the types of database explain each of them briefly?

1050

what is the command syntax for inserting a document?

Does group by remove duplicates?

1108

What is current version of mysql?

1069

please send me oracle pl/sql exp resume. and also faqs...

2566

Why we use the openxml clause?

1068

Have you created fact table and dimension tables?

703

Design database draw er diagram for a certain scenario ?

4645

For More Un-Answered { Databases } Questions Click Here