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 1564

What are indexes, and what are the different types?

3 1390

Explain the concept of normalization.

3 1293

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

3 1266

What are triggers, and when would you use them?

3 1431

Compare SQL and PL/SQL.

3 947

Do you know the basic structure of PL/SQL?

3 1765

What Is a Trigger? How Do You Use It?

3 1677

What data types does pl/SQL have?

3 1420

Explain the PL/SQL compilation process.

3 1503

Tell me what a package consists of.

3 1355

What are the benefits of using PL/SQL packages?

3 1554

Do you understand the meaning of exception handling?

3 1186

Give me some examples of predefined exceptions.

3 2106

How to resolve the ORA-39133 error in Oracle?

1113

Un-Answered Questions { Databases }

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

972

What is a matrix in ssrs?

153

What is n tier architecture in dbms?

921

Explain about the command-line tool SQLCMD?

1086

What do you mean by query evaluation engine?

972

What is the most common type of join?

987

How to create a simple table to test triggers in ms sql server?

975

What is advantage data architect?

923

What is varchar example?

1029

Is postgresql free for commercial use?

809

What is the oracle implicit cursor?

1062

Do you know hot add cpu in sql server 2008?

952

Define candidate key, alternate key, and composite key.

922

What is database clustering in mysql?

1036

Why MySQL is used?

1027

For More Un-Answered { Databases } Questions Click Here