SAP Adaptive Server Enterprise 15 Administrator Associate

QUESTION NO: 1
Which of the following can be used to identify frequently executed queries?

A. Query Processing Metrics B. Monitor Server C. Monitor and Data Analysis Tables D. sp_sysmon

Correct Answer: A

QUESTION NO: 2
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. Row locks can be promoted to page locks. C. Page locks can be promoted to intent locks. D. If other tasks hold locks conflicting with the type of table lock needed, lock escalation does not occur. E. Page locks can be promoted to table locks. F. Row locks can be promoted to table locks.

Correct Answer: D,E,F

QUESTION NO: 3
Based on the command "dump database pubs2 to pubs2.dmp with compression = 6", which commands could be used to load it? (Choose two.)

A. load database pubs2 from "pubs2.dmp" B. load database pubs2 from "compress::6::pubs2.dmp" C. load database pubs2 from "pubs2.dmp" with compression level 6 D. load database pubs2 from "pubs2.dmp" with compression = 6 E. load database pubs2 from "pubs2.dmp" with compression

Correct Answer: A,D

QUESTION NO: 4
Which of the following statements are NOT true about database dumps? (Choose two.)

A. backs up the transaction log B. performs a checkpoint C. truncates the transaction log D. cannot be run while anyone is in the database E. may dump unallocated pages

Correct Answer: C,D

QUESTION NO: 5
Which of the following will allow the system administrator to view database permissions for any given user?

A. sp_helprotect B. sp_displaylogin C. sp_helpuser D. set role

Correct Answer: A

QUESTION NO: 6
Given that the following commands are successfully executed:
use mydb go select * into #myusers from sysusers go
In which database does #myusers exist?

A. model B. tempdb C. master D. mydb

Correct Answer: B

SAP Adaptive Server Enterprise 15 Administrator Associate - C-SASEAA-15 Exam Questions