SAP Certified Technology Associate – System Administration (Oracle DB) with SAP NetWeaver 7.0

Posted on Jan 20, 2025 in Computing and Communications

SAP Certified Technology Associate – System Administration (Oracle DB) with SAP NetWeaver 7.0 (C_TADM51_70)

Version: 5.0

Question 1

Oracle database offers different types of indexes. Which are valid index types? (Choose two.)

  • A. Bitmap index
  • B. Unique master index
  • C. Dictionary index
  • D. Balanced tree (B*tree) index

Answer: A, D

Question 2

Regarding the object, TemSe, of the SAP spool system, which of the following statements are correct? (Choose two.)

  • A. TemSe stores, for example, spool data.
  • B. TemSe always stores the spool requests in the database.
  • C. The instance parameter “rspo/store_location” determines where TemSe data is stored.
  • D. TemSe is always an operating system file.

Answer: A, C

Question 3

Which tools in the SAP NetWeaver AS 7.00 ABAP and Java Stack are responsible for the registration process in the System Landscape Directory (SLD)? (Choose two.)

  • A. The whole mechanism to register an ABAP based SAP system is event triggered. Once a change in the configuration happens, a background job informs the SLD.
  • B. The transaction RZ21 allows the configuration of the SLD connection.
  • C. SAP systems based on AS Java can register to the SLD using the SLD Data Supplier Service in Visual Administrator.
  • D. The main ABAP transaction to inform the SLD is RZ70. The SAP gateway is involved.
  • E. SAP systems based on AS Java cannot register to the SLD.

Answer: C, D

Question 4

You are using the profile maintenance (transaction code RZ10) to configure profiles and profile parameters of an AS ABAP+Java based SAP system. Which profiles of the system you can maintain in RZ10?

  • A. You can maintain the default profile as well as the start and instance profiles of the ABAP+Java application servers. However, you cannot maintain the start and instance profiles of the Java central services instance.
  • B. Only the default profile and the start profiles can be maintained, because the instance profiles contain AS Java relevant parameters which cannot be maintained by the ABAP programs used in transaction RZ10.
  • C. All profiles (start profiles, instance profiles, default profile) of the system can be maintained.

Answer: A

Question 5

In SAP NetWeaver 7.0, several components need the ABAP and the JAVA stack. The customer has decided to install both stacks in one database. A default schema user is created for each stack. In which Oracle database table are these users physically stored and how are they named? The SAP is LNX and the instance number is 03. (Choose two.)

  • A. Table dba_users; JAVA schema owner: SAPDB
  • B. Table dba_user; Java user: ORALNXDB
  • C. Table users; ABAP and JAVA Schema owner: SAPLNX
  • D. Table dba_users; ABAP schema owner: SAP
  • E. Table dba_user; ABAP schema owner: ORALNX

Answer: A, D

Question 6

Which of the following are repository objects in an AS ABAP-based SAP system? (Choose two.)

  • A. Screens (Dynpros)
  • B. Buffer areas
  • C. Programs
  • D. Client-independent customizing settings

Answer: A, C

Question 7

Which data sources are supported by the User Management Engine (UME) of AS Java? (Choose three.)

  • A. A UDDI provider
  • B. The database of the AS Java
  • C. A client of an AS ABAP based SAP system
  • D. A directory server (LDAP)
  • E. A file (also called secure store)

Answer: B, C, D

Question 8

The Integrated Log Viewer is presented as a service of SAP NetWeaver AS Java. It provides runtime control for working with log messages. Which of the following statements about the Integrated Log Viewer is true?

  • A. The Integrated Log Viewer can merge logs within an SAP NetWeaver AS Java instance.
  • B. The Integrated Log Viewer provides options for log and trace configuration. You can add new locations and categories and change the configuration of the existing ones.
  • C. Log Viewer is the right tool for setting and modifying Severity levels.

Answer: A

Question 9

Which of the following statements is correct regarding transport domains and transport groups in ABAP-based SAP Systems? (Choose two.)

  • A. All SAP Systems within one transport group have a common transport directory.
  • B. A transport domain consists of the client-independent table TDOM (the transport domain table), into which all transports (exports or imports) in the SAP System are logged.
  • C. All SAP Systems in a transport domain must belong to the same transport group.
  • D. A transport domain can only be set up if more than one application server is installed.
  • E. All SAP Systems within one transport domain have RFC destinations (names beginning with “TMS…”) pointing to the same transport domain controller system.

Answer: A, E

Question 10

The software component SAP ECC 6.0 runs on which of the following?

  • A. SAP NetWeaver Application Server 7.00
  • B. SAP Basis 4.6D
  • C. SAP Web Application Server 6.40
  • D. SAP NetWeaver Application Server 7.10

Answer: A

Question 11

Which of the following statements are correct regarding the use of the lock table in an SAP system based on AS ABAP with several instances? (Choose two.)

  • A. The lock table is located in the shared memory of the message server, and can be accessed by all work processes through the message server.
  • B. The lock table is located in the shared memory of the computer where the enqueue work process is running.
  • C. The lock table is a transparent table located in the SAP system, and the contents can be displayed using the ABAP dictionary.
  • D. If a dialog work process from another instance (without enqueue work process) requests a lock, the lock operation is performed by the enqueue work process on the central instance.

Answer: B, D

Question 12

Which of these statements regarding clients in ABAP-based SAP Systems are true? (Choose two.)

  • A. Although the system change options (transaction SE06) are set to ‘modifiable’, you can restrict changes to repository objects by the client change options (transaction SCC4).
  • B. You should not allow the changing of the cross-client customizing from within a sandbox client on the development system.
  • C. If the system change options (transaction SE06) are set to ‘not modifiable’, but the client change options (transaction SCC4) are set to ‘changes to repository allowed’, you can change repository objects from within this client.
  • D. There cannot be more clients in a development system than in a productive system, on the same system landscape.
  • E. If you want to use more than one productive client in a productive system, you have to switch to the extended transport control.

Answer: A, B

Question 13

During the installation of an SAP ECC 6.0 system, which of the following components can be installed in a separate installation procedure? (Choose two.)

  • A. The central instance
  • B. The database instance
  • C. The message server

Answer: A, B

Question 14

Which of the following functions are offered by CCMS-based monitoring (transaction RZ20)? (Choose two.)

  • A. Monitoring different attributes of different SAP systems using a single monitor.
  • B. Monitoring different attributes of all instances of one SAP system using a single monitor.
  • C. By default, all alerts in transaction RZ20 generate corresponding mail notifications.

Answer: A, B

Question 15

When implementing Central User Administration (CUA), which of the following do you need to consider? (Choose two.)

  • A. You should define logical systems, using the naming convention CLNT###, where signifies your system ID and ### signifies a client number. You need to create RFC connections using the same naming convention.
  • B. You have to decide either you want to use CUA or you want use a directory server for user management. You cannot use both at the same time for the same client.
  • C. CUA uses ALE to distribute user master data.
  • D. CUA can only be set up between two clients.
  • E. Authorization profiles generated by role definitions are distributed along with role definitions.

Answer: A, C

Question 16

You have properly configured an SAP Web Dispatcher. Now, you want to log on to the Web Administration interface. Where is the logon information (user, password) stored?

  • A. In a file located on the host of the SAP Web Dispatcher
  • B. In a file located on the host of the SAP NetWeaver Application Server
  • C. For AS ABAP and AS ABAP+Java: in the ABAP user management. For AS Java: in the AS Java user management (UME).
  • D. In an LDAP server

Answer: A

Question 17

When performing modification adjustments for the ABAP Dictionary, using transaction SPDD (Modification Adjustment Dictionary) during an SAP System upgrade of the development system, which of the following statements are true? (Choose two.)

  • A. Objects which may need to be adjusted in transaction SPDD (Modification Adjustment Dictionary) are, for example, domains, data elements, and table definitions.
  • B. Objects which may need to be adjusted in SPDD (Modification Adjustment Dictionary) are, for example, views and reports.
  • C. Modification adjustments with transaction SPDD (Modification Adjustment Dictionary) are performed during the upgrade, to avoid data loss when customers have changed the standard ABAP Dictionary objects.
  • D. Customer-developed reports in the customer name range are adjusted with transaction SPDD during the upgrade.
  • E. Modification adjustments for the ABAP Dictionary are performed after the upgrade.

Answer: A, C

Question 18

Which of the following statements is correct when using external commands for background processing in SAP systems based on AS ABAP?

  • A. The only way to execute operating system commands from a background job is by using external commands.
  • B. Only background users can execute external commands.
  • C. You can execute operating system commands from a background job by using external programs or external commands.

Answer: C

Question 19

