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

How to implement the multiple control files for an existing database ?

2 6088

How will you swap objects into a different table space for an existing database?

2 5011

How will you estimate the space required by a non-clustered tables?

2 4771

How the space utilisation takes place within rollback segments?

2 4703

What is a Control file ?

4 6742

How will you force database to use particular rollback segment?

1 4364

When will be a segment released?

1 4017

How can we plan storage for very large tables ?

1 4731

What are disadvanteges of having raw devices ?

1 3857

What is the significance of having storage clause ?

1 4272

What is meant by Redo Log file mirrorring ? How it can be achieved?

1 3776

What is dictionary cache ?

2 5265

Why query fails sometimes ?

1 4988

How does Space allocation table place within a block ?

1 4020

How will you monitor rollback segment status ?

2 5856

Un-Answered Questions { Databases }

What is Library Cache in Oracle?

1142

Can you rollback after commit?

982

Which is the best database?

918

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1109

What are the ways on commenting in a pl/sql code?

1133

Can we connect to ORACLE db using Windows Authentication?

1256

Explain oracle’s server parameter file.

990

What are the tools provided in oracle enterprise manager?

Do you know what is a trace frag? Where do we use it?

997

What does it mean to invest in the index?

969

how many sql dml commands are supported by 'mysql'? : Sql dba

1120

Difference between drill down and drill through report.

952

What is the maximum number of triggers that can be applied to a single table?

1021

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1345

What are the character types that are available in postgresql?

1397

For More Un-Answered { Databases } Questions Click Here