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,

1049

What advantages does DBMS have over traditional file systems?

ABB, Infogain,

1035

Explain inner and outer joins with examples.

Agilent,

1176

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

Agilent,

1031

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

Agilent, Amdocs,

1677

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

Akamai Technologies,

1047

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

Akamai Technologies,

1078

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

Akamai Technologies,

1466

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

1199

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

Aricent,

1053

State any two functions of oracle?

Aricent,

1045

Benefits of Stored Procedures?

Wipro,

964

What are the advantages to use stored procedures?

Ernst Young,

1109

What is SQL Server?

Atos Origin,

1213

How can we improve performance by using SQL Server profiler?

QuestPond,

1053

Un-Answered Questions { Databases }

What is the difference between locking and multi-versioning?

989

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8156

What are sql server functions?

979

What is microsoft access made up of?

872

What do you understand by data redundancy?

927

How do you create a database in access 2010?

844

What is the main purpose of database?

954

Explain about various levels of constraint.

949

Tell me can we use custom code in ssrs?

1002

How many control files should you have?

591

Why does profiler use in mongodb?

Is hive a database?

942

Is it possible to create trigger on views?

981

How do I connect to postgresql database using pgadmin?

840

Difference between CHAR and VARCHAR?

1099

For More Un-Answered { Databases } Questions Click Here