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

Enlist some predefined exceptions?

1059

What do you mean by query optimization?

1002

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1156

What do you mean by stored procedures? How do we use it?

994

Difference between truncate, delete and drop commands?

1082

How do you add a column to a table?

1055

What is a table?

1014

What is the syntax to add a record to a table?

1090

What is the mutating table and constraining table?

1026

How to select random rows from a table?

1075

What are properties of the transaction?

998

Why is %isopen always false for an implicit cursor?

1106

What is normalization? How many normalization forms are there?

1085

When do we use triggers?

1078

What are the possible values for the boolean data field?

963

Un-Answered Questions { Databases }

Is it possible to retrieve all tables along with all the data?how?

775

What is the definition of database management system?

1057

Can we insert data if clustered index is disabled?

939

What are the common mysql functions?

944

Explain the steps for this message could not delete from the specified tables?

851

Difference between 10g & 11g in odi?

775

Does mongodb support primary-key, foreign-key relationship?

Can you have more than one key in a database?

937

Which is the best graph database?

956

What is a Database?

1768

Is sqlite faster than mysql?

945

Determine when an index is appropriate?

1076

What is table partitioning and why is it required?

Is google scholar a database?

995

What is the maximum limit on the number of columns in a table?

1086

For More Un-Answered { Databases } Questions Click Here