Answer Posted / feroz

creating user at OS level wont get any privileges
question is not clear first of all?
how come a DBA will be able to create a user
we cann't create users at DB2 level

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?

1988

---

What are the different types of indexes available in sql server? : sql server DBA

1213

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1738

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1765

---

what functionality does oracle provide to secure sensitive information?

1005

---

Query processing is slow(eg select query)how will u solve that

7930

---

who owns the operating system files created by the utl_file package?

1083

---

How would you extract DDL of a table without using a GUI tool?

2495

---

Explain about your sql server dba experience? : sql server DBA

1095

---

What are the steps you will take to improve performance of a poor performing query?

2855

---

What the different types of replication and why are they used? : sql server DBA

1180

---

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

4434

---

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

1113

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1089

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

1002

---