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?

564

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?

643

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?

829

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

596

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

627

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

591

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

601

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

625

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

576

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

603

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

603

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

588

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

691

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

711

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

667

Post New Oracle DBA (Database Administration) Questions

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

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

693

What happens if the constraint name is left out of a constraint clause?

573

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

625

What are the possible ways to gain information regarding the control file?

605

What is oracle partial backup?

629

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

647

What is the most common database language that a db administrator needs to know?

602

What is oracle dba role?

617

What do you mean by dba?

600

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

576

Is oracle dba in demand?

639

What is pga_aggregate_target?

615

What is oracle full backup?

608

How do I become a database administrator?

608

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

627

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