SAP Adaptive Server Enterprise 15 Administrator Associate - C_SASEAA_15 Exam Practice Test

A. load database pubs2 from "pubs2.dmp"

B. load database pubs2 from "pubs2.dmp" with compression = 6

C. load database pubs2 from "pubs2.dmp" with compression level 6

D. load database pubs2 from "compress::6::pubs2.dmp"

E. load database pubs2 from "pubs2.dmp" with compression

A. disk init.

B. alter database.

C. disk reinit.

D. disk resize.

A. To place a user table on its' own device

B. To place an index on its' own device

C. To place a transaction log on its own device

D. To place a computed column on its own device

E. To place a system table on its' own device

A. Database-specific

B. Must be enabled once created

C. A user can only be a member of one user-defined group

D. Cannot contain other groups

A. 2 TB

B. 32 GB

C. 8 TB

D. 4 TB

E. 256 GB

A. Page locks can be promoted to table locks.

B. Row locks can be promoted to page locks.

C. Row locks can be promoted to table locks.

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

E. Page locks can be promoted to intent locks.

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