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

What are the different oracle database objects?

1 1186

State all possible different index configurations a table can possibly have?

1 1154

What is the difference between translate and replace?

1 1151

How can we delete duplicate rows in a table?

1 1074

What is a cursor and what are the steps need to be taken?

1 1354

Compare and contrast between sql and sql server and explain its various functions?

1 1046

How different is ms access and oracle?

1 1122

How to display employee records who gets more salary than the average salary in the department?

1 1151

State some uses of redo log files?

1 1093

What is coalesce function?

1 1174

How can we view last record added to a table?

1 1139

What is the maximum number of triggers that can be applied to a single table?

1 1098

What is the usage of merge statement?

1 1240

Explain the difference between a procedure and a function?

1 1282

What is the difference between $oracle_base and $oracle_home?

1 1170

Un-Answered Questions { Databases }

How to export data from database and import into another?

996

What is current version of mysql?

1073

Is microsoft getting rid of access?

885

what is sql server agent? : Sql dba

1181

What are the steps in creating a database?

1009

Disadvantages of the indexes?

1221

How to select all columns of all rows from a table in oracle?

1125

Is there some bulk load or other way to import a lot of data fast?

931

do you know how to configure db2 side of the application? : Sql server database administration

1119

What is the current version of postgresql?

1175

Can one drop a column from a table?

1084

Have you created fact table and dimension tables?

710

what is schema? : Sql dba

1142

Have you written applications to retrieve stored images in a table?

1085

What is your daily office routine?

2343

For More Un-Answered { Databases } Questions Click Here