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 is openedge rdbms?

1008

Is there an example how to configure udfaccess setting in firebird.conf?

1005

Is declare cursor executable?

1060

How to extract metadata for the entire database?

1146

What is progress apama?

1130

Is there an example how to configure externalfileaccess setting in firebird.conf?

1001

Who is communication horizons?

981

When should you consider denormalization?

1030

What are the lock types?

1022

Describe reporting lifecycle?

1037

Why c++ used in clipper?

957

What is the best way to determine whether firebird server is running?

1122

What is cliques? What is vdisk and how it will communicate with physical data storage at the time of data retrieval through amp?

909

How to migrate paradox, dbase or foxpro database to firebird?

1105

Is this statement true or false? All databases must be in third normal form?

1046

Un-Answered Questions { Databases }

Is mongodb relational database?

How do you change columns in postgresql?

1007

What are the different SQL Server Versions you have worked on?

1061

What is recordset type in access?

806

Why MySQL is used?

1078

Can you tell me some of the common replication dmv's and their use? : sql server replication

978

Can a formula column be obtained through a select statement ?

2381

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

652

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

617

What is nolock hint in sql server 2008

1184

How would you begin to troubleshoot an ORA-3113 error?

2126

what's the information that can be stored inside a bit column? : Sql server database administration

1091

What is a parameter file in oracle?

1191

What are types of exception?

963

How to provide login information for a new odbc dsn?

1100

For More Un-Answered { Databases } Questions Click Here