Answer / hr@tgksolutions.com

The components of the physical database structure are:
• Greater than equal to two redo log files.
• Greater than equal to one control file.
• Greater than equal to one data file.

What is the difference between 10g OEM and 11g OEM?

1 Answers   MCN Solutions,

---

What is raw datatype?

1 Answers  

---

Please explain oracle left join with an example?

1 Answers  

---

What is a shared pool?

1 Answers  

---

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.

3 Answers  

---

Can multiple cursors being opened at the same time?

1 Answers  

---

What is a Synonym ?

3 Answers  

---

How is it different from a normal table?

1 Answers  

---

Explain oracle data types with examples?

1 Answers  

---

Do you know about aggregate functions? What is row num function? Can it be used all databases?

1 Answers   Bravura Solutions, Cap Gemini,

---

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  

---

What are the types of partitions in oracle?

1 Answers  

---