Answer / Atul Pratap Singh

In SAP MaxDB, the SELECT statement is used to retrieve data from tables and views. It reads data from the database and stores it temporarily in an Internal Table (ITab). The basic syntax is as follows:nnSELECT column1 [,column2...] FROM table_name WHERE condition;nFor example: SELECT name, age FROM employees WHERE age > 30; This will select the 'name' and 'age' columns from the 'employees' table where the 'age' is greater than 30 and store the results in an internal table.

What advantage does a backup using the maxdb backup tool offer compared to a file system backup?

1 Answers  

---

Explain 'group by' in select statement

1 Answers  

---

Can an index become larger than the table to which it belongs?

1 Answers  

---

Differentiate between r3trans and tp in sap-dba.

1 Answers  

---

How alert messages are created?

1 Answers  

---

Situation: 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  

---

Is the primary key for sap maxdb also stored in a separate index-b* tree?

1 Answers  

---

Where can you find the information about the configuration of sap maxdb volumes of the type "file"?

1 Answers  

---

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

1 Answers  

---

Explain rman.

1 Answers  

---

How can I speed up the index build?

1 Answers  

---

Does the sap maxdb use consistent reading?

1 Answers  

---