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 22763

What is SGA?

3 6463

What is PGA?

5 8279

When does LGWR write to the database?

3 10658

What is a Parallel Server option in ORACLE?

1 4105

What is User Process?

1 4385

What does LGWR do?

2 5570

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 14437

What is the function of Lock (LCKn) Process?

1 7008

What are the two types of Server Configurations?

3 6020

What is Shared Pool?

3 6075

What are the components of SGA?

5 6523

What is hit ratio ?

Indiabulls, RGPV,

13 130214

Un-Answered Questions { Databases }

What is supporting issues GL AP and AR?

2549

What do you understand by anchoring in reports?

Mention what is the difference between single instance environment and rac environment?

How to make a column bigger and delete unique from table.

965

Why more redos are generated when the oracle database is in begin backup mode?

1120

What is stored in a database?

967

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1011

Can instead of triggers be used to fire once for each statement on a view?

962

What are the filtered indexes?

1040

What are the 4 objects in access?

884

Is ms sql is free?

1020

Is database a hardware or software?

997

What are the basic sql commands?

1092

how to fetch alternate records from a table? : Sql dba

1112

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2204

For More Un-Answered { Databases } Questions Click Here