Answer Posted / sridhar

truncate and delete are deltes all rows in the table but truncate is much faster than delete.
and if u delete row in the delte deletion of each gets logged in the transaction log.
truncate there is no way to log in transaction log

what functionality does oracle provide to secure sensitive information?

959

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

968

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

2313

---

what is a crs resource?

1129

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2071

---

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?

2471

---

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2053

---

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.

2125

---

What is fill factor? : sql server DBA

1195

---

What is dbcc? : sql server DBA

1236

---

who owns the operating system files created by the utl_file package?

1034

---

Why would you call update statistics? : sql server DBA

961

---

What are the steps you will take to improve performance of a poor performing query?

2806

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2291

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2670

---