Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3258)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3328)
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 618

What are indexes, and what are the different types?

3 519

Explain the concept of normalization.

3 539

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

3 541

What are triggers, and when would you use them?

3 655

Compare SQL and PL/SQL.

3 240

Do you know the basic structure of PL/SQL?

3 638

What Is a Trigger? How Do You Use It?

3 720

What data types does pl/SQL have?

3 686

Explain the PL/SQL compilation process.

3 614

Tell me what a package consists of.

3 672

What are the benefits of using PL/SQL packages?

3 791

Do you understand the meaning of exception handling?

3 543

Give me some examples of predefined exceptions.

3 911

How to resolve the ORA-39133 error in Oracle?

786

Un-Answered Questions { Databases }

What is full join?

699

What is a schema in oracle?

752

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

678

What is order of B+tree?

861

How to check if value already exists in mysql database in php?

616

Explain Access Control Lists.

714

Is postgresql case sensitive?

583

What is a scalar value in sql?

808

Is postgresql faster than mysql?

600

What are the general features of sql server management studio? : sql server management studio

786

How do databases work?

659

What is a deadlock and mention how it can be resolved?

604

List the properties of a transaction.

789

How to define a variable to match a table column data type?

749

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2606

For More Un-Answered { Databases } Questions Click Here