Answer / 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.

Datapump backup steps?

1 Answers  

---

What is a correlated sub-query? : sql server DBA

0 Answers  

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,

---

Explain an ORA-01555

2 Answers  

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

How do you resize a data file?

2 Answers  

---