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"

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

how can you implement fine-grained auditing?

0 Answers   Oracle,

---

---

Hot backup procedure?

2 Answers  

---

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.

0 Answers  

---

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---

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

0 Answers  

---

What are the recovery models for a database? : sql server DBA

0 Answers  

---

Explain the difference between a data block, an extent and a segment.

2 Answers  

---

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

---