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

Amazon,

1167

What are the concurrency problems a database faces?

Amazon,

1088

What does currency type mean in database?

Amazon,

1251

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

C DAC, CDAC,

1102

Explain normalization in one line?

C DAC, CDAC,

1158

Give the syntax of exception handling used in DBMS?

C DAC, CDAC,

1240

What are different types of blocks used in stored procedure?

C DAC, CDAC,

1180

What are different types of clusters present?

C DAC, CDAC,

1117

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

C DAC, CDAC,

1142

Differentiate between unique key and foreign key?

CGI,

1071

How do you pass parameter in stored procedure?

CGI,

1251

What are indexes in oracle?

CGI,

1134

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

CGI,

1155

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

CGI,

1099

Write a query to retrieve for many to many relationships?

CGI,

1060

Un-Answered Questions { Databases }

What is system r? How many of its two major subsystems?

1070

How can you change the name of any existing table by using the sql statement?

1048

how to overcome kernel isssues

1687

What is instant client oracle?

1074

We need to perform what steps in the following order to work with a cursor?

1278

Difference between primary key and clustered index?

1066

what are all the different normalizations? : Sql dba

1124

Compare sql & pl/sql

1212

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1729

Explain the difference between mysql and mysql interfaces in php?

1165

what is the procedure to configure the application of mysql?

1103

What is an oracle database?

1112

How to define default values for formal parameters?

1096

How is sql server used?

1015

How do I install microsoft sql?

1116

For More Un-Answered { Databases } Questions Click Here