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

What is a Schema ?

6 9675

What is an Index ? How it is implemented in Oracle Database ?

4 11811

What is clusters ?

2 6753

What is a cluster Key ?

2 11262

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

2 5507

What is a deadlock ? Explain .

1 6006

What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?

TCS,

1 5155

What is a Shared SQL pool ?

2 7277

What is mean by Program Global Area (PGA) ?

Bajaj,

9 23030

What is a data segment ?

1 4983

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

2 5528

What is Database Buffers ?

1 4975

What is dictionary cache ?

2 5719

What is meant by recursive hints ?

1 6516

What is meant by redo log buffer ?

2 7815

Un-Answered Questions { Databases }

what are set operators in sql? : Sql dba

1110

How does cross join work?

1010

Is there any advantage of last_name varchar(50) over this last_name varchar(255)?

959

Differentiate between post-database commit and post-form commit?

1093

Can a table have 2 foreign keys?

961

What is a degree of relation?

1069

What are the functions in mysql?

1012

How to calculate expressions with sql statements?

1169

When is the update_statistics command used?

1183

Tell me when is the update_statistics command used?

1207

Why do we need foreign key?

938

How to determine what records to extract?

What is the maximum number of columns in sql table?

1232

How do you handle your own transaction?

1056

Explain what are the uses of rollback segment?

1069

For More Un-Answered { Databases } Questions Click Here