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 6089

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 4704

What is a Control file ?

4 6746

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 4732

What are disadvanteges of having raw devices ?

1 3857

What is the significance of having storage clause ?

1 4273

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

1 3778

What is dictionary cache ?

2 5266

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 5858

Un-Answered Questions { Databases }

can you tell what are the different set operations available in mysql? : Mysql dba

890

What is the difference between ‘having’ clause and a ‘where’ clause?

1039

What does the no logging option do? Why would we be careful of using it?

601

How to call shell script from pl sql procedure?

1277

What do you understand by data redundancy?

927

What are the purposes of floor and sign functions?

976

How are extents allocated to a segment?

1125

What is a functional dependency in the dbms?

892

How to disable stored procedure sql server?

1606

Name the different triggers associated with oracle forms having a master-detail relationship.

999

What do you understand by SQL*Net?

1031

What is the need for group functions in sql?

1083

Can we use where and having clause together?

1045

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

What is create command?

968

For More Un-Answered { Databases } Questions Click Here