When using the transaction SCU0 (Cross-System Viewer) and the transaction SM30 (Maintain Table Views) to compare clients, which of the following statements are correct? (Choose three.)

  • A. Table content can be compared between SAP R/2 and SAP ECC Systems.
  • B. Customizing data can be adjusted across clients using transaction SM30 (Maintain Table Views).
  • C. Table content can be compared between different clients in different SAP Systems.
  • D. Table content can be compared between different clients in the same SAP System.
  • E. Table content can only be compared directly on the database level.

Answer: B, C, D

Question 20

Which of the following statements regarding the Transport Management System (TMS) are true? (Choose three.)

  • A. For TMS to work, the user ID “TMSADM” is automatically set up on the Transport Domain Controller in client 000.
  • B. For TMS to work, the user ID “TMSADM” must be created manually in transaction SU01 (User Maintenance), in client 000 of each SAP System belonging to the same transport domain.
  • C. TMS automatically creates RFC destinations for each SAP System, which can be displayed using transaction SM59 (Display/Maintain RFC Destinations).
  • D. For each client in each SAP System, TMS creates RFC destinations which can be displayed using transaction SM59 (Display/Maintain RFC Destinations).
  • E. During the configuration of the transport domain controller, transport domain control data is written to the file DOMAIN.CFG in the transport directory (subdirectory “bin”).

Answer: A, C, E

Question 21

Which of the following statements is correct with regard to the OPS$connect connect mechanism? (Choose two.)

  • A. OPS$connect authorization is required for all users connecting to the Oracle database.
  • B. OPS$connect enables the R/3 saposcol process to communicate and exchange data with the Oracle database.
  • C. OPS$connect is an Oracle command enabling whoever executes it to administer the database without using the oracle tool SQL*Plus.
  • D. BR*Tools use the OPS$connect by default to connect to the database.
  • E. OPS$connect authorization allows an operating system user to connect to the database without being prompted for a password.

Answer: D, E

Question 22

How can you determine the patch level of your AS ABAP-based SAP system – concerning the current patch level of the applied Support Packages? (Choose two.)

  • A. You can access this information by using the information that can be found under the menu path “System -> Status”.
  • B. Calling “disp+work -v” or “dw -v” (depending on operating system) will give you this information.
  • C. You can find this information by using transaction “PATCH”.
  • D. You can find that information within transaction “SPAM”.

Answer: A, D

Question 23

Which features are created automatically once you define a transport domain controller in an (ABAP-based) SAP landscape? (Choose four.)

  • A. The TMS configuration is stored in the database and the file system.
  • B. The RFC destinations required for the TMS are generated.
  • C. The transport profile for the transport control program tp is generated in the file system.
  • D. The transport profile for the transport control program tp is generated in the database.
  • E. The user TMSADM is created.

Answer: A, B, C, E

Question 24

Which of the following statements regarding post-installation activities for SAP ECC 6.0 are true? (Choose two.)

  • A. The installation check verifies the completeness of the installation.
  • B. Additional space in the database is needed to generate ABAP loads of programs, function modules, and classes; using transaction SGEN.
  • C. The newest Support package level is available with the SAP ECC 6.0 installation. Only the SAP executables (kernel) and the database must be patched after the installation.
  • D. SAP recommends creating the first client after the installation using client copy profile SAP_CUST. The source client for the client copy should be client 066.

Answer: A, B

Question 25

Which of the following is true when creating new clients within an SAP System based on AS ABAP (for example, SAP ECC)?

  • A. Log files indicating the success of a new client creation are stored in the home directory of the user initiating the copy.
  • B. Customizing and repository objects from a source client are automatically copied to the new client using the client copy tool.
  • C. The client transport tool can be used to transfer the same source client, simultaneously, from one SAP System to multiple other SAP systems in a single action.
  • D. The client copy can be accelerated by using several dialog work processes in parallel.
  • E. Remote client copies generate large data files at the operating system level.

Answer: D

Question 26

Which steps have to be performed before data can be synchronized between an AS ABAP and a directory server? (Choose three.)

  • A. Creation of an RFC destination of type “S” pointing to the directory server
  • B. Creation of an SAP user (type “system”) that is used by the directory server to connect to the SAP system
  • C. Creation of an RFC connection of type “T” to the LDAP connector
  • D. Maintenance of host name, port number and product name of the directory server inside the SAP system
  • E. Definition of a system user that is used by the SAP system to log on to the directory server

Answer: C, D, E

Question 27

Which of the following are possible assignments when setting up output devices in SAP systems based on AS ABAP? (Choose two.)

  • A. An output device must be assigned to a specific spool work process.
  • B. An output device can be directly assigned to a physical spool server.
  • C. An output device can be directly assigned to a logical spool server.
  • D. An output device does not need to be assigned to a spool server.

Answer: B, C

Question 28

Which of the following process start sequences can typically be observed when starting an SAP system based on AS Java 7.0? Note that the specified sequence does not need to be “complete”, only the chronological sequence of the selected processes is considered here.

  • A. 1. Database Process(es), 2. Dispatcher, 3. Enqueue Server
  • B. 1. Enqueue Server, 2. Server Process, 3. Database Process(es)
  • C. 1. Database Process(es), 2. Message Server, 3. Dispatcher

Answer: C

Question 29

SAP offers a vast range of products for companies of all sizes. Which of the following are SAP offerings? (Choose four.)

  • A. SAP Business All-in-One
  • B. SAP Business One-for-All
  • C. SAP Business ByEvolution
  • D. SAP Business One
  • E. SAP Business ByDesign
  • F. SAP Business Suite

Answer: A, D, E, F

Question 30

Which statement regarding Local Printing with SAP NetWeaver AS ABAP is correct?

  • A. If you want to configure Local Printing for an output device, you have to choose access method L or C, depending on the operating system.
  • B. If you want to configure Local Printing for an output device, you have to choose access method L for any operating system.
  • C. If you want to configure Local Printing for an output device, you have to choose access method U for UNIX operating systems.

Answer: A

Question 31

What kind of requests can be handled by the Internet Communication Manager (ICM)? (Choose three.)

  • A. The ICM can handle requests that are intended for the integrated ITS.
  • B. The ICM can handle requests that are intended for the Java-Stack of the instance.
  • C. The ICM can handle requests for the ABAP dispatcher that calls Business Server Pages (BSPs).
  • D. The ICM can handle requests from the standalone SAP ITS.

Answer: A, B, C

Question 32

Which options do you have for selecting transport requests to be imported? (Choose four.)

  • A. You can filter transport requests from a certain project and import them together in one step (provided that you have activated the CTS functionality in transaction SPRO_ADMIN).
  • B. You can import a single transport request into several SAP Systems, for example, QA1 and QA2, in one step.
  • C. You can select several individual transport requests to be imported in one step.
  • D. Depending on the TMS settings, you can use the ‘import all’ button to import all importable requests from the import queue in one step.
  • E. You can select a single transport request for import.

Answer: A, C, D, E

Question 33

Which of the following statements about the gateway process of an SAP system are correct? (Choose three.)

  • A. The gateway process is able to handle communication between different SAP systems and external programs.
  • B. Only the central instance of an SAP system hosts a gateway process.
  • C. One gateway process runs in each instance of the SAP system.
  • D. Remote Function Calls (RFC) are handled by the gateway process of the SAP system.

Answer: A, C, D

Question 34

During an online database backup, which files must be saved to ensure that the Oracle database can be restored to an internally consistent state?

  • A. The tablespace data files, the database control file, and the database parameter file
  • B. Oracle online redo log files and the database control file
  • C. The Oracle executables, the database parameter file, and the tablespace data files
  • D. Tablespace data files, the database control file and all database redo logs written during the online backup
  • E. Offline redo log files, the database control file, and the Oracle executables

Answer: D

Question 35

When working with property variants in CCMS monitoring, which of the following statements are true? (Choose two.)

  • A. Property variants cannot contain more than 99 performance attributes and their settings.
  • B. For each client, you can choose another property variant as the active variant.
  • C. The property variant “SAP_DEFAULT” is the parent variant for property variant “*”.
  • D. Property variants can be activated manually.

Answer: C, D

Question 36

Which settings are necessary for activating the integrated ITS?

  • A. Set the profile parameter rdisp/optimize_web_app to 1.
  • B. Set the profile parameter itsp/enable to 1.
  • C. Configure the HTML cache of the SAP NetWeaver AS Java.
  • D. You need to deploy the necessary HTML templates on the operating system level.

Answer: B

Question 37

