Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How do you install statspack?

685

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

549

How do you analyze table partition using oracle provided package?

520

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

765

What is oracle partial backup?

585

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

577

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

549

Do you need a commit after ddl statements?

561

Explain the wait events in statspack report 'enqueue'?

577

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

589

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

648

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

587

What are bind variables and why are they important?

543

Explain force logging feature in 9i.

608

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

593


Post New Oracle DBA (Database Administration) Questions

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

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

617


What is end user in database?

597


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

587


How can you determine the space left in a file system?

649


What are the main benefits of using spfile over pfile?

641


Which files are vital that should be backed up?

603


How many types of dba are there?

569


If you see statistics that deal with "undo" what are they really talking about?

653


What should a dba know?

528


Why are recursive relationships bad? How do you resolve them?

589


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

564


You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

597


What does database administrator do?

570


What are the important tasks of common oracle dba?

560


What is difference between co-related sub query and nested sub query?

567