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

You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

1 861

While taking hot backup (begin end backup) what will happens back end?

1 632

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

1 663

If you are not sure what command does a particular unix function what is the best way to determine the command?

1 627

If you see contention for library caches how you can fix it?

1 634

How can you determine if the sqlnet process is running for sqlnet v1? How about v2?

1 666

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

1 608

What are some indications that you need to increase the shared_pool_size parameter?

1 647

When should you increase copy latches? What parameters control copy latches?

1 630

How should a many-to-many relationship be handled?

1 618

If you see statistics that deal with "undo" what are they really talking about?

1 730

When should the default values for oracle initialization parameters be used as is?

1 748

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

1 704

What is the purpose of the import option ignore? What is its default setting?

1 665

Which process writes data from data files to database buffer cache?

1 669

Un-Answered Questions { Databases }

What is an indexed view?

1018

How to use values from other tables in update statements using oracle?

1149

What is sql server query analyzer?

1123

Can we do dml on views?

1032

What is self contained sub query?

1138

How can we solve concurrency problems?

1120

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

what are the advantages of sql ? : Sql dba

1138

How to start an oracle instance?

1098

what is the command syntax for inserting a document?

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1064

How to export data from database and import into another?

993

Does view occupy space?

1005

Is it possible to have clustered index on separate drive from original table location?

1034

Have you used lexical parameters in reports?

For More Un-Answered { Databases } Questions Click Here