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

When Does DBWR write to the database?

6 22764

What is SGA?

3 6463

What is PGA?

5 8282

When does LGWR write to the database?

3 10658

What is a Parallel Server option in ORACLE?

1 4105

What is User Process?

1 4386

What does LGWR do?

2 5571

What is the function of Dispatcher (Dnnn)?

4 13820

What is the maximum number of Lock Processes used?

1 4176

What are functions of PMON?

5 14438

What is the function of Lock (LCKn) Process?

1 7008

What are the two types of Server Configurations?

3 6021

What is Shared Pool?

3 6076

What are the components of SGA?

5 6523

What is hit ratio ?

Indiabulls, RGPV,

13 130215

Un-Answered Questions { Databases }

Explain an incremental backup?

1001

What is sqlyog?

1028

List the parts of a database trigger.

1050

What is a delimiter in mysql?

1030

What is app tier?

862

How do I remove duplicate rows from a table in sybase?

907

What are entities and relationships?

975

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

930

How to insert multiple rows with a subquery?

1132

Where do we use decode and case statements?

1012

What is query parameter in ssrs?

160

Is primary key is clustered index?

1002

How to list all login names on the ms sql server?

1142

Is left join inner or outer by default?

1019

What is dbms function?

1013

For More Un-Answered { Databases } Questions Click Here