In Oracle 10g, a tablespace SYSAUX is created automatically by the installation tool SAPINST. Which of the following statements is true? (Choose two.)

  • A. The most important purpose of the SYSAUX tablespace is to reduce the load on the system tablespace and additionally simplifying the administration.
  • B. The SYSAUX is a temporary help tablespace for the system tablespace. It provides a central space for necessary additional metadata outside of the system tablespace. Some components and products that previously used the system tablespace now use the SYSAUX tablespace.
  • C. The tablespace SYSAUX contains a predefined set of SAP tables. In the creation of the database, they are copied into the system tablespace in one step, instead of creating every table step by step.
  • D. The tablespace SYSAUX is needed by the installation tool SAPINST itself, and contains temporary Oracle dictionary information. It significantly reduces the installation time of the R3LOAD phase.

Answer: A, B

Question 38

Oracle database release 10g is able to use new database statistic features for tables and index. Which statement regarding CBO (Cost-based optimizer) and RBO (Rule-based optimizer) is true?(Choose three.)

  • A. In Oracle 10g, both CBO- and RBO-based index statistics can be used simultaneously.
  • B. Database statistics can be managed automatically in Oracle 10g. This is implemented in the database as the dbms_scheduler job GATHER_STATS_JOB. However, this method is not yet supported and is deactivated to avoid conflicts with the brconnect methods.
  • C. Oracle 10g only supports CBO, while the RBO is not supported anymore.
  • D. As of Oracle 10g, you are required to create statistics for the Oracle dictionary as well.

Answer: B, C, D

Question 39

From the screenshot, find the machine on which the database for this system is running. The associated logon was performed in English.

  • A. This question cannot be answered with the information available.
  • B. 562
  • C. twdf1318
  • D. twdf1318_DEV_… (Unfortunately, the rest cannot be identified from the screenshot provided)
  • E. DEV

Answer: C

Question 40

Which of the following statements regarding implementation of ABAP support packages are correct? (Choose two.)

  • A. Support packages can be implemented in an arbitrary order.
  • B. Each ABAP software component, like SAP_BASIS or SAP_APPL, has its own support packages.
  • C. With ABAP support packages, existing functions can be patched.

Answer: B, C

Question 41

While setting up the RFC connections for a Central User Administration (CUA) in an AS ABAPbased SAP system, you are required to observe which of the following naming conventions? (Choose two.)

  • A. The required RFC connections have to be named identically to the logical system they are connecting to.
  • B. The required RFC connections have to be named in capital letters.
  • C. The users that are used for the RFC connections for the CUA need to be of type “SYSTEM” with authorization SAP_ALL.
  • D. The naming convention recommended by SAP for both RFC connections and logical system names, is the following: “CUA_”, for example, CUA_DEV.
  • E. You need to use trusted RFC connections for setting up a CUA environment.

Answer: A, B

Question 42

For an AS ABAP+Java system, the SAP Web Dispatcher communicates with which of the following?

  • A. Both the ABAP and Java message server
  • B. The Java message server
  • C. The ABAP message server

Answer: C

Question 43

Which statement is correct for both of the tools Config Tool and Visual Administrator?

  • A. All configuration settings require a restart of the system.
  • B. Only configuration settings made globally require a restart of the system.
  • C. You have the possibility to maintain configuration settings globally, for all dispatcher nodes of the system at once, or locally for each specific node.

Answer: C

Question 44

You would like to connect two SAP systems using RFC. RFC communication should be possible from each client of the calling system and should connect to three different clients of the target system. What do you need to consider? (Choose two.)

  • A. No work is required in the remote system.
  • B. In this scenario, you need to define three RFC connections of type “3” within each client of the calling SAP system.
  • C. For the scenario described, you will need to define three RFC connections in the calling system.
  • D. The RFC connection to be defined needs to be of type “M”, because multiple clients should be addressable in the target system.

Answer: A, C

Question 45

Which statements regarding user management in an AS ABAP-based SAP system are correct? (Choose two.)

  • A. SAP recommends to assign authorization profiles via the assignment of roles to the user master data.
  • B. A user with user type “System” cannot log on to the system by using the SAP GUI.
  • C. If you forgot your password you can use the “User -> New Password” menu path on the logon screen to notify the system administrator that you are requesting a new password.

Answer: A, B

Question 46

You want to configure the automatic data transfer from an SAP System Landscape Directory (SLD) to the SAP Solution Manager system. Which of the following configuration steps are necessary? (Choose two.)

  • A. On the SAP Solution Manager system, you need to create a trusted RFC connection of Type “3” to the SLD.
  • B. On the SLD system, you need to configure the JCo RFC Provider Service in Visual Administrator.
  • C. On the SAP Solution Manager system you need to schedule a periodic data transfer job (Job LANDSCAPE_FETCH). This can be done in transaction SMSY_SETUP.
  • D. On the SLD system, you need to trigger an event that starts the data transfer to the SAP Solution Manager system (event START_TRANSFER).

Answer: B, C

Question 47

When installing an SAP ECC 6.0 system (leaving all settings to default), which of the following ports are used? (Choose two.)

A. Port 500NN for HTTP communication with the Java dispatcher, where NN stands for the instance number.

B. Port 32NN for communication to the ABAP dispatcher, where NN stands for the instance number.

C. Port 36NN for communication with the ABAP message server, where NN stands for the central instance number.

Answer: B, C

QUESTION NO: 48

When using SAP NetWeaver Administrator (NWA) for configuration of an AS ABAP+Java based system, which statement is correct?

A. In SAP NetWeaver Administrator you can display the Java Virtual Machine (JVM) properties.

B. In SAP NetWeaver Administrator you can maintain Logon Groups for the AS ABAP.

C. In SAP NetWeaver Administrator you can maintain profile parameters for the instance profiles.

Answer: A

QUESTION NO: 49

Business APIs (BAPIs) can be used to trigger and execute transactions in an SAP landscape. Which of the following statements regarding BAPIs are correct? (Choose two.)

A. Data exchange by BAPI can only be done by asynchronous RFC

B. BAPI communication requires a connection to a central LDAP directory server

C. BAPIs are specialized remote function calls

D. BAPIs can be used for connecting external software to SAP systems

Answer: C, D

QUESTION NO: 50

You have installed an AS ABAP+Java system and the default UME configuration was not changed. Which of the following statements are true (for one client of the AS ABAP system)? (Choose two.)

A. ABAP roles appear as UME groups.

B. The assignment of ABAP users to ABAP roles appears as the assignment of UME users to UME groups.

C. The assignment of ABAP users to ABAP groups appears as the assignment of UME users to UME roles.

D. ABAP authorization profiles appear as UME security roles.

Answer: A, B

QUESTION NO: 51

The figure shows the ABAP short dump of an aborted transaction in an SAP system. Which of the following statements are true? (Choose two.)

A. The error was caused by a transaction which exceeded the maximum runtime in a dialog work process of an SAP system.

B. The error was caused by a transaction which exceeded the maximum runtime in a background work process of an SAP system.

C. The error can be avoided by reducing the memory usage of the respective transaction in the SAP system.

D. The error was caused by a transaction in the SAP system which exceeded the extended memory.

E. The error can be avoided by running the respective program in a batch job in the SAP system, if running in background is possible.

Answer: A, E

QUESTION NO: 52

For UNDO tablespaces, which of the following statements are true? (Choose two.)

A. The UNDO tablespace MUST be a dictionary managed tablespace.

B. Undo segments are overwritten first after undo retention time.

C. To avoid a tablespace overflow, the UNDO tablespace can be set to be autoextensible.

D. Transformation of rollback- to undo tablespace can be performed with BRSPACE in a one-step procedure.

E. Storage parameters of all undo segments should be equal.

Answer: B, C

QUESTION NO: 53

Concerning Load Balancing for AS Java, while using SAP Web Dispatcher, which of the following statements are correct? (Choose two.)

A. Transaction SMLG is considered for Load Balancing in AS Java as well as for AS ABAP

B. SAP Web Dispatcher distributes load between different Java instances of one AS Java-based SAP system

C. The dispatcher of an AS Java instance distributes load between the server processes of the local AS Java instance

D. Visual Administrator can be used for defining logon groups for AS Java, those are considered by SAP Web Dispatcher

Answer: B, C

QUESTION NO: 54

Which of the following statements regarding the monitoring of an AS ABAP + Java system are true, when you are using a separate central monitoring system?

A. For monitoring an AS ABAP + Java-based SAP system, you will use the agent SAPCCMSR for monitoring the AS Java.

B. The central monitoring system must be of a higher SAP release of the monitored SAP system.

C. Central monitoring of AS ABAP + Java-based SAP systems can only be carried out using a separate AS ABAP + Java-based SAP system.

D. The central monitoring system must have the System ID “CEN”.

Answer: A

QUESTION NO: 55

