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?

589

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

552

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

630

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

573

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

542

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

545

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

561

What is oracle full backup?

564

What is pga_aggregate_target?

566

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.

601

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?

622

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?

563

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

543

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

596

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

655

Post New Oracle DBA (Database Administration) Questions

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

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

1185

What exactly does a dba do?

570

What is oracle dba role?

569

How do you set up tablespaces during an oracle installation?

604

You are getting busy buffer waits. Is this bad? How can you find what is causing it?

531

What is oracle full backup?

564

How do you prevent output from coming to the screen?

518

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

566

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

669

What is oracle partial backup?

577

601

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

545

What is oracle archived redo log?

583

What are the various ingredients of sga?

564

How do you generate file output from sql?

614

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