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 are different types of joins used in?

Amazon,

1110

What are the concurrency problems a database faces?

Amazon,

1039

What does currency type mean in database?

Amazon,

1197

After normalization, what are the conditions which have to keep in mind to de-normalize it?

C DAC, CDAC,

1050

Explain normalization in one line?

C DAC, CDAC,

1095

Give the syntax of exception handling used in DBMS?

C DAC, CDAC,

1199

What are different types of blocks used in stored procedure?

C DAC, CDAC,

1131

What are different types of clusters present?

C DAC, CDAC,

1079

What is the difference between a stored procedure and a query?

C DAC, CDAC,

1091

Differentiate between unique key and foreign key?

CGI,

1011

How do you pass parameter in stored procedure?

CGI,

1208

What are indexes in oracle?

CGI,

1090

What is the relationship that exists inside in E-R diagram?

CGI,

1095

Write a query to get maximum and second maximum in oracle?

CGI,

1048

Write a query to retrieve for many to many relationships?

CGI,

1005

Un-Answered Questions { Databases }

What is a database management system and give examples?

960

Name the different types of indexes in sql and define them.

1151

How do I export mysql query results to excel?

971

What are the acid properties?

1005

What are the three levels of database architecture?

747

Is mongodb a relational database? Explain

What do you understand by correlated subqueries in dbms?

959

Explain what are the restrictions while creating batches in sql server?

1068

Does facebook use oracle?

1031

Whis is not false in primary key?

1455

How can we generate report output in excel format?

997

What is procedure in dbms?

890

What is a system tablespace and when it is created?

972

Explain what are the advantages of views?

1069

How do I create a simple access database?

888

For More Un-Answered { Databases } Questions Click Here