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 1420

What are indexes, and what are the different types?

3 1253

Explain the concept of normalization.

3 1152

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

3 1117

What are triggers, and when would you use them?

3 1332

Compare SQL and PL/SQL.

3 803

Do you know the basic structure of PL/SQL?

3 1611

What Is a Trigger? How Do You Use It?

3 1477

What data types does pl/SQL have?

3 1300

Explain the PL/SQL compilation process.

3 1320

Tell me what a package consists of.

3 1246

What are the benefits of using PL/SQL packages?

3 1443

Do you understand the meaning of exception handling?

3 1077

Give me some examples of predefined exceptions.

3 1982

How to resolve the ORA-39133 error in Oracle?

1045

Un-Answered Questions { Databases }

Is microsoft access still relevant 2018?

699

What does select 1 mean?

890

What is primary key sql?

962

Can we convert a date to char in oracle and if so, what would be the syntax?

966

Where sql server user names and passwords are stored in sql server? : sql server database administration

1002

What is a periodical index?

876

Explain how many normalization forms?

979

What is a key in dbms?

831

Explain nested trigger in sql?

1016

What is difference between primary and secondary key?

985

Display the employees whose salary is less than average salary.

1018

What are secondary keys?

932

How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

887

What is proper subset of candidate key?

951

what is the difference between $message and $$message? : Sql dba

952

For More Un-Answered { Databases } Questions Click Here