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?

600

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

610

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

597

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

605

How many control files should you have?

591

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

616

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

547

How do you prevent output from coming to the screen?

528

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

563

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

636

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

549

What are the requirements of simple database?

570

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?

591

What command is used to type files to the screen?

594

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

606

Post New Oracle DBA (Database Administration) Questions

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

Which database is best to learn?

568

How do you install statspack?

686

What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?

593

What parameters control copy latches?

592

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

576

How do you set up tablespaces during an oracle installation?

606

You see multiple fragments in the system tablespace, what should you check first?

584

What degree do database administrators need?

545

Explain the wait events in statspack report 'db scattered read'?

581

What do you understand by a control file?

565

How do you analyze table partition using oracle provided package?

520

What do you understand by the term 'normalization'? Explain the various modes of normalization?

556

How many types of database software are there?

587

What is oracle log switch?

619

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

570

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