Oracle DBA (Database Administration) Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle DBA (Database Administration) Interview Questions

Questions Answers Views Company eMail

Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?

522

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

604

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?

789

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

555

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

588

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

563

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

555

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

563

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

538

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

552

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

568

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

544

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

643

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

666

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

632

Post New Oracle DBA (Database Administration) Questions

Un-Answered Questions { Oracle DBA (Database Administration) }

What is dba in sound level?

568

System tablespace cant be exported from one database and imported into another why?

552

How would you find total size of database in os level?

565

How do you use automatic pga memory management with oracle 9i and above?

575

When using oracle export/import what character set concerns might come up? How do you handle them?

584

What are the different types of database users?

566

How do I become a dba?

579

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

597

What is the difference between a database and instance?

688

If you have an example table, what is the best way to get sizing data for the production table implementation?

549

What is difference between logical standby database and physical standby database?

669

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

1186

What is the easiest method to create a file on unix?

568

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

569

What is the finger command?

578

For More Un-Answered { Oracle DBA (Database Administration) } Questions Click Here