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?
1Situation: you need a create a table with fields without referring to data elements. Is it possible? If yes, how?
1
Differentiate between r3trans and tp in sap-dba.
Explain spool buffer.
How large is it preferred to configure the io buffer cache?
Is the primary key for sap maxdb also stored in a separate index-b* tree?
Differentiate between open sql and native sql.
What are the differences between “insert”, “update” and “modify”.
Explain internal table?
Which lock objects do exist in sap maxdb?
Explain rman. Can it be used for database recovery and backup? If ye, how?
what are the principles of relational model.
Is a shared lock assigned to each data record of the table during a full table scan as long as the query is running?
What is the select statement to read data into internal tables?
What tools are used in sap implementation? How alert messages are created?
Which isolation levels are available?
Do I need to change a data volume configuration which does not correspond to the recommendations of this note?