Answer / Indresh Kumar

The GROUP BY clause is used in SQL queries to group rows that have the same values in specified columns. It is typically used when performing aggregate functions such as SUM, AVG, MIN, MAX, or COUNT on the result set.

Please explain oracle left join with an example?

1 Answers  

---

What are the differences between a sys and system user and what are the extra privileges available to the sys user?

1 Answers   Wipro,

---

How to create a new oracle data file?

1 Answers  

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1 Answers  

---

In oracle there is column command, how will you explain that?

1 Answers   Aricent,

---

What is Partitions in Table ?

2 Answers   Atiric Software,

---

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

2 Answers   Microsoft,

---

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  

---

what are stored procedures?

7 Answers   TCS, Wells Fargo,

---

What privilege is needed for a user to connect to oracle server?

1 Answers  

---

what is cartesian product?

2 Answers  

---

What happens to the current transaction if the session is ended?

1 Answers  

---