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

How to open the database in exclusive mode?

1037

What are the basic components of notification services?

1081

Explain what are called fat clients and fat servers?

1068

How to monitor firebird server activity?

969

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

901

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

947

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

961

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

883

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

901

Define identity and uniqueidentifier property of column?

1068

What is a data source (ds)?

932

Explain the advantages and disadvantages of a hierarchical database?

1064

How to deactivate triggers?

923

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

918

What is a hierarchical database?

1009

Un-Answered Questions { Databases }

What is the difference between join and natural join?

927

What are different types of queries in sql?

1121

What is a dba certification?

594

how can you attach more than 20 ldf files in sql server

2003

State the difference between a primary key and foreign key?

935

Explain how would you store your query in an SSRS report or a Database server?

128

What is report snapshot in ssrs?

268

How do you backup a database in mysql?

1069

How can we implement rollback or commit statement in a trigger?

1039

what are knowledge modules?

641

Where does mongodb store data linux?

Is it possible to link two groups inside a cross products after the cross products group has been created?

1002

What is dknf in normalization form?

1052

How do I select a database in mysql workbench?

1014

In which tcp/ip port does sql server run? Can it be changed?

991

For More Un-Answered { Databases } Questions Click Here