SAP C-SASEAA-15 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C-SASEAA-15
Exam Name/Title: Adaptive Server Enterprise 15 Administrator Associate
Certification Provider: SAP
Corresponding Certification: SAP-Certifications

Exam Questions: 60
Updated On: May 29, 2026

Question #19

Which of the following statements is NOT true about automatic database expansion?

A. Automatic database expansion is turned off by default.

B. Growby and maxsize policies can be set for database devices and database segments.

C. Database expansion thresholds are set per segment.

D. Automatic database expansion is managed by the stored procedure sp_helpdb.

Discussion 0

Correct Answer: D Vote an answer

Question #20

Which of the following are TRUE about lock promotion? (Choose three.)

A. If other tasks hold locks conflicting with the type of table lock needed, lock escalation occurs.

B. Page locks can be promoted to table locks.

C. Row locks can be promoted to page locks.

D. Row locks can be promoted to table locks.

E. If other tasks hold locks conflicting with the type of table lock needed, lock escalation does not occur.

F. Page locks can be promoted to intent locks.

Discussion 0

Correct Answer: B,D,E Vote an answer

Question #21

What happens when a row is inserted into a list partitioned table but the key value is not within the list?

A. The insert is discarded without an error message.

B. The row is inserted into the first partition.

C. The row is inserted into the last partition.

D. The insert fails with an error message.

Discussion 0

Correct Answer: D Vote an answer

Question #22

Which command can be used to check the maximum number of locks used since ASE server was started?

A. sp_configure

B. sp_monitorconfig

C. sp_countmetadata

D. sp_poolconfig

E. sp_helpconfig

Discussion 0

Correct Answer: B Vote an answer

Question #23

Which environment variable will be used if a server name is not provided in the runserver file?

A. $SYBASE_ASE

B. $SYBASE

C. $DSQUERY

D. $DSLISTEN

Discussion 0

Correct Answer: D Vote an answer

Question #24

Which subcommand can be used to generate a server configuration file containing the currently configured, but not necessary active, configured values?

A. verify

B. read

C. restore

D. write

Discussion 0

Correct Answer: C Vote an answer

Download Free SAP C-SASEAA-15 Demo

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