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

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

313

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

288

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

309

Explain procedure to change characterset of a database.

339

What is oracle archived redo log?

297

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

279

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

294

List five most important parameter in 9i affecting performance?

289

What is the difference between rman and a traditional hotbackup?

1 785

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

283

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

294

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

284

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

277

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

311

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

278


Post New Oracle DBA (Database Administration) Questions

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

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?

284


What is the main function of database?

295


What are the different types of database users?

285


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

298


Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

301






How do you analyze table partition using oracle provided package?

273


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

287


What is a database instance?

290


How can you tell if a tablespace has excessive fragmentation?

322


What are the main functions of dba?

275


How do you set up tablespaces during an oracle installation?

300


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

384


How many redo logs should you have and how should they be configured for maximum recoverability?

301


What is dba training?

286


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

303