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

How do you install statspack?

525

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

404

How do you analyze table partition using oracle provided package?

369

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?)

539

What is oracle partial backup?

426

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

392

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

415

Do you need a commit after ddl statements?

411

Explain the wait events in statspack report 'enqueue'?

399

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

437

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

416

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

379

What are bind variables and why are they important?

397

Explain force logging feature in 9i.

416

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

392


Post New Oracle DBA (Database Administration) Questions

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

What is oracle log switch?

416


How do I become an administrator?

404


How should a many-to-many relationship be handled?

394


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

427


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?

466


How does one coalesce free space?

394


What is tkprof and how is it used?

426


How can you find out how many users are currently logged into the database?

442


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

422


What are elements of administration?

403


Which files are vital that should be backed up?

435


What are four common errors found in an alert .log?

394


What is oracle archived redo log?

410


How many types of database software are there?

412


How do you prevent output from coming to the screen?

368