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,

995

What is background process in Oracle?

MCN Solutions,

1068

What is ASM (Automatic Storage Management) in Oracle?

MCN Solutions,

1154

How many types of table in Oracle?

MCN Solutions,

1083

What is Java Pool in Oracle?

MCN Solutions,

1114

How many types of synonyms in Oracle?

MCN Solutions,

1087

What is materialized view in Oracle?

MCN Solutions,

1048

What is Trigger in Oracle?

MCN Solutions,

1104

What is SQL access advisor in Oracle?

MCN Solutions,

1158

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

MCN Solutions,

1083

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

MCN Solutions,

1072

What is partitioned table in Oracle?

MCN Solutions,

1133

What is recovery manager in Oracle?

MCN Solutions,

1013

What is BBED in Oracle?

MCN Solutions,

1113

What is ADDM Advisor in Oracle?

MCN Solutions,

1135

Un-Answered Questions { Databases }

How to dump one database for backup.

908

Is filemaker pro a relational database?

1010

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

558

What is a primary key? Explain

936

what are the new features introduced in sql server 2000? : Sql server database administration

888

What is a transaction and why is it important?

1033

Where is mysql data stored linux?

958

What are the limitations of microsoft access?

836

What are the three basic rules which are to be followed for the relational model of the database?

960

How to insert html code into mysql database using php?

1016

What is a rollup clause?

926

what does the t-sql command ident_incr does? : Transact sql

1030

Define select, insert, create, delete, update, drop keywords

1010

What are ddl triggers and types of ddl trigger?

998

What is the security model used in sql server 2005?

956

For More Un-Answered { Databases } Questions Click Here