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 is a user-defined lock?

0 Answers   Oracle,

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

What happens on checkpoint? : sql server DBA

0 Answers  

---

Name a tablespace automatically created when you create a database.

5 Answers  

---

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

---

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,

---

what are the differences of where and if in SAS?

0 Answers  

---

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

0 Answers  

---

How many memory layers are in the shared pool?

3 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

what is ora 600?

1 Answers  

---

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

1 Answers   Cap Gemini, iGate,

---