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 }

What do you know about couchdbkit?

What is row level locking in access?

890

What is blob in mysql?

1017

What is auto increment feature in sql?

1122

Mention the uses of stored procedures.

970

What is the difference between mysql and sql server?

1024

Explain the difference between control flow and data flow?

994

Explain the working of foreign key?

1067

Can you store images in postgres?

781

What is pl sql in dbms?

949

What is a nvl function?

1029

How do I limit the number of oracle database connections generated by weblogic server?

1070

How do I use google cloud in sql?

1085

Which is the best mongodb gui?

What is log shipping?

960

For More Un-Answered { Databases } Questions Click Here