Answer / kittu_chintu2005

Create a file structure @ oracle level by issuing the statement "create directory dpump_dir1 as '/disk01/oradata/mine/dpump'';" "grant read, write to user1, user2;"
@ OS "level mkdir -p /disk01/oradata/mine/dpump"

And then issue the statement @ OS level "expdp directory=dpump_dir1 dumpfile=xxxxx.dmp"

What view would you use to look at the size of a data file?

3 Answers  

---

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

---

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

---

how can you schedule a job in database?

0 Answers   Oracle,

---

how can you record information about current session?

0 Answers   Oracle,

---

---

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

1 Answers   Cap Gemini, iGate,

---

How can you rebuild an index?

6 Answers  

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

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

0 Answers  

---

What are the commands used in dcl? : sql server DBA

0 Answers  

---