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 new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1106

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1104

---

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

1042

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2678

---

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.

2562

---

What is transparent data encryption? : sql server DBA

1190

---

what is ora 24313?what is the procedure to exclude that error?

2568

---

What are the different sql server versions you have worked on? : sql server DBA

1009

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1973

---

What happens on checkpoint? : sql server DBA

1092

---

What authentication modes does sql server support? : sql server DBA

1214

---

How would you go about verifying the network name that the local_listener is currently using?

3215

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2063

---

Where would you look for errors from the database engine?

2848

---

how can you communicate with operating system files from oracle?

1047

---