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

Discuss row chaining, how does it happen? How do you correct it?

319

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

344

What is tkprof and how is it used?

334

As an oracle dba what are the entire unix file you should be familiar with?

320

You are getting busy buffer waits. Is this bad? How can you find what is causing it?

325

How does one create a new database?

343

What database block size should I use?

438

How does one coalesce free space?

319

What does dba stand for database?

341

What is the full form of dba?

343

How many dba can you have?

320

Does a dba have to file taxes?

320

What does a dba do all day?

319

Who is dba in dbms?

327

What skills does a dba need?

347


Post New Oracle DBA (Database Administration) Questions

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

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?

400


What are the five functions of a database?

349


You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

339


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

307


What is oracle full backup?

312






What parameters control copy latches?

316


What is the purpose of the grep command?

320


What is a dba programmer?

336


Who is a database user?

313


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

314


What are the goals of dba?

295


Does a dba have to file taxes?

320


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

328


How many dba can you have?

320


What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?

364