Does oracle partitioning improve performance?

0 Answers  

---

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

2 Answers   Wipro,

---

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers   Wipro,

---

Define 'view' advantage ?

2 Answers   AZTEC, TCS,

---

what are the things that you consider while creating indexes on partitioning tables?

1 Answers  

---

Is the After report trigger fired if the report execution fails ?

0 Answers   Oracle,

---

How remove data files before opening a database?

0 Answers  

---

Please explain compound trigger in oracle?

0 Answers  

---

What is Index Cluster ?

2 Answers  

---

how to get count of tables in particular database in Oracle?

3 Answers  

---

What privilege is needed for a user to query tables in another schema?

0 Answers  

---

how to find count rows in table without count function?

3 Answers   Oracle,

---