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?

475

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?

546

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?

746

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

520

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

553

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

511

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

513

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

511

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

486

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

513

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

525

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

493

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

603

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

609

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

578

Post New Oracle DBA (Database Administration) Questions

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

What is an artificial (derived) primary key?

556

What are elements of administration?

534

What are the different types of database users?

523

Which dba certification is best?

520

How can you find your id on a system?

517

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?

643

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

503

What is dba training?

485

What kinds of responsibilities does a dba have in a database environment?

557

What does a dba do all day?

494

What does >> do?

535

What is end user in database?

538

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?

546

What does a senior database administrator do?

549

How can you determine the space left in a file system?

582

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