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 to open the database in exclusive mode?

1094

What are the basic components of notification services?

1140

Explain what are called fat clients and fat servers?

1157

How to monitor firebird server activity?

1019

Explain armstrong rules? How they are complete and/or sound?

951

Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?

1002

How to tell firebird to only accept conections from xyz host or network?

1005

If I use netlib, will I find many other users to network with?

945

What is an artificial (derived) primary key? When should it be used?

949

Define identity and uniqueidentifier property of column?

1118

What is a data source (ds)?

976

Explain the advantages and disadvantages of a hierarchical database?

1125

How to deactivate triggers?

976

Explain what are tp-lite and tp-heavy monitors?

962

What is a hierarchical database?

1059

Un-Answered Questions { Databases }

What is table join?

1172

Explain the role of replication server in sybase.

923

what is the size of informix page?

217

What is resource governor?

1034

What are the new features of sql server 2012 reporting service?

141

How we can create index in mysql?

1024

What are the types of database users?

1050

Is postgresql like oracle?

895

What does select top 1 do in sql?

1142

Explain nested join?

1036

Mention what is new feature in oracle asm 12c?

What is the purpose of the sql select top clause?

1208

I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

2680

Does oracle charge for java?

1115

What is a delimiter in sas?

1129

For More Un-Answered { Databases } Questions Click Here