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

What is the use of the drop option in the alter table command?

1

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

1

Which function is used to find the largest integer less than or equal to aspecific value?

1




Explain procedure to change characterset of a database.

1

What is oracle archived redo log?

1

what does the no logging option do? Why would we use it?

1

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

1

List five most important parameter in 9i affecting performance?

1




What is the difference between rman and a traditional hotbackup?

1

How can you tell if an index on particular table is used or not used in 9i?

1

You see a wait on lms process in statspack, what does that mean?

1

What does the no logging option do? Why would we be careful of using it?

1

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

1

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

1

Which date function is used to find the difference between two dates?

1


Post New Oracle DBA (Database Administration) Questions






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

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?

1


Which is the best option used to move database from one server to another serve on same network and why?

1


When should you increase copy latches? What parameters control copy latches?

1


Discuss row chaining, how does it happen?

1


What is the difference between truncate and delete? Why is one faster?

1






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

1


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

1


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

1


What does dba stand for in technology?

1


What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

1


what does the no logging option do? Why would we use it?

1


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

1


You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

1


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

1


How can you tell if an index on particular table is used or not used in 9i?

1