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 use of the drop option in the alter table command?

600

How do you use automatic pga memory management with oracle 9i and above?

589

Which function is used to find the largest integer less than or equal to aspecific value?

566

Explain procedure to change characterset of a database.

641

What is oracle archived redo log?

595

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

556

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

569

List five most important parameter in 9i affecting performance?

570

What is the difference between rman and a traditional hotbackup?

1 1446

How can you tell if an index on particular table is used or not used in 9i?

566

You see a wait on lms process in statspack, what does that mean?

574

What does the no logging option do? Why would we be careful of using it?

603

Tell me about standby database? What are some of the configurations of it?

570

When using oracle export/import what character set concerns might come up? How do you handle them?

600

Which date function is used to find the difference between two dates?

583

Post New Oracle DBA (Database Administration) Questions

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

How to uncatalog backup?

572

How much money does a dba make?

584

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

621

What are the steps involved in instance recovery in oracle?

550

Which database is best to learn?

574

How to drop an oracle database?

576

How many types of database software are there?

587

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

605

Which files are vital that should be backed up?

603

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

589

What are the beneficial tools for administering the database?

543

How many redo logs should you have and how should they be configured for maximum recoverability?

567

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

581

What are dba privileges?

540

What is a junior dba?

629

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