C-SASEAA-15 Exam Training Practice Tests (SAP Adaptive Server Enterprise 15 Administrator Associate)]

Question 1

Which of the following is NOT true about groups?

A. Must be enabled once created B. Database-specific C. A user can only be a member of one user-defined group D. Cannot contain other groups

Correct Answer: A

Question 2

Which of the following are TRUE about user defined caches? (Choose two.)

A. Can be added without restarting ASE B. Can be deleted if there are objects bound to them C. Can be deleted without restarting ASE D. Cannot be deleted once created E. No objects can be bound to them

Correct Answer: A,C

Question 3

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

A. sp_configure B. sp_helpconfig C. sp_monitorconfig D. sp_countmetadata E. sp_poolconfig

Correct Answer: C

Question 4

When rebuilding the master database without backups the disk refit command restores which system tables? (Choose two.)

A. sysconfigures B. sysusages C. sysreferences D. sysdevices E. sysdatabases

Correct Answer: B,E

Question 5

What is the value of @@trancount after the execution of a rollback transaction in a nested transaction?

A. 1 B. Equal to the number of begin transaction statements minus 1 C. 0 D. Equal to the number of begin transaction statements executed

Correct Answer: C

Question 6

What must occur following a non-logged transaction before normal dump transactions may resume?

A. A transaction log dump with the truncate_only option B. A transaction log dump with the no_log option C. A database dump D. A truncate table on the table in question

Correct Answer: C

SAP Adaptive Server Enterprise 15 Administrator Associate - C-SASEAA-15 Exam Practice Test