Which SAP products use SAP NetWeaver? (Choose three.)

A. SAP R/3 4.6C

B. SAP CRM

C. SAP Business All-In-One

D. SAP ERP

Answer: B, C, D

QUESTION NO: 56

An SAP system’s Oracle database has four online redo logs, also known as database transaction logs. Each online redo log has a mirrored copy. What is the effect of a log file switch?

A. The database switches between writing to the original redo log files and the mirrored redo log files.

B. The database alternates between writing to the online and offline redo log files.

C. The current online redo log is closed and the next online redo log becomes open for writing. The ARCH process is triggered to begin backing up the recently closed redo log.

D. The current online redo log is copied to its mirrored copy, then the next online redo log becomes open for writing.

Answer: C

QUESTION NO: 57

How can you determine the current patch level of your SAP NetWeaver AS Java 7.0?

A. On the operating system level, using ‘java -version’.

B. Within the file java_vers in the work directory from the Central Services Instance of SAP NetWeaver AS Java.

C. Using the System Information application (alias: /sap/monitoring/SystemInfo) of SAP NetWeaver AS Java.

Answer: C

QUESTION NO: 58

What is the name of the program on the operating system level that is used when an ABAP program calls an external program?

A. sapxpg

B. sap_ext_prog

C. disp+work

D. saposcol

Answer: A

QUESTION NO: 59

Which of the following Oracle parameters should never be modified in the file init.ora? (Choose two.)

A. row_cache_cursors

B. db_block_size

C. shared_pool_size

D. db_block_buffers

E. db_name

Answer: B, E

QUESTION NO: 60

Which of the following statements regarding the communication between a SAP system and an external Message Transfer Agent (MTA) using SMTP are correct? (Choose two.)

A. To send e-mails to an MTA, or to receive emails from an MTA using SMTP, the SAP NetWeaver AS ABAP must have the ST-MAIL plugin, which needs to be installed using transaction SAINT.

B. The SAP NetWeaver AS ABAP provides the full functionality of a Message Transfer Agent (MTA).

C. The SAP NetWeaver AS ABAP can send mails to only one specific MTA per SAP client.

D. The SAP NetWeaver AS ABAP cannot automatically forward incoming mails to other domains.

Answer: C, D

QUESTION NO: 61

Which of the following statements regarding the client concept and the client copy tools in ABAPbased SAP Systems (for example, SAP ECC) are true? (Choose three.)

A. Clients can be copied within a single SAP System.

B. Application data can only be copied from one client to another, when all client-specific customizing is also copied.

C. User master records cannot be copied between clients.

D. Clients can be copied between SAP Systems of the same release.

E. Client-independent customizing is always automatically copied between clients.

Answer: A, B, D

QUESTION NO: 62

How many clients can exist per AS ABAP-based SAP system?

A. As many as you want.

B. The number of clients per system is limited to 500.

C. The maximum number is 1000 clients per SAP system.

Answer: C

QUESTION NO: 63

Which of the following processes connect to the database during the startup of an instance of an SAP system based on AS ABAP?

A. The message server, in order to check a valid SAP license

B. The gateway process, via remote function call (RFC)

C. The dispatcher process via JDBC

D. All work processes connect to the database

Answer: D

QUESTION NO: 64

Which of the following statements regarding starting and stopping an SAP system based on AS ABAP+Java 7.0 are correct? (Choose two.)

A. The ABAP-dispatcher triggers the start of the Java part of the instance.

B. The Java-dispatcher and the ABAP-dispatcher of one instance write their respective developer traces in different files on the same directory.

C. If you use the command.”stopsap J2EE DVEBMGS00″ on operation system level, only the java part of the instance is stopped.

D. The SAP MC is Java-based, therefore you can only start and stop the Java part of an instance.

Answer: A, B

QUESTION NO: 65

Which ABAP software components are installed during the installation of an SAP ECC 6.0 system? You find those in System -> Status of your SAP ECC 6.0 system. (Choose two.)

A. SAP_CRM

B. SAP_HR

C. SAP_APPL

Answer: B,C

QUESTION NO: 66

You want to use the Change and Transport System (CTS) to perform transports of non-ABAP objects into non-ABAP systems. Which configuration settings are necessary for this? (Choose three.)

A. The CTS Deploy Web Service must be configured.

B. You must use client-dependent transport routes for all systems in your transport domain.

C. The transport domain controller system must be based on SAP NetWeaver AS 7.00 SP Stack 12 or higher.

D. You need to adjust certain tp parameters for the non-ABAP systems in question.

Answer: A, C, D

QUESTION NO: 67

When deciding on the network bandwidth needed to connect front ends to an SAP system (using a WAN connection), you should consider which of the following? (Choose three.)

A. The number of users connecting using this line.

B. Using SAP’s advanced online data compression technology (SAP ODCT) to minimize the network load. The software needed for this feature is sold separately.

C. The volume of “non-SAP-related” traffic (for example, office documents) using the same connection.

D. It might be useful to switch on the “Low speed connection” flag for the remote connections.

Answer: A, C, D

QUESTION NO: 68

SAP Solution Manager 4.0 can use an SLD (System Landscape Directory). Which statements are true for the purpose of the SLD?

A. SLD is only available with the shipment of SAP NetWeaver Process Integration (PI).

B. SLD is the landscape-wide information provider for system landscape data and acts as a foundation of many SAP applications.

C. SLD is a Java application. Therefore, ABAP applications cannot make use of the information provided by the SLD.

Answer: B

QUESTION NO: 69

Using SAPDOCCD.ini, you have several options for changing the way online documentation is accessed. Which of the following statements are true? (Choose three.)

A. You can change the access path to online documentation, depending on the user ID (in the SAP system) of the user calling help.

B. You can change the access path to online documentation, depending on the logon language (in the SAP system) of the user calling help.

C. You can change the access path to online documentation, depending on the release of the SAP system from which help is being called.

D. You can change the access path to online documentation, depending on the SID (System ID) of the SAP system from which help is being called.

Answer: B, C, D

QUESTION NO: 70

Which of the following options are available as global settings when setting the ‘System change option’ in SAP Systems (transaction SE06)? (Choose two.)

A. Modifiable

B. Repaired objects modifiable

C. An option to allow changes to Repository and client-independent customizing object

D. Original objects modifiable

E. Not modifiable

Answer: A, E

QUESTION NO: 71

Regarding the architecture of the SAP NetWeaver AS, which of the following statements are true? (Choose two.)

A. The Central Services Instance of the SAP NetWeaver AS Java is only needed in a pure SAP NetWeaver AS Java (without SAP NetWeaver AS ABAP) installation.

B. The Java work processes are controlled by a dispatcher.

C. SAP NetWeaver AS Java and SAP NetWeaver AS ABAP can communicate with each other.

D. SAP NetWeaver AS Java and SAP NetWeaver AS ABAP use different database schemas.

Answer: C, D

QUESTION NO: 72

Which of following is true for an SAP system with an Oracle database? ORACLE_HOME is …

A. …a system environment variable defined on the Oracle database server and each SAP

application server.

B. …a user environment variable defined on the Oracle database server only.

C. …a system environment variable defined on the Oracle database server only.

D. …a user environment variable defined on the Oracle database server and each SAP application server.

Answer: D

QUESTION NO: 73

Which of the following statements is correct regarding online Oracle database backups?

A. The database must be running in archivelog mode.

B. The database does not write to online redo log files during online backups.

C. Online database backups are not supported by Oracle.

D. A complete online backup consists of tablespace data files and the control file, all of which are necessary for restoring the database to a consistent state.

E. Users may only read data and may not enter data while the backup is running.

Answer: A

QUESTION NO: 74

Where can you find details on the memory consumption of the integrated ITS?

A. Using the ICF service /sap/moni/its/mem

B. In the SAP system, using transaction/report SITSPMON

C. On operating system level, using the command “its -mem”

D. In the SAP system, using transaction SMICM

Answer: B

QUESTION NO: 75

Which of the following statements regarding the functions offered by CCMS-based monitoring are true? (Choose two.)

A. It is possible to monitor more than one SAP system by using the functions offered by CCMS monitoring.

B. Correctly configured threshold values to be used for monitoring purposes can be switched by using operation modes.

C. You need a special key (generated within SAP Solution Manager) to create your own monitor definitions in transaction RZ20.

Answer: A, B

QUESTION NO: 76

Which of the following statements regarding the transaction RZ10 are true?(Choose two.)

A. When you use the save button in RZ10 and activate the profile, it will be written immediately to the operating system level.

B. The default profile cannot be maintained using transaction RZ10.

C. The maintained parameters will take effect immediately after the profile is activated in the RZ10.

