Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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 10758

When does a Transaction end ?

2 7612

What does COMMIT do ?

4 10723

What is SAVE POINT ?

5 9768

What is Read-Only Transaction ?

3 6703

What is the function of Optimizer ?

1 4558

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

2 5302

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

2 4820

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

1 4022

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

1 4045

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

1 4184

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

1 4417

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

1 4471

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

2 4612

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

1 4511

Un-Answered Questions { Databases }

In what version of sql server were synonyms released?

1001

What port does postgresql listen on?

869

What are the important features of sybase?

1036

State three differences between Dbms and Rdbms?

1121

How to download microsoft sql server 2005 express edition?

1095

What is 1nf normalization form?

1084

What is erd?

1062

What you can use regular expression for in mysql? Support your answer with an example?

962

How does sql profiler work?

1065

Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

1075

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1586

How to set the time zone for MySQL to particular country time?

3252

Why is pl sql used?

1030

What is a join? Explain the different types of mysql joins.

1462

What are sparse columns?

1068

For More Un-Answered { Databases } Questions Click Here