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

2162

---

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).

2328

---

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.

2132

---

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

2148

---

How does Oracle guarantee data integrity of data changes?

2398

---

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

2122

---

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

2427

---

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

1981

---

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

2710

---

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?

2155

---

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

1921

---

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

2373

---

Whats the benefit of dbms_stats over analyze?

2005

---