Oracle DBA (Database Administration) Interview Questions
Questions Answers Views Company eMail

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

404

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?

482

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?

441

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

389

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

403

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

398

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

393

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

489

What is an artificial (derived) primary key?

410

What is different type of rman backup?

436

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

411

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

380

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?

417

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

392

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

447


Post New Oracle DBA (Database Administration) Questions

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

What are the beneficial tools for administering the database?

385


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

393


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?

482


How do I become a data manager?

354


What is the advantage of using rman?

487


Which process writes data from data files to database buffer cache?

401


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

387


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

386


Which rman command is used to create an exact replica of a database innew host?

382


What does dba stand for in technology?

380


What are the different types of backup available in the oracle?

419


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

403


How should a many-to-many relationship be handled?

388


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

413


How do you generate file output from sql?

385