1. Categories >> Software >> Databases >> Oracle >> Oracle DBA (Database Administration)
  2. Suggest New Category
Oracle DBA (Database Administration) Interview Questions
Questions Answers Views Company eMail

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

 349

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

 318

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

 340

Explain procedure to change characterset of a database.

 365

What is oracle archived redo log?

 329

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

 310

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

 328

List five most important parameter in 9i affecting performance?

 321

What is the difference between rman and a traditional hotbackup?

 1 860

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

 312

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

 324

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

 310

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

 314

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

 338

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

 303

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?

327

What is an artificial (derived) primary key?

321

Does a dba have to file taxes?

320

How can you determine if the sqlnet process is running for sqlnet v1? How about v2?

324

How do you prevent output from coming to the screen?

298




What is different type of rman backup?

348

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

339

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

319

What is oracle full backup?

312

What is the purpose of the grep command?

320

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

324

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

896

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

307

How do you generate file output from sql?

300

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

320

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