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

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

Atos Origin,

1032

What is background process in Oracle?

MCN Solutions,

1101

What is ASM (Automatic Storage Management) in Oracle?

MCN Solutions,

1196

How many types of table in Oracle?

MCN Solutions,

1121

What is Java Pool in Oracle?

MCN Solutions,

1169

How many types of synonyms in Oracle?

MCN Solutions,

1124

What is materialized view in Oracle?

MCN Solutions,

1074

What is Trigger in Oracle?

MCN Solutions,

1171

What is SQL access advisor in Oracle?

MCN Solutions,

1189

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

MCN Solutions,

1145

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

MCN Solutions,

1109

What is partitioned table in Oracle?

MCN Solutions,

1189

What is recovery manager in Oracle?

MCN Solutions,

1056

What is BBED in Oracle?

MCN Solutions,

1154

What is ADDM Advisor in Oracle?

MCN Solutions,

1173

Un-Answered Questions { Databases }

What are active transformation / passive transformations?

How would you add a section to a table?

1044

What is explicit cursors?

1074

Why do we need different type of parameter?

1057

How to include character strings in sql statements?

985

How to repair a corrupt firebird database?

1067

Define a cross join?

1024

Difference between open_form and call_form in oracle.

1161

differentiate between float and double. : Sql dba

1057

Explain table queries and select queries. What are the main differences between the two?

834

Write a query to display even rows in student table using mysql?

895

List the different types of columns in oracle reports.

1003

Explain the types of record group.

How to get @@error and @@rowcount at the same time?

1035

is there a tool to trace queries, like profiler for sql server?

1141

For More Un-Answered { Databases } Questions Click Here