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 1395

What are indexes, and what are the different types?

3 1232

Explain the concept of normalization.

3 1127

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

3 1087

What are triggers, and when would you use them?

3 1308

Compare SQL and PL/SQL.

3 785

Do you know the basic structure of PL/SQL?

3 1584

What Is a Trigger? How Do You Use It?

3 1455

What data types does pl/SQL have?

3 1275

Explain the PL/SQL compilation process.

3 1285

Tell me what a package consists of.

3 1229

What are the benefits of using PL/SQL packages?

3 1426

Do you understand the meaning of exception handling?

3 1056

Give me some examples of predefined exceptions.

3 1945

How to resolve the ORA-39133 error in Oracle?

1031

Un-Answered Questions { Databases }

What does select count (*) mean in sql?

961

Can we use ddl commands in pl sql?

1068

What is a trace frag?

1035

What is bulk load in oracle?

1004

What is an index in a database?

922

Can you have more than one trigger on a table?

939

Is mongodb better than other sql databases? If yes then how?

can a table be moved to different filegroup? : Sql server administration

909

What is the use of RDBMS?

956

What are the different pseudo commands? Explain in general?

1019

What are record groups ? Explain the types of record group.

How to use column default values in insert statements in ms sql server?

970

What is bulk collect in oracle?

954

What is db driver?

873

Explain the etl (extraction, transformation, and loading)?

936

For More Un-Answered { Databases } Questions Click Here