Answer / ramesh

Grant Create session to <UserName>

Answer / sweta

Grant connect,create session to <username>;

Answer / kunal sain

grant connect,resource to username

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

1 Answers  

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,

---

What is blocking and how would you troubleshoot it?

1 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,

---

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

3 Answers  

---

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

2 Answers  

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

---

how can you record information about current session?

0 Answers   Oracle,

---

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

3 Answers  

---

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

0 Answers  

---

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,

---

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

---