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 22457

What is SGA?

3 6350

What is PGA?

5 8037

When does LGWR write to the database?

3 10501

What is a Parallel Server option in ORACLE?

1 4019

What is User Process?

1 4291

What does LGWR do?

2 5457

What is the function of Dispatcher (Dnnn)?

4 13646

What is the maximum number of Lock Processes used?

1 4087

What are functions of PMON?

5 14198

What is the function of Lock (LCKn) Process?

1 6912

What are the two types of Server Configurations?

3 5893

What is Shared Pool?

3 5928

What are the components of SGA?

5 6332

What is hit ratio ?

Indiabulls, RGPV,

13 129697

Un-Answered Questions { Databases }

What are the different pseudo commands? Explain in general?

1032

What is a column in a table?

1072

Describe how to use the linked server?

1071

Who uses access database?

773

Explain dml and ddl?

929

What is the default port for SQL Server over a firewall?

1042

How remove data files before opening a database?

1012

What is pdo in php mysql?

894

What are the results of running this script?

869

How to start mysql server?

1000

What is indexing in mysql?

896

1) Does oracle have any table which contain all the exceptions and it's code internally?

1712

How do you handle your own transaction?

947

What are sql server functions?

942

What are the advantages of using third-party tools?

928

For More Un-Answered { Databases } Questions Click Here