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 1426

What are indexes, and what are the different types?

3 1256

Explain the concept of normalization.

3 1159

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

3 1127

What are triggers, and when would you use them?

3 1335

Compare SQL and PL/SQL.

3 806

Do you know the basic structure of PL/SQL?

3 1618

What Is a Trigger? How Do You Use It?

3 1486

What data types does pl/SQL have?

3 1305

Explain the PL/SQL compilation process.

3 1323

Tell me what a package consists of.

3 1248

What are the benefits of using PL/SQL packages?

3 1450

Do you understand the meaning of exception handling?

3 1077

Give me some examples of predefined exceptions.

3 1989

How to resolve the ORA-39133 error in Oracle?

1048

Un-Answered Questions { Databases }

How can you determine if the sqlnet process is running for sqlnet v1? How about v2?

527

I assigned a primary key to my table in microsoft access, I was expecting my data to be sorted. Is that a right approach?

882

Explain various On-Delete options in a DB table. Which is the default option?

1415

What is definer in mysql?

917

What is the recommended total size of your memory optimized tables?

920

Name the various constraints used in oracle?

980

Why place tempdb and log on low numbered devices?

795

How can delete duplicate records in cte in sql server?

915

How would you best determine why your MVIEW couldnt FAST REFRESH?

1849

What is rollback trigger in a trigger?

970

How to know, what indexes exist in a collection?

explain primary keys and auto increment fields in mysql : sql dba

907

What is mongodb host?

Is mysql and sql are same?

998

What are the encryption mechanisms in sql server?

974

For More Un-Answered { Databases } Questions Click Here