How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1825

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1477

---

How would you begin to troubleshoot an ORA-3113 error?

1590

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1483

---

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1614

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

1799

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1667

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1528

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1801

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1462

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1571

---

Explain how you would restore a database using RMAN to Point in Time?

1626

---

How does Oracle guarantee data integrity of data changes?

1934

---

Which environment variables are absolutely critical in order to run the OUI?

1644

---

Why does Oracle not permit the use of PCTUSED with indexes?

1947

---