Adaptive Server Enterprise 15 Administrator Associate (C_SASEAA_15) Free Practice Test

Question 1

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

A. table owner

B. database owner

C. logins with sso_role

D. logins with oper_role

E. logins with sa_role

Correct Answer: C,D

Question 2

Which command is used to display the current server EBF level?

A. select * from syslogshold

B. select * from sysservers

C. select @@version

D. select @@servername

Correct Answer: C

Question 3

Which of the following can NOT be done by a dbo? (Choose two.)

A. create database objects

B. create a database

C. grant permission to grant permission

D. transfer object ownership

E. use database objects

Correct Answer: B,D

Question 4

Which of the following clients enables the use of the GUI Plan Viewer?

A. jisql

B. Interactive SQL

C. isql

D. SQL Advantage

Correct Answer: B

Question 5

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

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

B. Database expansion thresholds are set per segment.

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

D. Automatic database expansion is turned off by default.

Correct Answer: C

Question 6

Which database is most suitable for setting the "dsync" value to FALSE on its file system device?

A. sybsystemdb

B. tempdb

C. sybsystemprocs

D. model

E. master

Correct Answer: B

Welcome to TestSimulate