Oracle DBA (Database Administration) Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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)

622

What parameters control copy latches?

638

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

713

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

613

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

1 1083

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

609

What is explain plan and how is it used?

657

What is the purpose of the grep command?

1 2198

How do you set up tablespaces during an oracle installation?

655

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

599

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

658

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

619

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

600

How do you generate file output from sql?

669

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

634

Post New Oracle DBA (Database Administration) Questions

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

Can you remove an open file under unix?

730

What happens if a tablespace clause is left off of a primary key constraint clause?

623

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

630

What are the goals of dba?

615

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?

638

What do you understand by the term 'system change number (scn)'?

641

Does a dba have to file taxes?

632

How can you find out how many users are currently logged into the database? How can you find their operating system id?

586

Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

628

If you see contention for library caches how you can fix it?

610

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

658

What is the dba role in oracle?

628

What is pga_aggregate_target?

632

What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?

639

What exactly does a dba do?

624

For More Un-Answered { Oracle DBA (Database Administration) } Questions Click Here