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
How large is it preferred to configure the data volumes of a sap maxdb database?
What are indexes used for?
Explain internal table?
Explain commit?
Is the primary key for sap maxdb also stored in a separate index-b* tree?
Explain the interfaces supported by sap db?
Explain its?
Differentiate between r3trans and tp in sap-dba.
What are the drawbacks of sap db?
Why may it take a long time until a task is available again after you cancel the user task to cancel the creation of an index?
How are locks on joins handled?
How should the database parameter maxcpu be set for dual core cpus?
Diferrentiate between layers and routes.
What is rman. Can it be used for database recovery and backup? If yes, how?
Is a shared lock assigned to each data record of the table during a full table scan as long as the query is running?