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,

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,

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 does myisamchk do? : Sql dba

1018

Tell me something about security and sql azure?

114

What is relationship? How many types of relationship are there?

1183

What does mysqli stand for?

933

What is syntax of for loop in r?

What is the difference between join and natural join?

927

How to use group functions in the select clause in ms sql server?

1052

Does aws support postgresql?

906

What methods do you follow to protect from sql injection attack?

1029

What is DCL?

1052

Can we insert delete data in view?

950

Do you have any idea about the tcl commands?

962

Explain the use of analyse option in exp command.

1128

What is a derived table?

928

What is the difference between conversions and interfaces? : oracle accounts receivable

1231

For More Un-Answered { Databases } Questions Click Here