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?

638

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

631

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

600

Explain procedure to change characterset of a database.

683

What is oracle archived redo log?

639

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

604

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

611

List five most important parameter in 9i affecting performance?

610

What is the difference between rman and a traditional hotbackup?

1 1514

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

598

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

617

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

661

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

616

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

637

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

630

Post New Oracle DBA (Database Administration) Questions

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

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

642

You have taken a manual backup of a datafile using os. How rman will know about it?

599

What is the difference between a database and instance?

744

What are the roles and responsibilities of oracle dba?

704

How do I become a database administrator?

626

Why do we need a database?

638

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

583

What do you understand by a control file?

599

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

602

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

583

What is the difference between a database and instance? What is the relation between them?

626

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?

621

Which database is best to learn?

616

How can be determining the size of the log files?

623

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

709

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