Answer / b.r.reddy

We can manually set the statistical values.
We can gather statistics in parallel mode.

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

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

1 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

---

How can you control the amount of free space in your index pages? : sql server DBA

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 would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

---

what is asm?

0 Answers   Oracle,

---

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

---

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

0 Answers  

---

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

---