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?

1158

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

996

Difference between truncate, delete and drop commands?

1082

How do you add a column to a table?

1055

What is a table?

1015

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 }

Where is mongodb data stored?

Can we take the full database backup in log shipping?

955

How are the stats updated in postgresql?

858

Is mongodb support replication?

What is the architecture of ms sql reporting service?

985

How you can get a list of all the table constraints in a database? : Sql server administration

1029

How do you know if a relationship is 2nf?

944

What is "scheduled jobs" or "scheduled tasks"?

979

What does null mean?

984

how to create “alternate row colour”?

146

How to create function with parameter in sql server?

1105

What do you mean by cardinality and its types?

934

What is app tier?

862

Explain the term specialization.

855

Who is the owner of mysql database?

1057

For More Un-Answered { Databases } Questions Click Here