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

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?

806

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

569

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

600

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

575

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

577

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

599

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

551

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

584

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

585

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

568

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

673

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

685

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

651

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

618

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

621

Un-Answered Questions { Databases }

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2041

Explain unique key in sql.

1031

How do you create a blank database?

959

Is mongodb columnar?

What are the types of variable use in pl sql?

1093

How can we migrate from SQL server to SQL Azure?

113

How to speed up webrick?

1092

What do you mean by stored techniques? How would we use it?

1049

What are the differences between triggers and stored procedures?

1085

What is the source code of a program?

1084

Define a temp table?

1034

Where are the settings stored for each instance in oracle?

1122

What is ssrs?

134

What is postmaster in postgresql?

913

What is 2nf in database?

1027

For More Un-Answered { Databases } Questions Click Here