Answer / Amrit Kumar

Yes, it is possible to create a table in SAP MaxDB without referring to data elements. This can be achieved using the CREATE TABLE AS SELECT (CTAS) statement:nnCREATE TABLE new_table AS SELECT column1, column2... FROM old_table;nThis creates a new table with the same structure as the old table. The column names are automatically assigned based on the selected columns from the old table.

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  

---

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

1 Answers  

---

Explain the drawbacks of sap db?

1 Answers  

---

What is rman. Can it be used for database recovery and backup? If yes, how?

1 Answers  

---

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

1 Answers  

---

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

1 Answers  

---

Which isolation levels are available?

1 Answers  

---

Explain transparent table?

1 Answers  

---

What is the isolation level?

1 Answers  

---

How alert messages are created?

1 Answers  

---

Can additional cpus be assigned to the database in live operation?

1 Answers  

---

What are the interfaces supported by sap db?

1 Answers  

---