D. You can compare the profile file on the operating system with the profile in the database.

Answer: A, D

QUESTION NO: 77

In the MOUNT mode of an Oracle instance, the administrator can do which of the following? (Choose two.)

A. Change the ARCHIVELOG mode of the database.

B. Perform a media recovery.

C. Access the Oracle DBA_* views in tablespace SYSTEM.

D. Recreate the missing control file.

Answer: A, B

QUESTION NO: 78

Which of the following statements regarding removing a Central User Administration are true? (Choose two.)

A. Once the CUA has been configured completely and the users have been transferred to the CUA master client, you cannot remove the CUA completely any more.

B. A child system can to be removed from the CUA (permanently or temporarily).

C. You can remove the CUA completely.

D. When you remove a child system from the CUA you automatically lose all users that exist in this child client.

Answer: B, C

QUESTION NO: 79

What catch-phrase best describes SAP’s software maintenance strategy?

A. “3-3-1 maintenance”

B. “5-1-2 maintenance”

C. “4-2-2 maintenance”

Answer: B

QUESTION NO: 80

For which of the following options do you need to install and configure SAProuter? (Choose two.)

A. Create a support message in case of problems with the SAP system

B. EarlyWatch session done remotely by an employee of SAP

C. Connection to http://help.sap.com.

D. Remote Consulting from SAP

Answer: B, D

Alternative

QUESTION 1

Is data written to the Oracle transaction logs (redo logs) before or after the information is written in the database files? Click on the button next to the right answer.
A. Before
B. After
C. Simultaneously
D. The priority and sequence of database writes and transaction log writes is controlled by the parameter “dblg_after” in the ORACLE initialization file.
E. Randomly, sometimes before, sometimes after. 

Answer: A

QUESTION 2

What is the primary function of the $ORACLE HOME/saparch directory? Click on the button next to the right answer.
A. The saparch directory is a work area for the R/3 database utilities.
B. The saparch directory is a work area for the R/3 Instance tasks.
C. The saparch directory is used as the holding area for online database backups instead of writing them to tape.
D. The saparch directory holds the archived database log files.
E. The saparch directory contains the current database transaction log files. 

Answer: D

QUESTION 3

Which customer specific specific files does sapdba save during an offline backup to insure that the Oracle database could be restored to a consistent state in case of problems?
Click on the button next to the right answer.
A. The Oracle executables files.
B. The Oracle database transaction log files and archived log files.
C. The tablespace data files, database transaction log files, and the database control file.
D. The database archived log files and R/3 Syslog file.
E. The database transaction log files and the R/3 transport structures. 

Answer: C

QUESTION 4

Which customer specific files must be saved during an online database backup to be able to restore the Oracle database to a consistent state ? Click on the button next to the right answer.
A. The Oracle executables, database parameter file, and the tablespace data files.
B. The Oracle online redo log files and the database control file.
C. The archived log files, database control file and the Oracle executables.
D. The tablespace data files, database control file, and all database redo logs written during the online backup.
E. The tablespace data files, database control file, and the database parameter file. 

Answer: D

QUESTION 5

What is the primary function of the $ORACLE_HOME/sapbackup directory? Click on the button next to the right answer.
A. The sapbackup directory is used for database backups which are written to disk.
B. The sapbackup directory is a work area for the R/3 Instance tasks.
C. The sapbackup directory is the temporary holding area for the database transaction logs (redo logs) before they are automatically written to tape.
D. The sapbackup directory holds the archived database log files.
E. The sapbackup directory is used by the R/3 database utilities during database reorganizations. 

Answer: A

QUESTION 6

What is the name of the brbackup and brarchive parameter file for an Oracle database used by an R/3 Central Instance with SAP System ID C11? Click on the button next to the right answer.
A. initC11.ini
B. initC11.ora
C. initC11.sap
D. sapdba.ini
E. initC11.dba 

Answer: C

QUESTION 7

When using a tape device that supports hardware compression which of the following statements is true? Note: There is more than one right answer! Click on the buttons next to the right answers.
A. The tape_address and tape_address rew init.sap parameters are automatically
calculated based upon the value of the “compression” parameter.
B. Drivers for hardware compression must be specified for the tape_address and tape_address rew parameters in the init.sap file.
C. The compression ratio is calculated using “brbackup -k only” immediately after installation and should be repeated at least once a month to update compression ratios.
D. The compression ratio should be calculated using “brbackup -k only” immediately after
installation and never needs to be repeated.
E. The “compression” parameter should be set to “hardware” in the init.sap file. 

Answer: C,E

QUESTION 8

Sapdba and the Computer Center Management System (CCMS) use operating system level programs for certain database administration tasks. Which program would be called by CCMS for backing up the data files for the PSAPBTABD and PSAPBTABI tablespaces?
Click on the button next to the right answer.
A. Brarchive
B. Brconnect
C. sapdba ”b
D. brbackup
E. backoffl 

Answer: D

QUESTION 9

What are the 3 different Oracle database startup modes? Click on the button next to the right answer.
A. Warm, cold, maintenance
B. Mount, nomount, open
C. Online, offline, utility
D. Level 1, level 2, level 3
E. Normal, restrict, utility 

Answer: B

QUESTION 10

What are the 3 different Oracle database shutdown modes? Click on the button next to the right answer.
A. Warm, cold, maintenance
B. Level 1, level 2, level 3
C. Normal, immediate, abort
D. Regular, active, passive
E. Standard, now, kill 

Answer: C

QUESTION 11

What is the primary purpose of the $ORACLE_HOME/sapreorg directory. (Windows NT: $ORACLE_HOME\sapreorg)? Click on the button next to the right answer.
A. The sapreorg directory is a work area for the R/3 database utilities.
B. The sapreorg directory is a work area for the R/3 Dialog Instance Tasks.
C. The sapreorg directory is used as the holding area for online database backups instead of writing them to tape.
D. The sapreorg directory holds the database transaction log files.
E. The sapreorg directory contains the archived database log files. 

Answer: A

QUESTION 12

To perform a complete database reset, you need one of the following backups.
Note! More than one answer is correct. Please click on the buttons next to the correct answers
A. Complete offline backup.
B. Complete online backup.
C. Consistent online backup.
D. Backup of offline redo log files. 

Answer: A,C

QUESTION 13

What is the purpose of the Oracle “OPS$connect” function? Click on the button next to the right answer.
A. OPS$connect authorization allows an operating system user to connect to the database without being prompted for a password.
B. OPS$connect is an Oracle command enabling whoever executes it to administer the database without using sqldba.
C. OPS$connect is used in Oracle Parallel Server installations to enable remote database
connections over a LAN.
D. OPS$connect authorization is required of all database users and is required for connection to the database.
E. OPS$connect enables the R/3 System saposcol process to communicate and exchange data with the database. 

Answer: A

QUESTION 14

What is the name of the alert log file for an Oracle database using a system identifier (SID) of C11? Click on the button next to the right answer.
A. ora_log_C11.log
B. ora_log_C11.trc
C. alert_C11.log
D. alert_C11.trc
E. orasrv.log

Answer: C

QUESTION 15

What happens if a table wants to allocate another extent but there is not enough contiguous free space in the tablespace? Click on the button next to the right answer.
A. The extent is allocated in another tablespace.
B. The Oracle error message ORA-1653 is sent to the Syslog file and to the ABAP/4 short dump.
C. The extent is distributed across the free space that is available.
D. Oracle dynamically reorganizes the tablespace to make all available space contiguous.
E. The database switches into maintenance mode and sends a system message to the database administrator. 

Answer: B

QUESTION 16

What action needs to be taken when Oracle returns an ORA-1653 error, failure to allocate an extent for a table in a specific tablespace? Click on the button next to the right answer.
A. The tablespace should be moved to a faster disk so that Oracle can find the extents quicker.
B. The tablespace size should be increased by adding 1 or more datafiles.
C. This is an Oracle internal error message which should be registered with Oracle immediately.
D. The database must be shutdown immediately to avoid damage.
E. The affected table should be dropped to avoid similar problems in the future. 

Answer: B

QUESTION 17

Under which circumstances does a table/index have to be reorganized? Click on the button next to the right answer.
A. If the extents belonging to the table/index are distributed across several data files.
B. If a log switch occurs before a database commit is completed.
C. If the tablespace overflows during a redo log file switch.
D. If an archiver stuck situation occurs during a write to the table/index.
E. If the table/index reaches the upper limit for the MAXEXTENTS parameter value when
attempting to allocate another extent. 

Answer: E

QUESTION 18

