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

2272

---

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

2499

---

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?

2046

---

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

2673

---

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?

2862

---

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.

2218

---

Explain about query and reporting.

2139

---

How to combine two function together?

2204

---

How to use timestamp datatypes

2080

---

How to replace not in with not exist?

2181

---

Write short notes on manual refreshes.

2789

---

How to customize error conditions.

2200

---

How to generate OIDS

2334

---

How to use online Backups?

2263

---

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

2241

---