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

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

596

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

604

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

590

Give one method for transferring a table from one schema to another?

597

How many control files should you have?

589

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

609

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

540

How do you prevent output from coming to the screen?

518

What is dump destination? What are bdump, cdump and udump?

554

When configuring sqlnet on the server what files must be set up?

632

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

544

What are the requirements of simple database?

567

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

582

What command is used to type files to the screen?

590

How can you find out how many users are currently logged into the database?

603

Post New Oracle DBA (Database Administration) Questions

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

Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

587

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

571

What are four common errors found in an alert .log?

558

What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?

576

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

605

How can you tell if a tablespace has excessive fragmentation?

595

Is oracle dba in demand?

588

Explain force logging feature in 9i.

603

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

556

What does a dba do all day?

549

How many dba can you have?

542

Which dba certification is best?

563

What is a production dba?

604

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

544

What does dba stand for database?

592

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