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?

642

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

643

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

645

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

638

How many control files should you have?

629

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

663

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

583

How do you prevent output from coming to the screen?

575

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

621

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

685

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

602

What are the requirements of simple database?

610

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?

630

What command is used to type files to the screen?

635

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

645

Post New Oracle DBA (Database Administration) Questions

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

What os user should be used for the first part of an oracle installation (on unix)?

590

What database block size should I use?

776

What skills should a dba have?

620

What is pct free/pct used/pct increase parameter in segment?

615

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

675

What is the difference between cold backup and hot backup?

622

What do you understand by recovery catalog?

601

What happens when the default and temp tablespace clauses are left out from create user statements?

619

Does dba need to know programming?

622

What is an artificial (derived) primary key?

658

What do you mean by oracle dba and what is its role?

639

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

624

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

645

What is the difference between a database and instance?

744

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

619

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