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,

1071

What are the concurrency problems a database faces?

Amazon,

1005

What does currency type mean in database?

Amazon,

1145

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

C DAC, CDAC,

1016

Explain normalization in one line?

C DAC, CDAC,

1055

Give the syntax of exception handling used in DBMS?

C DAC, CDAC,

1162

What are different types of blocks used in stored procedure?

C DAC, CDAC,

1083

What are different types of clusters present?

C DAC, CDAC,

1043

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

C DAC, CDAC,

1054

Differentiate between unique key and foreign key?

CGI,

973

How do you pass parameter in stored procedure?

CGI,

1165

What are indexes in oracle?

CGI,

1061

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

CGI,

1057

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

CGI,

1010

Write a query to retrieve for many to many relationships?

CGI,

954

Un-Answered Questions { Databases }

What are the uses of linked server and explain it in detail?

1026

Explain about the analyze command in oracle?

1014

How do I debug a stored procedure?

1059

What are types of joins?

922

What is the command for quitting from sybase?

885

What is a staging area? Do we need it?

Explain the different normalization forms?

1032

What is temp db database? : sql server architect

828

What suggestions do you have to reduce the network traffic?

916

What is normalization? Explain different forms of normalization?

1086

How to get data from mongodb in flask?

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

951

Mention what are the main components of an oracle rac system?

Do you know what is a with(nolock)?

1015

Describe the difference between data and database administration.

1054

For More Un-Answered { Databases } Questions Click Here