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

Which parameter in Storage clause will reduce no. of rows per block?

1 3926

What is advantage of having disk shadowing/ Mirroring ?

1 4078

How will you create multiple rollback segments in a database ?

1 4209

What is the functionality of SYSTEM table space ?

3 7468

List the factors that can affect the accuracy of the estimations ?

1 3564

What is meant by free extent ?

2 5120

List the Optional Flexible Architecture (OFA) of Oracle database ?

1 4659

What is meant by redo log buffer ?

3 6966

What is the role of PCTFREE parameter is Storage clause ?

2 5882

What is use of Rollback Segments In Database ?

4 6558

What is a Rollback segment entry ?

TCS,

3 7902

How will you monitor the space allocation ?

3 8365

What is meant by recursive hints ?

1 4500

What is the OPTIMAL parameter ?

TCS,

1 6097

What is Database Buffers ?

4 11436

Un-Answered Questions { Databases }

What are the approximate numeric data types?

877

What is mvcc in mysql?

922

What is cte?

923

What are types of subqueries?

996

Explain commit, rollback and savepoint.

933

How to select distinct on multiple columns?

784

How does mysql clustering work?

851

What are the different parts of a database application called in access?

724

What is default postgres port?

838

What is sql in database management system?

890

What is the federation in sql azure?

What does the option psql -l of PostgreSQL display?

1375

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1062

How does recursive cte works in sql server?

942

Explain how exception handling is done in advance pl/sql?

958

For More Un-Answered { Databases } Questions Click Here