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?

553

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

564

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

539

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

536

How many control files should you have?

546

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

562

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

501

How do you prevent output from coming to the screen?

476

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

507

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

575

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

503

What are the requirements of simple database?

519

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?

527

What command is used to type files to the screen?

541

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

547

Post New Oracle DBA (Database Administration) Questions

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

What is the difference between a database and instance?

646

As an oracle dba what are the entire unix file you should be familiar with?

535

How do you install statspack?

635

How do I become a data manager?

472

What file will give you oracle instance status information? Where is it located?

555

What database block size should I use?

663

What should a dba know?

479

What is explain plan and how is it used?

539

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 do you understand by recovery catalog?

517

What are types of data model?

493

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

518

What does >> do?

535

What is the difference between raid 5 and raid 10? Which is better for oracle?

545

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

603

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