Answer Posted / santosh

Basically truncate is a DDL and Delete is DML. You can use
delete to remove rows depending on certain criteria and it
generated redo logs and can be rolled back before you
commit the transaction, Where as the truncate is used to
remove all the data in the table. Once you execute this
command u can not rollback this transaction.and commit is
not required for the truncate statement

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1047

---

what is grd?

1097

---

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

2109

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1072

---

What is fill factor? : sql server DBA

1252

---

What is transparent data encryption? : sql server DBA

1195

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2043

---

What are statistics, under what circumstances they go out of date, how do you update them?

2253

---

how can you communicate with operating system files from oracle?

1051

---

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?

2502

---

what are the performance views in an oracle rac environment?

1055

---

how can you process messages in order asynchronously?

976

---

how can you record information about current session?

1049

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2299

---

what is a user-defined lock?

1066

---