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?

540

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

512

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

568

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

534

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

502

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

506

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

524

What is oracle full backup?

513

What is pga_aggregate_target?

520

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.

558

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?

577

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?

526

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

499

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

536

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

608

Post New Oracle DBA (Database Administration) Questions

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

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?

560

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

524

What are the different types of database users?

523

Are database administrators in demand?

511

Explain force logging feature in 9i.

563

What skills do you need to be an administrator?

500

What happens if the constraint name is left out of a constraint clause?

501

Discuss row chaining, how does it happen? How do you correct it?

496

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

519

When configuring sqlnet on the server what files must be set up?

575

Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?

475

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

536

What is dba in sound level?

534

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

555

How should a many-to-many relationship be handled?

493

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