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 are commit, rollback, and savepoint?

996

Explain the difference in execution of triggers and stored procedures?

1022

Define commit?

1008

Define union, minus, union all, intersect ?

1007

How can we avoid duplicating records in a query?

983

How many types of relationship are there?

1031

State some properties of relational databases?

1058

Define a temp table?

1020

What are transaction and its controls?

1040

What are actual parameters and formal parameters?

1104

What are expressions?

1015

What is sql server used for?

1052

How is table type constraint applied to a table?

979

How can we check the sql server version?

1069

What is a unique key constraint?

1028

Un-Answered Questions { Databases }

List out the acid properties and explain?

953

How to drop all foreign keys in database?

1087

How to modify the underlying query of an existing view?

991

How except clause is differs from not in clause?

955

What is the maximum length of an alert name?

1001

What is a pdo connection?

1043

What is rdbms data?

923

What is difference between function and trigger?

1053

How to provide default values to stored procedure parameters?

1068

What is pl sql block structure?

1037

Is it possible to update the views? If yes, how, if not, why?

1030

How to use "while" statements in oracle?

1327

wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

3096

In which table collections errors are stored.

2413

What is executive plan?

915

For More Un-Answered { Databases } Questions Click Here