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,

1196

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,

1130

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,

1090

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,

1092

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

CGI,

1046

Write a query to retrieve for many to many relationships?

CGI,

1003

Un-Answered Questions { Databases }

What is auto increment in sql?

1121

How do I create a mysql database?

924

Can i create more than one Master Repository in ODI?

597

When I delete any data from a table, does the sql server reduce the size of that table?

1017

What are views in mysql?

928

What are schema-level triggers?

1101

Is ms access still used?

820

What is the maximum line size that dbms_output can handle?

1160

How to write html code in pl sql?

1114

What are the limitations of check constraint?

1033

What are the 3 types of behavioral triggers?

1252

How to connect sybase database from python?

1042

Is number a datatype in mysql?

944

Explain the concepts of a primary key and foreign key.

883

What is acid in mysql?

858

For More Un-Answered { Databases } Questions Click Here