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?

562

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

572

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

550

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

548

How many control files should you have?

558

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

572

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

509

How do you prevent output from coming to the screen?

486

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

515

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

594

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

515

What are the requirements of simple database?

527

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?

539

What command is used to type files to the screen?

553

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

560

Post New Oracle DBA (Database Administration) Questions

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

What is the dba role in oracle?

527

What is oracle log switch?

572

What are the different responsibilities of a dba?

658

How to drop an oracle database?

514

How do you prevent output from coming to the screen?

486

How do you put database is archivelog mode, explain procedure?

515

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

546

What is a dba?

553

I am getting error "no communication channel" after changing the domain name? What is the solution?

551

what does the no logging option do? Why would we use it?

520

When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?

565

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

723

What is ora-1555 snapshot too old error? Explain in detail?

629

What are the beneficial tools for administering the database?

508

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

537

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