You see multiple extents in the temporary tablespace. Is this a problem?

545

---

What is the finger command?

535

---

What does >> do?

538

---

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

528

---

How can you find all the processes on your system?

521

---

What happens when the default and temp tablespace clauses are left out from create user statements?

537

---

What is pct free/pct used/pct increase parameter in segment? What is growth factor?

499

---

When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?

561

---

What is pct free/pct used/pct increase parameter in segment?

529

---

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

549

---

How can you find out how many users are currently logged into the database? How can you find their operating system id?

477

---

What happens if a tablespace clause is left off of a primary key constraint clause?

528

---

Discuss row chaining, how does it happen?

520

---

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?

557

---

How can you find dead processes?

501

---