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?

596

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?

714

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?

651

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

586

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

652

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

615

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

599

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

726

What is an artificial (derived) primary key?

646

What is different type of rman backup?

702

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

617

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

559

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?

608

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

594

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

667

Post New Oracle DBA (Database Administration) Questions

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

What are roles in oracle?

615

Who is dba in dbms?

614

What is a database instance?

626

What is the advantage of using rman?

760

What do you understand by the term 'normalization'?

710

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

630

How to drop an oracle database?

597

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

595

What do you understand by the term 'system change number (scn)'?

625

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

597

What is the finger command?

612

Explain procedure to change characterset of a database.

673

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

689

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

667

What happens if a tablespace clause is left off of a primary key constraint clause?

609

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