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

How does postgresql compare to oracle/db2/ms sql server/informix?

1094

explain the delete statements in sql

1137

How do you get column names only for a table (sql server)?

1217

How many postgresql users are there, worldwide?

1129

Explain the insert into statements in sql?

1053

Explain the update statement in sql

1044

Does postgresql run on the cloud?

1222

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1056

How to add, remove, modify users using sql?

1089

What is the most important ddl statements in sql are?

1042

How many developers work on postgresql?

1042

Explain the difference between 'between' & 'and' operators in sql

1046

How to find the duplicate rows count from employees table in oracle?

1146

What does clipper stand for?

1084

Explain some of the uses of openedge architect features useful for a developer?

977

Un-Answered Questions { Databases }

We have lost the sa password, what can we do?

930

Is mysqli deprecated?

1016

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

2169

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

2000

What is dml with example?

1155

How do you concatenate in sql?

1086

What do you mean by cql?

What is column?

1033

What are sub reports?

208

Is ms access still used?

863

Explain view?

1088

What is sqlexception in java?

1037

Does mongodb have a gui?

How we can see all indexes defined for a table in mysql?

999

What is the maximum rows in csv?

977

For More Un-Answered { Databases } Questions Click Here