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

explain pdq priority?

IBM,

explain about light scans in informix?

IBM,

126

explain checkpoints and why in 9.4 they were better than in previous versions of the engine?

IBM,

explain the concept of fragment elimination in informix ?

IBM,

explain the purpose of optimizer directives and how/why you would use them

IBM,

how could you increase the speed of ontape/onbar backups ?

IBM,

106

how would you check that a given index is consistent and has no corruption? If corruption occurred on a database what would your process be?

IBM,

108

how would you convert a secondary server into a primary server ?

IBM,

182

I think I screwed up my onconfig file, and I do not have a backup of it. What should I do?

IBM,

mention the database server operating modes available for informix?

IBM,

somehow informix fails to go online. Is there a way to view what oninit is doing?

IBM,

what are the database server operating modes available for informix? Explain each.

IBM,

what are the informix isolation levels and can you explain each one ?

IBM,

what are the options/commands used which dbspace a database resides?

IBM,

what are the sql joins available in informix?

IBM,

Un-Answered Questions { Databases }

What are the requirements of simple database?

610

Is postgresql better than sql server?

984

Explain about informix 4gl.

In MS Access the long and short date option does not show 4 digit years. how do I achieve the mm/dd/yyyy format?

916

What are the benefits of database?

991

How do you create a new database in mysql?

975

What is a trigger and what are its types?

1332

How to disable triggers using "disable trigger"?

1119

Can we change the table name in sql?

1006

How to get a list of all tables with "sys.tables" view in ms sql server?

1088

what are the different functions in sorting an array? : Sql dba

1069

Is Mysql query is case sensitive?

1084

List out the oracle forms configuration files?

1132

How optimize sql query with multiple joins in sql server?

958

What is difference between count (*) and count 1?

980

For More Un-Answered { Databases } Questions Click Here