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

Oracle (3259)
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,

122

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,

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,

106

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

IBM,

179

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 }

Explain table and field in sql?

1062

What is the concept of optimization?

1060

What is update query?

983

How to enter binary string literals in ms sql server?

1163

What is mysql cursor?

896

What is single tier architecture?

802

Define the select into statement.

1059

What are the ways in which you can retrieve data in the result set of mysql using php?

990

what is query cache in mysql? : Sql dba

1037

Differences between package and loadplans?

593

How do you improve the performance of a SQL Azure Database?

137

How do I rename a procedure?

882

Explain what are the type of synonyms?

1119

How does triggers work in mysql?

970

How to add a new column to an existing table in mysql?

995

For More Un-Answered { Databases } Questions Click Here