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?

557

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?

678

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?

602

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

546

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

614

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

572

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

560

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

673

What is an artificial (derived) primary key?

604

What is different type of rman backup?

656

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

579

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

526

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?

567

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

560

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

621

Post New Oracle DBA (Database Administration) Questions

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

What do you mean by oracle dba?

563

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

580

I am getting error "no communication channel" after changing the domain name? What is the solution?

593

What is explain plan and how is it used?

599

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

571

What is a dba why is this position necessary?

567

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

563

What is oracle full backup?

561

Explain procedure to change characterset of a database.

608

What are the different responsibilities of a dba?

703

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?

602

What are roles in oracle?

559

What do you understand by the term 'normalization'? Explain the various modes of normalization?

548

What are the goals of dba?

545

What are the main functions of dba?

567

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