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

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2346

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2685

---

What is the default port no on which sql server listens? : sql server DBA

1212

---

what are the differences of where and if in SAS?

2249

---

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

1265

---

which background process invoke at the time of upgradation tell me???

2778

---

what do you understand by fine-grained auditing?

1102

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

1036

---

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.

2211

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1162

---

what functionality does oracle provide to secure sensitive information?

1048

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1160

---

What is the default fill factor value? : sql server DBA

1181

---

how can a session indicate its interest in receiving alerts?

1091

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2215

---