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?

643

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

519

How do you analyze table partition using oracle provided package?

484

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

723

What is oracle partial backup?

544

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

527

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

515

Do you need a commit after ddl statements?

525

Explain the wait events in statspack report 'enqueue'?

537

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

560

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

601

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

546

What are bind variables and why are they important?

511

Explain force logging feature in 9i.

573

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

556


Post New Oracle DBA (Database Administration) Questions

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

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

570


What skills should a dba have?

529


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

532


Can you remove an open file under unix?

650


What is da in database?

500


What degree do database administrators need?

516


What are functions of dba?

515


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

511


How many databases should a dba manage?

610


You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

566


What happens when the default and temp tablespace clauses are left out from create user statements?

543


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

527


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

537


A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

523


How do I become a database administrator?

530