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

371

What does a senior database administrator do?

283

What is the difference between internal & external schema?

308

How do you analyze table partition using oracle provided package?

258

If you see statistics that deal with "undo" what are they really talking about?

378

What is the difference between cold backup and hot backup?

302

Discuss row chaining, how does it happen?

270

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?

357

What is oracle log switch?

288

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

314

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

275

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

280

What does >> do?

283

What are dba privileges?

251

What is explain plan and how is it used?

282