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?

526

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?

612

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?

794

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

559

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

590

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

565

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

564

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

576

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

541

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

569

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

570

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

558

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

653

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

672

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

638

Post New Oracle DBA (Database Administration) Questions

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

What is the dba role in oracle?

577

How many redo logs should you have and how should they be configured for maximum recoverability?

567

What is oracle dba role?

579

Are database administrators in demand?

565

Which function is used to find the largest integer less than or equal to aspecific value?

564

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

555

How does one coalesce free space?

550

What is oracle archived redo log?

593

What are the important tasks of common oracle dba?

560

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

575

Explain force logging feature in 9i.

608

I have applied the following commands: now what will happen, will the database will give an error / it will work?

549

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

617

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

689

What is the advantage of using rman?

722

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