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

Why do we need to use a database?

981

Why would someone use a database?

935

Can I create table without primary key?

1014

Can a composite key be null?

996

Can a foreign key be a duplicate?

922

Can a foreign key have a different name?

955

Can a key be both primary and foreign?

1011

Can a primary key be a foreign key?

1041

Can a table have no primary key?

1079

Can a varchar be a primary key?

1020

Can primary key be changed?

919

Can there be 2 primary keys in a table?

1012

Can we create foreign key without primary key?

999

Can we enter data in a table in design view?

976

Do foreign keys improve performance?

1033

Un-Answered Questions { Databases }

if u want to delete all these detail block etc what will happen in form

2004

What are the functions used to encrypt and decrypt the data present in mysql?

1120

How can you get sql*loader to commit only at the end of the load file? : aql loader

1033

List out the difference between union and union all in sql server?

1003

What is difference between views and stored procedures?

1002

What is triggers and how it can be used in mysql?

984

explain engines?

925

Difference between Sql server reporting services and Crystal reports?

172

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

613

What is difference between hadoop and mongodb?

What is a record in pl/sql?

1168

Show Practically Sql Server Views are updatable?

1141

How do you declare a constant?

978

Explain what is object cache in neo4j. how many types of they are?

What is microsoft access 2013 runtime?

847

For More Un-Answered { Databases } Questions Click Here