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?

560

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

542

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

527

Explain procedure to change characterset of a database.

573

What is oracle archived redo log?

550

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

520

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

519

List five most important parameter in 9i affecting performance?

516

What is the difference between rman and a traditional hotbackup?

1 1374

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

533

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

531

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

563

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

529

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

544

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

534

Post New Oracle DBA (Database Administration) Questions

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

What is the full form of dba?

557

What is a database instance?

548

How can you find dead processes?

510

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

498

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

509

Does dba need to know programming?

524

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

555

What should a dba know?

490

How many databases should a dba manage?

610

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

524

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

544

What is the difference between internal & external schema?

696

How do I become a data manager?

483

How can you find your id on a system?

526

Does a dba have to file taxes?

538

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