Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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?

1117

What do you mean by query optimization?

1052

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

1231

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

1041

Difference between truncate, delete and drop commands?

1145

How do you add a column to a table?

1107

What is a table?

1064

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

1157

What is the mutating table and constraining table?

1084

How to select random rows from a table?

1137

What are properties of the transaction?

1050

Why is %isopen always false for an implicit cursor?

1154

What is normalization? How many normalization forms are there?

1141

When do we use triggers?

1152

What are the possible values for the boolean data field?

1018

Un-Answered Questions { Databases }

Why mongodb data files so large (in size)?

Does facebook use graph database?

1074

How to list or view all databases from the mysql server.

982

How does notification services work?

979

How is ms access different from ms excel?

965

Does PostgrSQL support Column constraints? If so how is it done?

1325

What is the use of pivot table?

946

What is mongodb sharding?

How do I change global variables in mysql?

951

What are group functions in query statements in ms sql server?

1068

what are the critical issues you have resloved in your company

2020

What are approximate numeric data types in ms sql server?

1105

Does varchar need length?

1050

please send me oracle pl/sql exp resume. and also faqs...

2550

What is the difference between count 1 and count (*) in a sql query?

1060

For More Un-Answered { Databases } Questions Click Here