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)

540

What parameters control copy latches?

556

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

617

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

535

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

1 947

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

523

What is explain plan and how is it used?

548

What is the purpose of the grep command?

1 2051

How do you set up tablespaces during an oracle installation?

568

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

523

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

541

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

539

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

511

How do you generate file output from sql?

573

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

556

Post New Oracle DBA (Database Administration) Questions

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

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?

566

How do I become a dba?

542

What file will give you oracle instance status information? Where is it located?

572

How to uncatalog backup?

508

How many types of database software are there?

546

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

560

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

535

I am getting error "no communication channel" after changing the domain name? What is the solution?

551

How many types of dba are there?

527

What is the use of the drop option in the alter table command?

558

Is oracle dba in demand?

550

What exactly does a dba do?

533

Tell me about standby database? What are some of the configurations of it?

529

Give one method for transferring a table from one schema to another?

548

What do you mean by oracle dba and what is its role?

544

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