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

How can you determine if an index needs to be dropped and rebuilt?

511

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

643

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

559

If you have an example table, what is the best way to get sizing data for the production table implementation?

503

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

555

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

510

How would you find total size of database in os level?

505

What is ora-1555 snapshot too old error? Explain in detail?

616

What is an artificial (derived) primary key?

556

What is different type of rman backup?

612

You see multiple fragments in the system tablespace, what should you check first?

538

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

488

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?

518

How do you set up your tablespace on installation level: low?

512

If you see the value for reloads is high in the estat library cache report is this a matter for concern?

565

Post New Oracle DBA (Database Administration) Questions

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

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

536

You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

746

When configuring sqlnet on the client what files need to be set up?

579

What is the most common database language that a db administrator needs to know?

520

How do you install statspack?

635

What is a dba certification?

528

Discuss row chaining, how does it happen?

519

How would you find total size of database in os level?

505

How many types of database software are there?

536

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

608

What are bind variables and why are they important?

504

What are the data management skills?

495

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

503

What does a dba do all day?

494

What are the main benefits of using spfile over pfile?

582

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