Answer Posted / suman

DROP USER USERNAME CASCADE;

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

2645

---

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

936

---

What the different topologies in which replication can be configured? : sql server DBA

1182

---

what is the use of recording information about current session?

997

---

what is a user-defined lock?

986

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1032

---

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

1048

---

what is asm?

996

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

2188

---

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

1923

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4290

---

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

1887

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1190

---

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

1116

---

What is the difference between clustered and non-clustered index? : sql server DBA

1027

---