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?

622

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

622

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

590

Explain procedure to change characterset of a database.

673

What is oracle archived redo log?

626

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

594

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

599

List five most important parameter in 9i affecting performance?

599

What is the difference between rman and a traditional hotbackup?

1 1503

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

590

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

608

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

645

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

608

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

623

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

615

Post New Oracle DBA (Database Administration) Questions

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

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

577

Can you remove an open file under unix?

724

Which is the best option used to move database from one server to another serve on same network and why?

572

Are database administrators in demand?

603

What are the different types of database users?

613

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

648

What should a dba know?

568

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

614

How do you set up tablespaces during an oracle installation?

646

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

577

What are the different responsibilities of a dba?

772

What do you mean by oracle dba?

598

What kinds of responsibilities does a dba have in a database environment?

638

Do you need a commit after ddl statements?

595

What is end user in database?

624

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