SAP Certified Technology Associate - System Administration (Oracle DB) with SAP NetWeaver 7.31

Question 1

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 Oracle executables, the database parameter file, and the tablespace data files

B. The tablespace data files, the database control file, and the database parameter file

C. Offline redo log files, the database control file, and the Oracle executables

D. Tablespace data files, the database control file and all database redo logs written during the online backup

E. Oracle online redo log files and the database control file

Correct Answer: D

Question 2

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

A. Unique master index

B. Dictionary index

C. Balanced tree (B*tree) index

D. Bitmap index

Correct Answer: C,D

Question 3

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

A. Unique master index

B. Dictionary index

C. Balanced tree (B*tree) index

D. Bitmap index

Correct Answer: C,D

Question 4

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

A. 562

B. This question cannot be answered with the information available.

C. twdf1318

D. twdf1318_DEV_... (Unfortunately, the rest cannot be identified from the screenshot provided)

E. DEV

Correct Answer: C

Question 5

Which AS ABAP release for software component "SAP BASIS" is used for SAP ECC 6.05?

A. 7.10

B. 7.01

C. 7.02

D. 7.20

Correct Answer: C

Question 6

You want to reduce the fragmentation of a tablespace by using BR*TOOLS. Which methods can you use to achieve this? (Choose two)

A. Online redefinition of tables

B. Online shrinking of tables

C. Update statistics

D. Online backup

E. Coalesce tables

Correct Answer: A,B

Question 7

You analyze the Oracle database alert log and discover the error message "Unable to extend tablespace".
What can you do to solve this issue? (Choose three)

A. Set at least one data file of the tablespace to "autoextensible" (AUTOEXTEND ON).

B. Create a new tablespace.

C. Add a new data file.

D. Assign a data file to a different tablespace with more free space.

E. Enlarge a data file of the tablespace with a fixed size.

Correct Answer: A,C,E

Question 8

Which settings are necessary for activating the integrated ITS?

A. Set the profile parameter itsp/enable to 1.

B. Configure the HTML cache of the SAP NetWeaver AS Java.

C. You need to deploy the necessary HTML templates on the operating system level.

D. Set the profile parameter rdisp/optimize_web_app to 1.

Correct Answer: A

Question 9

Which performance optimization tasks can be performed by configuring Automatic Table
Maintenance (ATM) in DBACOCKPIT?
(Choose two)

A. Perform complete online reorganization 'REORG REBUILD' of tables.

B. Update index statistics.

C. Reorganize tables using row forwarding.

D. Archive tables based on thresholds.

Correct Answer: B,C

Question 10

You are running a system landscape of AS ABAP-based SAP systems.
Which options do you have for selecting transport requests to be imported? (Choose three)

A. You can filter transport requests for a certain project and import them together in one step (if
you have activated the CTS functions in transaction SPRO_ADMIN [Customizing: Project Administration]).

B. You can select all transport requests for import that contain objects of a selected package.

C. You can select a single transport request for import.

D. You can select several individual transport requests to be imported in one step.

E. You can select a single transport request and import it into multiple SAP systems in one step.

Correct Answer: A,C,D

Question 11

You are running an AS ABAP-based SAP system. You have changed a dynamically switchable profile parameter in transaction RZ11 (Maintain Profile Parameters). These settings become effective immediately. You want to make sure that the new settings are still valid after the next restart of your system.
How do you fulfill this requirement?

A. No further steps are necessary in this scenario.

B. Maintain the same profile parameter in transaction RSPFPAR (Display Profile Parameter).

C. Mark check box "Activate in profile" in transaction RZ11.

D. Maintain the same profile parameter in transaction RZ10 (Edit Profiles) and activate the changes.

Correct Answer: D

Question 12

You want to apply ABAP Support Packages using transaction SPAM (Support Package Manager).
What do you need to consider? (Choose two)

A. Individual Support Packages exist for different ABAP software components.

B. It is sufficient to apply only the latest Support Package available per ABAP software component.

C. Before you apply Support Packages, it may be necessary to apply a SPAM/SAINT update.

D. You must apply the Support Packages for each client individually.

E. While applying SAP_BASIS Support Packages, a system restart is necessary due to the kernel update.

Correct Answer: A,C

SAP Certified Technology Associate - System Administration (Oracle DB) with SAP NetWeaver 7.31 - C-TADM51-731 Exam Practice Test

Latest Update

Useful Links

Contact Us