Which Oracle component dynamically maintains information about the status of the database redo logs, database mode, names and paths of database files, and is essential during a database recovery?
Click on the button next to the right answer.
A. The Oracle parameter file, init.ora.
B. Each tablespace data file contains this data for the whole database.
C. The Oracle control file, cntrl.dbf.
D. The SGA definition file, sgadef.def.
E. The sapdba parameter file, init.dba. 

Answer: C

QUESTION 19

An Instance error occurs when 1 or more Oracle background processes become corrupted. What actions should the database administrator take to correct the problem?
Click on the button next to the right answer.
A. This is a serious error. Call the Oracle hotline.
B. Shutdown the operating system and reinstall the Oracle software.
C. Shutdown abort and startup open. The SMON process will use the current redo log files and checkpoint information from the control files to execute an automatic instance recovery upon database startup.
D. Shutdown the operating system and turn all hardware off. After the hardware cools off start everything up again and execute Orainst using the repair option.
E. Restore all missing files, apply the offline redo logs, update the control files, and execute the startup open command. 

Answer: C

QUESTION 20

Which files must be restored from tape to allow a full database restore and recovery ?
Click on the button next to the right answer.
A. Database control file, tablespace data files, and the database alert log.
B. Tablespace data files, database control file, and all archived database transaction logs created since the last full backup.
C. $ORACLE_HOME, Oracle parameter file, tablespace data files.
D. Database control file, tablespace data files, R/3 Syslog, R/3 Transport directory.
E. Oracle parameter file, tablespace data files, and the Oracle control file. 

Answer: B

QUESTION 21

The R/3 System Oracle database has 4 online redo logs, also known as database transaction logs. Each online redo log has a mirrored copy. What is the effect of a log file switch? Click on the button next to the right answer.
A. The current online redo log gets copied to its mirrored copy, upon completion the next online redo log becomes open for writing.
B. The database alternates between writing to the online and offline redo log files.
C. The database switches between writing to the original redo log files and the mirrored redo log files.
D. The current R/3 Syslog file gets copied to the saparch directory and a new Syslog file is
created.
E. The current online redo log gets closed and the next online redo log gets opened for writing. The ARCH process gets triggered to begin backing up the recently closed redo log. 

Answer: E

QUESTION 22

Which statement is true of online Oracle database backups ? Click on the button next to the right answer.
A. Users may only read data and may not enter data until after the backup is done.
B. Database transaction logs (online redo logs) are not written during online backups.
C. The tablespace data files and control file comprise the complete online backup and are all that is necessary for restoring the database to a consistent status.
D. The database must be running in archivelog mode.
E. Online database backups are not supported by Oracle. 

Answer: D

QUESTION 23

Given Oracle database with system ID C11. If tablespace PSAPBTABD has been extended 200 MB by adding another datafile which of the following statements is true?
Click on the button next to the right answer.
A. In the event of a full database restore the new tablespace data file will be automatically created based upon information in the initC11.ora file.
B. All data files for PSAPBTABD should be backed up along with the database control file to maintain database recoverability.
C. The database should be shutdown and started up again to register the existence of the new file in the Oracle internal system tables.
D. The data files for PSAPBTABD, the control file, and the redo logs must be backed up to
maintain database recoverability.
E. An R3INST database copy should be run to create a clean copy of the complete database. 

Answer: D

QUESTION 24

What is the highest priority when planning the distribution of the database transaction logs,
mirrored transaction logs, archived transaction logs, and tablespace data files over multiple logical device groups? Click on the button next to the right answer.
A. Better performance through more hardware.
B. More flexibility in case of hardware failure.
C. Easier database backups and quicker restores.
D. Higher data security and easier administration.
E. To make the system physically more modular for transport reasons. 

Answer: D

QUESTION 25

Which of the following oracle parameters should never be modified in the init.ora file? Note: There is more than one right answer! Click on the buttons next to the right answers.
A. db_block_buffers
B. db_block_size
C. db_name
D. controlfiles
E. shared_pool_size 

Answer: B,C

QUESTION 26

Which of the following configurations would have the slightest impact upon data security and/or performance? Click on the button next to the right answer.
A. Operating system swap and Oracle tablespace data files installed on the same physical disk(s).
B. Operating system swap and SAP kernel (executable files) installed on the same physical disk(s).
C. Operating system swap and Oracle database transaction logs (redo logs) installed on the same disk(s).
D. Operating system swap and the /usr/sap directory on the same physical disk(s).
E. Oracle database archived log files (offline redo logs) accessed over a shared (or NFS) directory connection. 

Answer: B

QUESTION 27

The physical separation of database logs from their mirror copies means? Click on the button next to the right answer.
A. Using physically separate partitions of a physical disk.
B. Using physically separate disks.
C. Using physically separate disks in the same logical device group.
D. Using generic database utilities to split the flow of data between randomly chosen operating system directories.
E. Use of database specific utilities to fork log backups to 2 physically separate backup media. 

Answer: B

QUESTION 28

Which of the following Oracle parameters should be modified in the init.ora file to enlarge the shared memory usage for the Oracle database instance?
A. log_archive_dest
B. db_block_size
C. rollback_segments
D. shared_pool_size
E. db_block_buffers 

Answer: D

QUESTION 29

brbackup tool can create a database backup when the database is up and running or when it has been shutdown. During an online database backup which of the following is TRUE? Click on the button next to the right answer.
A. Users must stop entering data but may continue working using read-only transactions.
B. Users must stop working because their work would be unrecoverable in case of problems with the backup.
C. Users may continue working without interruption.
D. Power-users may continue working but data-entry users must log off.
E. Users must log off until the online backup is started but then may continue workin

Answer: C

QUESTION 30

Which of the following statements are correct in regard to using a single run of BRBACKUP to save both the database files and the offline redo log files? Note! More than one answer is correct. Please click on the buttons next to the correct answers.
A. BRARCHIVE is started immediately after the database backup is complete: no further
intervention by the database administrator is necessary.
B. This technique can only be used for offline database backups, not online backups.
C. The database backup and the backup of the offline redo log files must fit on one tape because changing tapes is not supported.
D. You can back up the database using multiple tape devices in parallel.
E. The tapes used must have been initialized by BRBACKUP. 

Answer: A,C,E

QUESTION 31

What happens during the startup of an Oracle database?Note! More than one answer is correct. Please click on the buttons next to the correct answers.
A. The SGA is created in shared memory according to the parameter settings in the configuration file init.ora.
B. The Oracle background and shadow processes are created.
C. In the mount phase, all copies of the control file are opened.
D. If necessary, Oracle automatically performs an instance recovery.
E. As the last step, the online redo log files are cleared and the data files are opened.

Answer: A,C,D

QUESTION 32

What happens during the shutdown of an Oracle database?Note! More than one answer is
correct. Please click on the buttons next to the correct answers.
A. When you shutdown the database with the NORMAL option, the database system disconnects all users before shutting down the database.
B. When you shutdown the database with the NORMAL or IMMEDIATE option, the database system writes a checkpoint before shutting down the database.
C. When you shutdown the database with the ABORT or IMMEDIATE option, open transactions are rolled back before the database is shut down.
D. When you shut down the database with the ABORT option, the R/3 system is shut down, too.
E. Shutting down the database with the ABORT option always requires an instance recovery at the next database startup. 

Answer: B,E

QUESTION 33

Which of the following statements express part of the SAP-recommended strategy for creating and updating the table statistics used by the cost-based optimizer?
A. No statistics are created for R/3 pool and cluster tables.
B. Statistics are created for all transparent tables that have no statistics.
C. The table DBSTATC can be used to trigger an exact computation of the statistics of specific tables.
D. The update for table statistics refreshes all transparent tables.
E. The table DBSTATC can be used to detect which table statistics need to be refreshed. 

Answer: B

QUESTION 34

What happens if a table wants to allocate another extent but there is not enough contiguous free space in the tablespace? Click on the button next to the right answer.
A. Please click on the button next to the correct answer.
B. The extent is allocated in another tablespace.
C. The extent is distributed across the free space that is available.
D. The Oracle error message ORA 1653 is sent to the file SYSLOG and to the ABAP short dump.
E. Oracle dynamically reorganizes the tablespace to make all available space contiguous.
F. The database switches into maintenance mode and sends a system message to the database administrator. 

Answer: D

QUESTION 35

When the R/3 update task aborts with an Oracle error ORA1653 – failure to allocate an extent for a table in a specific tablespace – what action needs to be taken? Note! More than one answer is correct. Please click on the buttons next to the correct answers.
A. The tablespace should be reorganized.
B. The tablespace size should be increased by adding a new data file.
C. The table should be reorganized.
D. The storage parameter MAXEXTENTS must be increased.
E. After the cause of the error has been removed, the R/3 update task must be reactivated. 

