Answer Posted / suman

DROP USER USERNAME CASCADE;

suppose you want to audit specific activities on sensitive data. How can you achieve that?

986

---

how can you create a user-defined lock?

999

---

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

1191

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1178

---

what is asm?

1026

---

What are the recovery models for a database? : sql server DBA

1115

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1184

---

how to restore files with rman?

2284

---

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

1078

---

how can a session indicate its interest in receiving alerts?

1030

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2430

---

how can you schedule a job in database?

1095

---

what is grd?

1072

---

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.

2557

---

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

1960

---