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

1884

---

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

2079

---

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

1912

---

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

2051

---

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

2276

---

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

2159

---

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.

2007

---

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

2325

---

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

1934

---

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.

2125

---

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

2146

---

How does Oracle guarantee data integrity of data changes?

2390

---

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

2120

---

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

2424

---

What would you do with an in-doubt distributed transaction?

1980

---