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?

545

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

525

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

519

Explain procedure to change characterset of a database.

560

What is oracle archived redo log?

537

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

514

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

508

List five most important parameter in 9i affecting performance?

504

What is the difference between rman and a traditional hotbackup?

1 1361

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

524

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

513

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

549

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

520

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

534

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

519

Post New Oracle DBA (Database Administration) Questions

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

When should you increase copy latches? What parameters control copy latches?

525

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

512

What is an artificial (derived) primary key?

556

What are some indications that you need to increase the shared_pool_size parameter?

513

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

527

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

515

What should a dba know?

479

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

524

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

510

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

516

What are the data management skills?

495

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

526

How would you find total size of database in os level?

505

What are the different types of backup available in the oracle?

537

How can you tell if a tablespace has excessive fragmentation?

550

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