SAP NetWeaver AS ABAP Administration

Database Layer & DB Administration

12 flashcards · answers and review in the app

What is watched in transaction DB02, and why do missing indexes matter?
What is a table pool in the SAP data dictionary?
Why must optimizer statistics be refreshed regularly, and how often?
What does the DBA Cockpit (DBACOCKPIT) provide, and how does it avoid logging on to each database?
What is a table cluster, and what kind of data is it common for?
How is native (manufacturer-specific) SQL used in ABAP, and why is it restricted?
Why does a missing database backup risk data loss, and where are completed backups listed?
What happens to pooled and cluster tables when an SAP system runs on SAP HANA / S/4HANA?
What does the System Administration Assistant (SSAA) do, and what superseded it?
Where are recurring database tasks scheduled, and what kinds of tasks?
Which SQL interface do SAP work processes normally use, and how does it reach the database?
What is the SAP NetWeaver Administrator (NWA), and what did it replace?
Database Layer & DB Administration (SAP NetWeaver AS ABAP Administration) · KnowCard