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 5963

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

2 4871

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

2 4652

How the space utilisation takes place within rollback segments?

2 4583

What is a Control file ?

4 6568

How will you force database to use particular rollback segment?

1 4285

When will be a segment released?

1 3933

How can we plan storage for very large tables ?

1 4646

What are disadvanteges of having raw devices ?

1 3735

What is the significance of having storage clause ?

1 4177

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

1 3677

What is dictionary cache ?

2 5156

Why query fails sometimes ?

1 4902

How does Space allocation table place within a block ?

1 3941

How will you monitor rollback segment status ?

2 5720

Un-Answered Questions { Databases }

What is postgres default password?

738

Is a table valued function object?

959

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

934

What is the synonym of join?

895

What are the technical specifications of mysql?

1088

In which format image is stored in database?

840

What is the cpu pressure?

992

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1172

What is indexes?

1000

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1934

i am writing a query select EmpNo from Emp how can i call in after parameter form

2048

What is clustered table in Oracle?

1106

What are the triggers in sql?

1018

Do I need a report server to run reports in my application?

153

What is computer end?

856

For More Un-Answered { Databases } Questions Click Here