What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

How can you rebuild an index?

6 Answers  

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

---

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

---

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

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.

0 Answers  

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

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

0 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---