What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2610

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2746

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2220

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2458

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2787

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

2414

---

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

2090

---

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

1965

---

How would you extract DDL of a table without using a GUI tool?

2538

---

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

2095

---

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

2356

---

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

2018

---

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.

2044

---

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

3020

---

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

1939

---