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

2104

---

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.

1952

---

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

2260

---

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

1884

---

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.

2062

---

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

2107

---

How does Oracle guarantee data integrity of data changes?

2342

---

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

2080

---

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

2377

---

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

1926

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2664

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2089

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1882

---

What are the ways tablespaces can be managed and how do they differ?

2285

---

Whats the benefit of dbms_stats over analyze?

1948

---