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

2278

---

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

2507

---

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?

2050

---

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

2680

---

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?

2866

---

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.

2144

---

How to combine two function together?

2216

---

How to use timestamp datatypes

2082

---

How to replace not in with not exist?

2192

---

Write short notes on manual refreshes.

2798

---

How to customize error conditions.

2204

---

How to generate OIDS

2343

---

How to use online Backups?

2268

---

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

2253

---