Answer Posted / suman

we have to create any user in system level By default we
have 8 prives that is
create table
create index
create sysnonims
create view
etc......
sys>desc v$session_prives;

how can you implement fine-grained auditing?

1135

---

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

1105

---

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

992

---

What would you do with an "in-doubt" distributed transaction?

1885

---

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

1043

---

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

2228

---

What is fill factor? : sql server DBA

1247

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1022

---

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.

2565

---

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2091

---

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

1208

---

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

2199

---

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

1157

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2811

---

how can you find out if a table can be redefined?

1011

---