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?

523

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?

652

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?

572

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

510

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

573

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

523

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

520

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

629

What is an artificial (derived) primary key?

568

What is different type of rman backup?

623

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

547

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

498

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?

532

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

523

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

581

Post New Oracle DBA (Database Administration) Questions

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

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

551

What do you mean by oracle dba and what is its role?

544

What is different type of rman backup?

623

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

529

List five most important parameter in 9i affecting performance?

516

How do you use automatic pga memory management with oracle 9i and above?

542

What are the beneficial tools for administering the database?

508

Give one method for transferring a table from one schema to another?

548

If you are not sure what command does a particular unix function what is the best way to determine the command?

522

What are roles in oracle?

527

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?

536

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

540

What is dba training?

502

What are the skills required for oracle dba?

606

Which dba certification is best?

530

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