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

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

TCS,

7 21656

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 11622

How do you switch from an init.ora file to a spfile?

TCS,

4 19977

Explain the difference between a data block, an extent and a segment.

2 10734

Give two examples of how you might determine the structure of the table DEPT.

2 11540

Where would you look for errors from the database engine?

IBM,

2860

Compare and contrast TRUNCATE and DELETE for a table.

7 15819

Give the reasoning behind using an index.

2 8699

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 7635

What type of index should you use on a fact table?

1 3972

Give two examples of referential integrity constraints.

2 8629

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2521

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 24493

What command would you use to create a backup control file?

2 5319

Give the stages of instance startup to a usable state where normal users may access it.

1 3431

Un-Answered Questions { Databases }

What does database administrator do?

584

In the oracle version 9.3.0.5.0, what does each number shows?

1307

How do I open port 1433?

939

How to do transaction/locking in mongodb?

List out the difference between commit, rollback, and savepoint?

1046

Which language is used in sql?

1070

How to rebuild indexes with alter index ... Rebuild?

1129

Why mongodb is known as best nosql database?

What is the role of 8 analysers in mongodb?

what are the nonstandard string types? : Sql dba

1147

What are the different type of relationships in the dbms?

873

What is a table partition?

1146

What are the different types of Indexes available in SQL Server?

1013

How many levels of sp nesting are possible?

1032

What is ordinary table in oracle?

1166

For More Un-Answered { Databases } Questions Click Here