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

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

Cap Gemini,

1101

What advantages does DBMS have over traditional file systems?

ABB, Infogain,

1083

Explain inner and outer joins with examples.

Agilent,

1229

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

Agilent,

1087

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

Agilent, Amdocs,

1750

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

Akamai Technologies,

1106

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

Akamai Technologies,

1129

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

Akamai Technologies,

1538

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

1306

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

Aricent,

1146

State any two functions of oracle?

Aricent,

1101

Benefits of Stored Procedures?

Wipro,

1050

What are the advantages to use stored procedures?

Ernst Young,

1189

What is SQL Server?

Atos Origin,

1280

How can we improve performance by using SQL Server profiler?

QuestPond,

1112

Un-Answered Questions { Databases }

Can excel convert to access?

956

What is the difference between join and inner join?

1075

What is the xml datatype?

1127

Is microsoft access like excel?

867

Is mongodb faster than mysql?

1001

What is the command enable-debug?

1008

What integrity rules exist in the dbms?

1084

How to view the error log for any specific instance? : sql server database administration

1098

Does mongodb use sql?

Can you assign multiple query result rows to a variable?

1042

Can we store images in database?

921

What is purpose of normalization?

1005

Define oracle database

1105

What is the latest version of php and mysql?

1277

What are functions in database?

1011

For More Un-Answered { Databases } Questions Click Here