SAP C-TADM51-74 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C-TADM51-74
Exam Name/Title: SAP Certified Technology Associate - System Administration (Oracle DB) with SAP NetWeaver 7.4
Certification Provider: SAP
Corresponding Certification: SAP Certified Technology Associate

Exam Questions: 155
Updated On: May 28, 2026

Question #25

Which performance optimization tasks can be performed by configuring Automatic Table
Maintenance (ATM) in DBACOCKPIT?
There are 2 correct answers to this question.

A. Reorganize tables using row forwarding.

B. Update index statistics.

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

D. Archive tables based on thresholds.

Discussion 0

Correct Answer: A,B Vote an answer

Question #26

For UNDO tablespaces, which of the following statements are true?
There are 2 correct answers to this question.

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

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

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

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

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

Discussion 0

Correct Answer: B,D Vote an answer

Question #27

Oracle database offers different types of indexes. Which are valid index types?
There are 2 correct answers to this question.

A. Bitmap index

B. Dictionary index

C. Balanced tree (B*tree) index

D. Unique master index

Discussion 0

Correct Answer: A,C Vote an answer

Question #28

You have established a backup strategy using online backups. You would like to restore your database to an earlier point in time, well AFTER the last online backup. Which files are needed for this point in time recovery?

A. All data files, the control file, and the database parameter file

B. All data files, the control file, and all redo logs written during and since the last online backup

C. Online redo log files and the control file

D. All offline redo log files, the control file, and the Oracle executables

Discussion 0

Correct Answer: B Vote an answer

Question #29

Which of the following statements about the required RFC connections in CUA are correct?
Choose the correct answer(s).

A. Certain roles for the communication users are required only during CUA setup, and can then be removed from the relevant user master records.

B. The user in the RFC connection must be a dialog user.

C. An RFC connection from the child system to itself is required.

D. The RFC connections must be specified entirely in uppercase letters and must be identical to the name of the addressed logical system.

E. An RFC connection from the central system "to itself" is required.

Discussion 0

Correct Answer: A,D,E Vote an answer

Question #30

Which of the following statements regarding removing a Central User Administration are true?
There are 2 correct answers to this question.

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

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

C. 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.

D. You can remove the CUA completely.

Discussion 0

Correct Answer: A,D Vote an answer

Question #31

Which of the following does SAP recommend to update statistics for an Oracle database used for an SAP system?
There are 2 correct answers to this question.

A. Use transaction DBACOCKPIT to schedule an update statistics run.

B. Use tools and scripts provided by Oracle for an statistics update.

C. Use transaction ST10 (Table call statistics).

D. Use "brconnect -f stats" with further commands to schedule an statistics update.

Discussion 0

Correct Answer: A,D Vote an answer

Question #32

Considering the attached screenshot,
on which host is the database of the system running?

(Choose correct answer)

A. twdf1576_DEV_00

B. This question cannot be answered with the information available

C. DEV

D. twdf1576

Discussion 0

Correct Answer: D Vote an answer

Download Free SAP C-TADM51-74 Demo

Simply submit your e-mail address below to get started with our free demo of your SAP C-TADM51-74 exam.