What are the commands you'd issue to show the explain plan for "select * from dual"?

2226

---

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

2436

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1983

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2617

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2805

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2164

---

Explain about query and reporting.

2081

---

How to combine two function together?

2122

---

How to use timestamp datatypes

2032

---

How to replace not in with not exist?

2083

---

Write short notes on manual refreshes.

2729

---

How to customize error conditions.

2144

---

How to generate OIDS

2250

---

How to use online Backups?

2198

---

what are steps for interface? where is exchange rate defined in which table?

2154

---