Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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 6204

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

2 5144

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

2 4865

How the space utilisation takes place within rollback segments?

2 4793

What is a Control file ?

4 6899

How will you force database to use particular rollback segment?

1 4447

When will be a segment released?

1 4083

How can we plan storage for very large tables ?

1 4801

What are disadvanteges of having raw devices ?

1 3953

What is the significance of having storage clause ?

1 4354

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

1 3860

What is dictionary cache ?

2 5385

Why query fails sometimes ?

1 5049

How does Space allocation table place within a block ?

1 4089

How will you monitor rollback segment status ?

2 5945

Un-Answered Questions { Databases }

What is factless fact table? : sql server analysis services, ssas

1096

What is the use of keyword with encryption.

1081

How to open and close an explicit cursor in oracle?

1095

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

632

Difference between 10g & 11g in odi?

820

Explain transaction server auto commit?

1090

What is storage encryption?

Write a sql select query that only returns each name only once from a table?

1075

What is the difference between osql and query analyzer?

1046

Which is the correct statement about truncate and delete?

1172

What is a ctid?

943

What is a checkpoint in dbms and when does it occur?

1020

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1174

What is the difference between truncate & delete command?

1234

What are secondary keys?

1030

For More Un-Answered { Databases } Questions Click Here