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

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

609

What parameters control copy latches?

631

What is difference between logical standby database and physical standby database?

706

What is the easiest method to create a file on unix?

598

using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?

1 1071

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

597

What is explain plan and how is it used?

647

What is the purpose of the grep command?

1 2185

How do you set up tablespaces during an oracle installation?

646

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

589

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

647

How many control files should you have? Where should they be located?

611

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

590

How do you generate file output from sql?

659

You see multiple extents in the temporary tablespace. Is this a problem?

621


Post New Oracle DBA (Database Administration) Questions

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

What is dba training?

594


What is the advantage of using rman?

760


How can you find dead processes?

572


How can you determine the number of sqlnet users logged in to the unix system?

601


What kinds of responsibilities does a dba have in a database environment?

638


What is end user in database?

624


Is oracle dba in demand?

638


How many types of database software are there?

618


You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

631


What are the types of schemas?

609


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

633


What is the purpose of the import option ignore? What is its default setting?

634


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

608


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

590


System tablespace cant be exported from one database and imported into another why?

589