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 is the difference between DELETE, TRUNCATE, and DROP?

3 1569

What are indexes, and what are the different types?

3 1397

Explain the concept of normalization.

3 1298

What is a CTE (Common Table Expression), and how is it different from a subquery?

3 1276

What are triggers, and when would you use them?

3 1443

Compare SQL and PL/SQL.

3 955

Do you know the basic structure of PL/SQL?

3 1774

What Is a Trigger? How Do You Use It?

3 1685

What data types does pl/SQL have?

3 1425

Explain the PL/SQL compilation process.

3 1517

Tell me what a package consists of.

3 1359

What are the benefits of using PL/SQL packages?

3 1560

Do you understand the meaning of exception handling?

3 1199

Give me some examples of predefined exceptions.

3 2116

How to resolve the ORA-39133 error in Oracle?

1122

Un-Answered Questions { Databases }

What is sql in dbms?

996

How do I fix a crashed mysql database?

959

How to create a single index for multiple columns?

1037

How do I open a mongodb file on a mac?

Explain the designer?

629

What is db driver?

955

Name few endpoints exposed by ssrs 2012?

355

How to change a password for an existing user via mysqladmin?

983

Why is theta join required?

1146

How do I configure identities in sybase?

861

How to round a numeric value to a specific precision?

1075

Is mysql still relevant?

909

What different steps will a sql server developer take to secure sql server?

998

Is mysql a nosql database?

1138

How to apply filtering criteria at group level with the having clause in ms sql server?

1002

For More Un-Answered { Databases } Questions Click Here