Answer / Vishal Kumar

'GROUP BY' clause in a SELECT statement is used to group rows that have the same values in one or more specified columns. It allows you to perform aggregate functions like COUNT, SUM, AVG, MAX, and MIN on each group separately.

You raise a new spool request.the spool buffer was already full. What will happen to the request? Where would the request get stored?

1 Answers  

---

Does the data get distributed evenly on all volumes, if a new data volume is added?

1 Answers  

---

Situation: I used "update" command without where clause. What would happen?

1 Answers  

---

Explain spool buffer.

1 Answers  

---

What is data quality in sap.

1 Answers  

---

Is a shared lock assigned to each data record of the table during a full table scan as long as the query is running?

1 Answers  

---

How should the database parameter maxcpu be set for dual core cpus?

1 Answers  

---

How large is it preferred to configure the data volumes of a sap maxdb database?

1 Answers  

---

Explain rman.

1 Answers  

---

You need a create a table with fields without referring to data elements. Is it possible? If yes, how?

1 Answers  

---

Differentiate between open sql and native sql.

1 Answers  

---

What are the differences between support packages and kernel upgrade.

1 Answers  

---