Answer Posted / suman

DROP USER USERNAME CASCADE;

what are the differences of where and if in SAS?

2254

---

what is asm?

1116

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2524

---

What is dcl? : sql server DBA

1323

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2037

---

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.

2352

---

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

1166

---

what do you understand by fine-grained auditing?

1105

---

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

1036

---

What happens on checkpoint? : sql server DBA

1143

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4479

---

What is a system database and what is a user database? : sql server DBA

1318

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1998

---

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

2312

---

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

1221

---