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?

605

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?

719

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?

661

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

601

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

664

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

625

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

609

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

739

What is an artificial (derived) primary key?

658

What is different type of rman backup?

721

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

627

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

570

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?

620

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

602

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

677

Post New Oracle DBA (Database Administration) Questions

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

As an oracle dba what are the entire unix file you should be familiar with?

626

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

570

What is the meaning of database backup?

679

What are the data management skills?

588

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

589

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

625

How long does it take to learn database administration?

593

What is a junior dba?

677

What os user should be used for the first part of an oracle installation (on unix)?

590

When using oracle export/import what character set concerns might come up? How do you handle them?

637

What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?

610

Why are recursive relationships bad? How do you resolve them?

629

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

622

What are functions of dba?

594

What is oracle archived redo log?

638

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