SAP Adaptive Server Enterprise 15 Administrator Associate

QUESTION NO: 1
Which of the following privileges are associated with the Systems Security Officer role?

A. The ability to create user-defined roles B. The ability to back up any database C. The ability to perform a disk init or disk resize command D. The ability to shut down the server

Correct Answer: A

QUESTION NO: 2
Permissions on a table can be granted by all of the following EXCEPT: (Choose two.)

A. logins with sa_role B. table owner C. logins with sso_role D. logins with oper_role E. database owner

Correct Answer: C,D

QUESTION NO: 3
What will be the result if the 'disk init' command is run to create a database device and no "vdevno" is specified?

A. The command will fail without any adverse affects to the server B. The command will fail but the operating system file will be created C. The command will function properly because the server no longer uses 'vdevno' D. The command will create the device with a vdevno assigned by the server

Correct Answer: D

QUESTION NO: 4
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: 5
Which system database is used to store distributed transaction management data?

A. sybsystemprocs B. sybsecurity C. sybsystemdb D. model

Correct Answer: C

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

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

Correct Answer: C

SAP Adaptive Server Enterprise 15 Administrator Associate - C_SASEAA_15 Exam Questions