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,

1099

What advantages does DBMS have over traditional file systems?

ABB, Infogain,

1081

Explain inner and outer joins with examples.

Agilent,

1227

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

Agilent,

1084

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

Agilent, Amdocs,

1744

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

Akamai Technologies,

1106

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

Akamai Technologies,

1127

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

Akamai Technologies,

1536

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,

1145

State any two functions of oracle?

Aricent,

1101

Benefits of Stored Procedures?

Wipro,

1047

What are the advantages to use stored procedures?

Ernst Young,

1184

What is SQL Server?

Atos Origin,

1276

How can we improve performance by using SQL Server profiler?

QuestPond,

1108

Un-Answered Questions { Databases }

What is sql catalog?

1071

How to set the current database in ms sql server?

1148

What is field in database give an example?

1033

How to use "startup" command to start default instance?

1103

How do you optimize a stored procedure in sql?

1019

What is mongodb tutorial?

How to create a login account in ms sql server to access the database engine using "create login" statements?

1202

How to truncate the log in sql server 2012? : sql server database administration

1356

what are the types of join and explain each? : Sql dba

1089

How to compare dates in oracle sql?

1162

How can delete duplicate records in cte in sql server?

1021

Can we insert data into materialized view?

997

What is bitemporal narrowing?

1378

What do you mean by Correlated subquery?

916

What is not equal to in oracle?

1052

For More Un-Answered { Databases } Questions Click Here