Answer: B,E

QUESTION 36

Which of the following checks are useful for database performance monitoring?
Note! More than one answer is correct. Please click on the buttons next to the correct answers.
A. Checking that the CBO statistics are refreshed once a week according to the strategy
recommended by SAP.
B. Checking that the archive directory contains enough free space.
C. Checking the data buffer quality.
D. Checking the shared cursor cache for expensive SQL statements.
E. Checking for tables with more than 100 extents. 

Answer: A,C,D

QUESTION 37

___________ is used as default user when you can an SAP tool for Oracle administration.
Click on the button next to the right answer.
A. SYSTEM
B. SYSDBA
C. SYSOPER
D. SAP
E. SIDADM 

Answer: A

QUESTION 38

Name the standard Database users created in Oracle. Note! More than one answer is correct. Please click on the buttons next to the correct answers
A. SIDADM
B. ORASID
C. SYS
D. SAP
E. SYSTEM 

Answer: C,E

QUESTION 39

The recommended method of changing the password of SAP is. Click on the button next to the right answer.
A. SQL> ALTER USER
B. SAP tool BRCONNECT
C. SQL > ALTER USER
D. SQLPLUS>CHANGE PASSWORD
E. SAP tool BRUSER 

Answer: B

QUESTION 40

The Oracle tool to test the connection to the database with SID C11 ON HOST twdf0505 is
Click on the button next to the right answer.
A. TNSLISTENER
B. lsnrctl start
C. tnspingC11
D. CONNECT
E. BRCONNECT 

Answer: C

QUESTION 41

Your daily backups are performed with automatic tape selection; no volume for backup is
specified. Which tapes will be accepted for backup (assuming the tape lock period is expired in all cases?) Note! More than one answer is correct. Please click on the buttons next to the correct answers
A. any labeled tape
B. The tape labeled with the volume name you got from DB13, Goto Tapes needed.
C. A tape labeled with volume name scratch
D. Any unlabeled tape. 

Answer: B,C

QUESTION 42

The BR*TOOLS profile init.sap can be edited by; Click on the button next to the right answer.
A. BRBACKUP
B. BRARCHIVE
C. BRTOOLS
D. Operating system editor.
E. None of the above. 

Answer: D

QUESTION 43

To perform a complete database reset, you need one of the following backups.
Note! More than one answer is correct. Please click on the buttons next to the correct answers
A. Complete offline backup.
B. Complete online backup.
C. Consistent online backup.
D. Backup of offline redo log files. 

Answer: A,C

QUESTION 44

To perform a complete database reset, you need one of the following backups. Note! More than one answer is correct. Please click on the buttons next to the correct answers.
A. Complete offline backup.
B. Complete online backup.
C. Consistent online backup.
D. Backup of offline redo log files. 

Answer: A,C

QUESTION 45

During an offline backup, which customer files does brbackup save to ensure that the Oracle database can be restored to an internally consistent state? Please choose the correct answer.
A. Oracle executable files.
B. Oracle database transaction log files and offline redo log files.
C. Offline redo log files and the R/3 SYSLOG file.
D. Tablespace data files, database online redo log files, and the database control file.
E. Database transaction log files and R/3 transport structures. 

Answer: D

QUESTION 46

During an online database backup, which customer files must be saved to ensure that the Oracle database can be restored to an internally consistent state? Please choose the correct answer.
A. Tablespace data files, the database control file, and all database redo logs written during the online backup.
B. Oracle online redo log files and the database control file.
C. Offline redo log files, the database control file, and the Oracle executables.
D. The Oracle executables, the database parameter file, and the tablespace data files.
E. The tablespace data files, the database control file, and the database parameter file. 

Answer: A

QUESTION 47

When an Oracle database with database SID C11 is used by an SAP System, what is the name of the file for BR*Tools parameters? Please choose the correct answer.
A. initC11.ini
B. initC11.sap
C. initC11.ora
D. sapdba.ini
E. initC11.dba 

Answer: B

QUESTION 48

When an Oracle database with database SID DB1 is used by an SAP System SID C11, what is the name of the file for BR*Tools parameters?
A. initDB1.ini
B. initC11.sap
C. initDB1.sap
D. brtools.ini
E. initDB1.ora

Answer: C

QUESTION 49

What is the probable cause of the brconnect error indicated in this screen? Please choose the correct answer.
A. An offline backup has been started but tablespaces are missing.
B. The backup has aborted because an R/3 instance is still running.
C. The backup has aborted because there is no tape in the tape device.
D. The tape has not been initialized.
E. The backup has been terminated because brarchive is already running. 

Answer: B

QUESTION 50

When is data written to the Oracle transaction logs (redo logs)? Please choose the correct answer.
A. Sometimes before, sometimes after being written to the database files.
B. After being written to the database files.
C. At the same time as being written to the database files.
D. After a transaction failed.
E. Before being written to the database files. 

Answer: E

QUESTION 51

What is the primary function of the “sapbackup” directory? Please choose the correct answer.
A. Storing database transaction logs (redo logs) temporarily before they are automatically written to tape.
B. Providing a work area for R/3 Instance tasks.
C. Storing database backup log files.
D. Storing the offline redo log files.
E. Providing a work area for R/3 database utilities during database reorganizations. 

Answer: C

QUESTION 52

Which of the following statements is correct in regard to OPS$connect?
Please choose the correct answer.
A. OPS$connect authorization allows an operating system user to connect to the database without being prompted for a password.
B. OPS$connect is an Oracle command enabling whoever executes it to administer the database without using the oracle tool SQL*Plus. (UNIX:svrmgrl, NT:svrmgr30).
C. OPS$connect is used by BR*Tools to startup the database in restricted mode.
D. OPS$connect authorization is required for all users connecting to the Oracle database.
E. OPS$connect enables the R/3 saposcol process to communicate and exchange data with the Oracle database. 

Answer: A

QUESTION 53

Based upon the sapdba archive status display shown, what may be concluded?
Please choose the correct answer.
A. The directory for the offline redo log files is almost out of space.
B. The R/3 central instance is not installed on the same computer as the database.
C. There are 206 database transaction logs and 19 offline redo log files.
D. The “saparch” directory is approximately 20 MB in size.
E. There are no obvious problems. 

Answer: A

QUESTION 54

Which Oracle component dynamically maintains information about the status of the database redo logs, the database mode, the names and paths of database files, and is essential during a database recovery?
Please choose the correct answer.
A. The Oracle parameter file, init.ora.
B. Each tablespace data file contains this data for the whole database.
C. The SGA definition file, sgadef.def.
D. The Oracle control file, cntrl.dbf.
E. The sapdba parameter file, init.dba. 

Answer: D

QUESTION 55

When the R/3 update task aborts with an Oracle error ORA1653 ” failure to allocate an extent for a table in a specific tablespace ” what action needs to be taken? Please choose the correct answer.
A. The tablespace should be reorganized.
B. The tablespace should be increased (add new data file or resize existing data file)
C. The table should be reorganized.
D. The storage parameter MAXEXTENTS must be increased.
E. The table should be moved to another tablespace. 

Answer: B

QUESTION 56

Which of the following is true for the SQL statement highlighted on the “Shared SQL” screen? Please choose the correct answer.
A. The statement is an expensive statement, because it is on top of the list.
B. The statement is an expensive statement, because it shows more than one million buffer gets.
C. The statement is an expensive statement, because the buffer gets in this statement exceed 5% of the total buffer gets (reads) in this system.
D. The statement is an expensive statement, because the buffer gets in this statement exceed 5% of the physical reads (disk reads) in this system.
E. The statement is not an expensive statement. 

Answer: C

QUESTION 57

The R/3 System Oracle database has four online redo logs, also known as database transaction logs. Each online redo log has a mirrored copy. What is the effect of a log file switch? Please choose the correct answer.
A. The current online redo log is copied to its mirrored copy, then the next online redo log
becomes open for writing.
B. The database alternates between writing to the online and offline redo log files.
C. The database switches between writing to the original redo log files and the mirrored redo log files.
D. The current online redo log is closed and the next online redo log becomes open for writing. The ARCH process is triggered to begin backing up the recently closed redo log.
E. The current R/3 SYSLOG file is copied to the SAPARCH directory and a new SYSLOG file is created. 

Answer: D

QUESTION 58

Which of the following statements is correct regarding online Oracle database backups?
Please choose the correct answer.
A. Users may only read data and may not enter data until after the backup is done.
B. The database must be running in archivelog mode.
C. A complete online backup consists of tablespace data files and the control file, all that are necessary for restoring the database to a consistent status.
D. The database does not write to transaction logs (online redo logs) during online backups.
E. Online database backups are not supported by Oracle. 

