Oracle DBA (Database Administration) Interview Questions
Questions Answers Views Company eMail

How do you install statspack?

509

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

396

How do you analyze table partition using oracle provided package?

361

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

529

What is oracle partial backup?

416

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

381

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

405

Do you need a commit after ddl statements?

404

Explain the wait events in statspack report 'enqueue'?

390

What is the difference between raid 5 and raid 10? Which is better for oracle?

423

What is the difference between truncate and delete? Why is one faster?

405

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

366

What are bind variables and why are they important?

383

Explain force logging feature in 9i.

402

Which rman command is used to create an exact replica of a database innew host?

380


Post New Oracle DBA (Database Administration) Questions

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

Can you remove an open file under unix?

492


What is explain plan and how is it used?

415


How many databases should a dba manage?

417


When should an artificial (or derived) primary key be used?

436


Which process writes data from data files to database buffer cache?

401


How can you find your id on a system?

398


What is the main function of database?

414


Give one method for transferring a table from one schema to another?

413


What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

458


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

398


What skills do you need to be a database administrator?

378


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

388


What is the meaning of database backup?

385


What are dba privileges?

362


What does database administrator do?

385