Answer Posted / sanopera

What questions might be they ask in managerial round in
capgemini. for job position oracle apps dba. I have cleared
the technical round and moved to manager round.

thanks for urgent reply in advance.

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

---

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

1242

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2527

---

what is a user-defined lock?

1038

---

What authentication modes does sql server support? : sql server DBA

1191

---

when does an alert gets signaled?

1020

---

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

1064

---

how can you record information about current session?

1028

---

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

1059

---

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?

2072

---

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

2835

---

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.

1706

---

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

2212

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2014

---

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

1159

---