Answer: B

QUESTION 59

An instance error occurs when one or more Oracle background processes become corrupted. As the database administrator, what action should you take first? Please choose the correct answer.
A. Shutdown abort and startup open. The SMON process will use the current redo log files and checkpoint information from the control files to execute an automatic instance recovery upon database startup.
B. Shutdown the operating system and reinstall the Oracle software.
C. This is always a serious error, therefore call the Oracle hotline.
D. Shutdown the operating system and turn all hardware off. After the hardware cools off, start everything up again and execute Orainst using the repair option.
E. Restore all missing files, apply the offline redo logs, update the control files, and execute the startup open command. 

Answer: A

QUESTION 60

Based on SAP configuration guidelines for data security and performance, which of the following statements is correct regarding the configuration revealed by this screen?
Please choose the correct answer.
A. This configuration meets SAP data security standards. The distribution of system components is reasonable in terms of performance.
B. A significant performance improvement could be achieved by installing origlogA and mirrlogB on the same disk, and origlogB and mirrlogA together on another disk.
C. The installation of the “sapreorg” directory on the same disk as mirrlogA and mirrlogB
represents a potential data security problem.
D. OriglogA and origlogB may increase in size exponentially, and should not be installed on the same disk as the $ORACLE_HOME directory.
E. Installing the components sapdata1 to sapdata6 on disks of 4 GB is a waste of hardware because these components never increase in size. 

Answer: A

QUESTION 61

What is the primary purpose of the “sapreorg” directory?
Please choose the correct answer.
A. Storing the offline redo log files.
B. Providing a work area for R/3 dialog instance tasks.
C. Storing online database backups instead of writing them to tape.
D. Storing transaction log files.
E. Providing a work area for BR*Tools. 

Answer: E

QUESTION 62

CORRECT TEXT
______ and _____ special systems privileges gives you administrative privileges to perform
certain database operations for which privileges cannot be granted in any other fashion 

Answer: SYSDBA, SYSOPER

QUESTION 63

CORRECT TEXT
In an SAP system; which kind of authentication is used to connect to Oracle using the SYSDBA and SYSOPER privileges? 

Answer: Operating System

QUESTION 64

Create tablespace is an example of object privileges.
A. True
B. False 

Answer: B

QUESTION 65

The SYSOPER special system privilege can perform the following tasks as SAPDBA privilege except
A. Database shutdown
B. Create database
C. View user data
D. BACKUP DATABASE
E. ARCHIVELOG 

Answer: B,C

QUESTION 66

The SYSDBA and SYSOPER system privilege allow access to a database instance when the database is not open.
A. True
B. False 

Answer: A

QUESTION 67

Control of the SYSDBA and SYSOPER system privilege is totally outside the database itself.
A. True
B. False 

Answer: A

QUESTION 68

In SAP system with Oracle, special operating system users created during the installation have privileges for administration and maintenance of the Oracle database.
A. True
B. False 

Answer: A

QUESTION 69

CORRECT TEXT
Mention two (2) OS users created each in UNIX and windows platform during the installation of SAP on Oracle 

Answer: Windows: adm and SAPService UNIX: ora and adm

QUESTION 70

Which of the following OS users groups in UNIX and Windows platform has full administration of all instances?
A. dba
B. oper
C. ORA__DBA
D. ORA__OPER
E. ORA_DBA 

Answer: A,B,D,E

QUESTION 71

If you assign a database role to a database user, the user will be granted all privileges included in
the role.
A. True
B. False 

Answer: A

QUESTION 72

Which of the following is a predefined Oracle database role?
A. DBA
B. SYSDBA
C. SYSOPER 

Answer: A

QUESTION 73

Because the DBA predefined role is flagged with the ADMIN option; it can be used to shutdown and start an Oracle instance.
A. True
B. False 

Answer: B

QUESTION 74

CORRECT TEXT
The SAP installation creates just one additional role called ______. 

Answer: SAPDBA

QUESTION 75

The SAPDBA role contains the Oracle system privileges and objects privileges.
A. True
B. False. 

Answer: A

QUESTION 76

What is the implication of having different number of work processes defined differently in different places in the system?
A. No implication, the system resolves it by taking the definition of the kernel
B. Inconsistencies can occur
C. The switching must be done manually
D. The switching takes place dynamically 

Answer: B

QUESTION 77

Packages are created and managed with
A. Package Builder (SPAK)
B. Package Developer (SPAK)
C. Package Editor (SPAK)
D. ABAP Editor (SE38) 

Answer: A

QUESTION 78

It is possible for an individual to request for his own namespace in SAP.
A. True
B. False 

Answer: A

QUESTION 79

Workbench and customizing requests are both created with
A. SE10
B. SE09
C. SE12
D. SE21 

Answer: A,B

QUESTION 80

What elements are parts of the data structure of an SAP system?
A. Registry Repository
B. Object Repository
C. Client
D. Database Server
E. Cross-client customizing
F. SAP Kernel 

Answer: B,C,E

QUESTION 81

Decide which of the following statements are correct
A. Entering customer data requires a customizing request
B. A change request contains one or more tasks
C. A task can always be assigned to only one developer
D. Any customizing requires a customizing request 

Answer: B,C

QUESTION 82

Which statements are correct?
A. The transport of objects is divided into export, storage and import phases
B. The import into target system is performed automatically at midnight Greenwich Mean Time
C. The transport directory is specified by parameter DIR_TRANS
D. When transporting, the following rules applies: The target client is the same as the source client, unless otherwise specified 

Answer: C,D

QUESTION 83

Work processes use a shared user to access the database.
A. True
B. False 

Answer: A

QUESTION 84

Users are assigned authorizations using
A. Privileges
B. Profile
C. Roles
D. Authentication 

Answer: C

QUESTION 85

Which of the following are user types in an SAP system?
A. Dialog
B. System
C. Communication
D. Service
E. RFC
F. Reference 

Answer: A,B,C,D,F

QUESTION 86

Which of these user types is used to assign additional authorization?
A. Dialog
B. System
C. Communication
D. Reference 

Answer: D

QUESTION 87

Which of the following user type is used for anonymous system accesses using an ITS or ICF service?
A. Dialog
B. System
C. Service
D. Communication
E. Reference 

Answer: C

QUESTION 88

Which of the following user types can be used for dialog free communication within the system?
A. Dialog
B. System
C. Service
D. Communication
E. Reference 

Answer: B,D

QUESTION 89

Which of the following user types requires only the system administrator to change the password?
A. Dialog
B. System
C. Service
D. Communication
E. Reference 

Answer: B,C

QUESTION 90

Which of the following user type is exempted from the usual settings for the validity period of a password?
A. Dialog
B. System
C. Communication
D. Reference
E. Service 

Answer: B

QUESTION 91

The separate server process created on behalf of each work process (generally, of a user
process) is called
A. System process
B. Standard process
C. Dedicated process
D. Shadow process 

Answer: D

QUESTION 92

CORRECT TEXT
Which SAP tool is used to change the password of SAP 

Answer: BRCONNECT

QUESTION 93

CORRECT TEXT
SAP recommends that you should not use BRCONNECT to shutdown and startup the database. Why? 

Answer: It does not write log files of its action unlike BRSPACE

QUESTION 94

Rollback segments are created by the SAP installation tool using the storage parameters
A. INITIAL
B. OPTIMAL
C. MAXEXTENT D
D. MINEXTENT
E. NEXT 

Answer: A,C,D,E

QUESTION 95

Which of the following parameters influences the behavior of the Oracle cost based optimizer
A. TUNE_OPTIMIZER
B. OPTIMIZER_MODE
C. CBO_ULTRA_WARP
D. DB_FILE_MULTIBLOCK_READ_COUNT
E. dba/ora/use_hint 

Answer: B,D,E

QUESTION 96

CORRECT TEXT
As the SAP administrator, you want to use the compression functionality of
BRBACKUP/BRARCHIVE; you have set the parameter compress=yes, what other two (2)
parameters must be set 

Answer: compress_cmd
Answer: compress_dev

QUESTION 97

In which transaction allows you to know which files must be restored in the event of a recovery
A. DB12
B. DB13
C. DB14
D. DB16 

Answer: A

QUESTION 98

CORRECT TEXT
The SAP administrator for the external backup tools in combination with RMAN backup sets, what value will you set backup_dev_type to? 

Answer: rman_util
Answer: rman_disks
Answer: rman_stage

QUESTION 99

The SAP recommended update statistics strategy involves which of the following steps?
A. Watch and hide logs
B. Monitoring and evaluation of table accesses
C. Scanning and update statistics
D. Check and update statistics
E. Write to file and delete old table entries 

Answer: D