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?

596

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?

564

Explain procedure to change characterset of a database.

633

What is oracle archived redo log?

593

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

551

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

564

List five most important parameter in 9i affecting performance?

566

What is the difference between rman and a traditional hotbackup?

1 1443

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

564

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?

601

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

568

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

595

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

578

Post New Oracle DBA (Database Administration) Questions

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

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.

603

What is the difference between internal & external schema?

757

What is da in database?

543

Which database is best to learn?

567

What is the finger command?

585

When configuring sqlnet on the client what files need to be set up?

643

You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

794

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

601

What is the difference between sga and pga?

618

If you see contention for library caches how you can fix it?

564

What does database administrator do?

571

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

597

What is oracle archived redo log?

593

What is oracle dba role?

578

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?

575

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