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

Oracle (3253)
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 1708

What are indexes, and what are the different types?

3 1528

Explain the concept of normalization.

3 1441

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

3 1390

What are triggers, and when would you use them?

3 1547

Compare SQL and PL/SQL.

3 1069

Do you know the basic structure of PL/SQL?

3 1927

What Is a Trigger? How Do You Use It?

3 1838

What data types does pl/SQL have?

3 1562

Explain the PL/SQL compilation process.

3 1670

Tell me what a package consists of.

3 1457

What are the benefits of using PL/SQL packages?

3 1686

Do you understand the meaning of exception handling?

3 1321

Give me some examples of predefined exceptions.

3 2395

How to resolve the ORA-39133 error in Oracle?

1183

Un-Answered Questions { Databases }

What is the benefit of using access over excel?

828

What are the types of optimization?

1008

Can we insert data in view oracle?

1112

What is accounting access?

875

What is save point in mysql?

1003

interview questions with answer for cts

2635

How to enter comments in transact-sql statements?

987

How do queries work in a database?

1061

How many rows we can insert in a mysql table?

1001

Why would you call update statistics? : sql server DBA

1039

How to recreate the index on a firebird table?

959

Is postgres a sql database?

960

What does mongodb mean?

What is the function of Redo Log in Oracle?

1268

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2233

For More Un-Answered { Databases } Questions Click Here