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"

Name three advisory statistics you can collect.

1 Answers  

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

Explain CREATE DATABASE syntax?

2 Answers  

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

Why would you use sql agent? : sql server DBA

0 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

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

3 Answers  

---

What command would you use to create a backup control file?

2 Answers  

---

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

What is dcl? : sql server DBA

0 Answers  

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

---