Answer / m raghava rao

Gate ways is used as main entry point. Or we can say A gateway is a network point that acts as an entrance to another network

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

How can you rebuild an index?

6 Answers  

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  

---

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

---

what is asm?

0 Answers   Oracle,

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---