SAP MaxDB Interview Questions
Questions Answers Views Company eMail

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

Must I carry out an update statistics for indexes?

1

Must locks be explicitly requested or is implicit locking possible?

1

Does maxdb support the use of external backup tools?

1

What is the central scheduling calendar?

1

What is a shared lock?

1

What do I have to bear in mind with regard to views when using hints?

1

Why must sql locks be set on database objects?

1

How large is it preferred to configure the io buffer cache?

1

What is the isolation level?

1

What is an exclusive lock?

1

Can I create several indexes simultaneously?

1

How can I speed up the index build?

1

Is there any limited number of simultaneous sessions of a sap maxdb database?

1

What is the technical structure of indexes?

1


Post New SAP MaxDB Questions

Un-Answered Questions { SAP MaxDB }

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

1


How are locks on joins handled?

1


What tools are used in sap implementation?

1


How is data accessed using an index?

1


What is a shared lock?

1






Will applications using sapdb have to be open source as well?

1


Explain roll back?

1


Which lock objects do exist in sap maxdb?

1


Is it recommended to configure all data volumes in the same lun?

1


Explain the principles of relational model.

1


Situation: you need to move data or databases between servers. What steps will you take?

1


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

1


What are the main features of sap db?

1


What do I have to bear in mind with regard to views when using hints?

1


Differentiate between 'insert', 'update' and 'modify'.

1