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

Define Transaction ?

5 10614

When does a Transaction end ?

2 7522

What does COMMIT do ?

4 10558

What is SAVE POINT ?

5 9604

What is Read-Only Transaction ?

3 6582

What is the function of Optimizer ?

1 4472

What are the different approaches used by Optimizer in choosing an execution plan ?

2 5206

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

2 4705

What are the values that can be specified for OPTIMIZER MODE Parameter ?

1 3960

Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?

1 3970

What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?

1 4126

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?

1 4353

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 4398

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

2 4513

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 4428

Un-Answered Questions { Databases }

What is index fragmentation in ms sql server?

1092

What is confine mode and flex mode?

How are queries run in ms access? List different ways.

768

What are local and global Indexes and where they are useful.

1447

What is default password for postgres?

874

What are number line correlation administrators will use while working with a subquery?

1179

various types of hints and their usage

2699

What is full text indexing in mysql?

958

what are the differences between network and hierarchical database model?

1126

Why myisam is faster than innodb?

938

WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

2252

Where MyISAM table will be stored and also give their formats of storage?

1067

What is raid controller technology?

1010

what is schema? : Sql dba

1051

What is left join in sql?

1054

For More Un-Answered { Databases } Questions Click Here