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?

566

---

Why are recursive relationships bad? How do you resolve them?

536

---

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

568

---

When configuring sqlnet on the client what files need to be set up?

593

---

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

518

---

How can you determine the space left in a file system?

606

---

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

550

---

Can you remove an open file under unix?

652

---

How can you determine if an oracle instance is up from the operating system level?

523

---

When should you increase copy latches?

590

---

How to uncatalog backup?

513

---

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?

1155

---

What causes the "snapshot too old" error? How can this be prevented or mitigated?

484

---

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

533

---

How to drop an oracle database?

514

---