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)

529

What parameters control copy latches?

548

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

604

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

522

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

1 932

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

512

What is explain plan and how is it used?

539

What is the purpose of the grep command?

1 2028

How do you set up tablespaces during an oracle installation?

552

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

515

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

526

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

530

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

499

How do you generate file output from sql?

563

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

541


Post New Oracle DBA (Database Administration) Questions

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

What are the five functions of a database?

556


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

532


What is oracle full backup?

513


How long does it take to learn database administration?

506


How would you find total size of database in os level?

505


What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

578


What do you understand by the oracle?

499


Explain the term 'oracle grid architecture'?

536


What parameters control copy latches?

548


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

526


How do you set up your tablespace on installation level: low?

512


I have applied the following commands: now what will happen, will the database will give an error / it will work?

503


Which date function is used to find the difference between two dates?

519


Explain the wait events in statspack report 'enqueue'?

521


How do you prevent oracle from giving you informational messages during and after a sql statement execution?

524