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

What is the optimization being performed in oracle and SQL Server?

Cap Gemini,

1013

What advantages does DBMS have over traditional file systems?

ABB, Infogain,

1008

Explain inner and outer joins with examples.

Agilent,

1147

Explain various types of locks in a transaction? Which is better and why?

Agilent,

992

write an SQL query to list the employees who joined in the month of January?

Agilent, Amdocs,

1644

Is BCNF better than 2NF & 3NF? Why?

Akamai Technologies,

1015

Write an SQL query to obtain the 2nd highest salary.

Akamai Technologies,

1035

Explain various On-Delete options in a DB table. Which is the default option?

Akamai Technologies,

1419

For each user who needs access, the DBA creates an account in which database?

1148

In oracle there is column command, how will you explain that?

Aricent,

996

State any two functions of oracle?

Aricent,

1000

Benefits of Stored Procedures?

Wipro,

937

What are the advantages to use stored procedures?

Ernst Young,

1052

What is SQL Server?

Atos Origin,

1162

How can we improve performance by using SQL Server profiler?

QuestPond,

1007

Un-Answered Questions { Databases }

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

962

What is database migration in mysql?

971

What is a synonym for manipulation?

948

Explain the update statement in sql

934

What is the advantage of postgresql?

784

How do I start mysql from command line?

973

What is a database in computer?

900

What is a user function?

611

Explain oracle’s system global area (sga).

1101

In mysql, what is the default storage engine?

959

What is the benefit of using access over excel?

762

Explain various data region available in ssrs with their use?

893

How to run sql statements through the web interface?

1008

What is record in pl sql?

1034

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

994

For More Un-Answered { Databases } Questions Click Here