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 1566

What are indexes, and what are the different types?

3 1393

Explain the concept of normalization.

3 1293

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

3 1267

What are triggers, and when would you use them?

3 1433

Compare SQL and PL/SQL.

3 948

Do you know the basic structure of PL/SQL?

3 1771

What Is a Trigger? How Do You Use It?

3 1681

What data types does pl/SQL have?

3 1422

Explain the PL/SQL compilation process.

3 1510

Tell me what a package consists of.

3 1356

What are the benefits of using PL/SQL packages?

3 1555

Do you understand the meaning of exception handling?

3 1190

Give me some examples of predefined exceptions.

3 2106

How to resolve the ORA-39133 error in Oracle?

1117

Un-Answered Questions { Databases }

What is trigger with example?

1099

How delete all data from all tables in sql?

946

First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

1740

How to recreate an existing index in ms sql server?

1057

How do you create a database in pgadmin 3?

871

Can delete statement be rollbacked?

984

Do you know what is lock escalation?

1011

What are the types of indexes that are present inside a database?

1127

What is partitioned view?

899

Does mysql support sequence?

941

How does sql*loader handles newline characters in a record? : aql loader

1044

When should an artificial (or derived) primary key be used?

597

What is row locking in mysql?

966

Is this statement true or false? All databases must be in third normal form?

992

Explain view in sql server?

1055

For More Un-Answered { Databases } Questions Click Here