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

What operator tests column for the absence of data?

599

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

555

Explain the wait events in statspack report 'db sequential real'?

636

Explain the wait events in statspack report 'db scattered read'?

581

What is your favorite tool for day-to-day oracle operation?

548

What is the difference between truncate and delete? How would a full table scan behave after?

552

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

567

What is oracle full backup?

570

What is pga_aggregate_target?

571

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.

603

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

627

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

566

Tell me about standby database? What should we watch out for?

547

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

620

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

659

Post New Oracle DBA (Database Administration) Questions

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

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

576

What is the difference between a database and instance?

694

What is a dba?

585

Who is dba in dbms?

581

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

597

How many control files should you have?

591

Explain the various modes of normalization?

540

What is main function of database administrator?

571

Which files are vital that should be backed up?

603

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

541

How many redo logs should you have and how should they be configured for maximum recoverability?

567

Discuss row chaining, how does it happen? How can you reduce it?

542

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

617

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

575

What is dba in sound level?

586

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