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

What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?

1 3938

What is RULE-based approach to optimization ?

1 5310

What is COST-based approach to optimization ?

5 8852

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 7302

What is a Procedure ?

3 8099

What is difference between Procedures and Functions ?

Hi Caliber IT,

6 10459

What are the differences between Database Trigger and Integrity constraints ?

4 18273

What is Distributed database ?

2 9660

What is Two-Phase Commit ?

3 5885

Describe two phases of Two-phase commit ?

2 4368

What is the mechanism provided by ORACLE for table replication ?

1 3861

What is a SQL * NET?

2 4597

What are the basic elements of Base configuration of an oracle Database ?

1 5780

What are the factors causing the reparsing of SQL statements in SGA?

1 4168

What is the use of Snapshot?

2 5358

Un-Answered Questions { Databases }

How to select some columns from a table in oracle?

1098

What are the common oracle dba tasks?

1153

How can you control the amount of free space in your index pages? : sql server DBA

1317

Explain triggers in sql?

957

What is the default fill factor value?

1087

What is the difference between resultset and resultsetmetadata?

981

What is acid property in dbms?

972

Can we use threading in pl/sql?

1043

What do you mean by sga and how is it different from pga?

Why we should not use triggers?

967

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2068

How to access postgresql database from another machine?

774

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1305

A scenario for amount correction & how to use amount correction functionality in AP invoices

2140

How many concurrent programs you have customized, can you name some of them?

For More Un-Answered { Databases } Questions Click Here