Answer / pallavi

cursor is a mechanism by which we can assign a name to a select statement and manipulate the information within sql statement

Explain the difference between a data block, an extent and a segment.

2 Answers  

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

---

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

0 Answers  

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

---

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

---

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

How can you rebuild an index?

6 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

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

1 Answers  

---

what is incremental checkpoint?

1 Answers   CTS,

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---