Tell me about standby database? What are some of the configurations of it? What should we watch out for?

287

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

315

What is the difference between a database and instance?

344

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?

272

What are four common errors found in an alert .log?

275

What are the different types of backup available in the oracle?

294

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

275

What are dba privileges?

253

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

292

Explain the wait events in statspack report 'db scattered read'?

273

What does a senior database administrator do?

283

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

283

What are the types of schemas?

269

What are the functions of administration?

289

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

267