Sybase Adaptive Server Enterprise 15.0 Administrator Associate - 510-025 Exam Practice Test

A. execsp_configure to register license certificate

B. run the license management utility

C. shut down ASE

D. execsp_configure to turn on new feature

A. The maximum I/O size for any cache is 8 pages

B. As long as 1 pool remains in the cache, any pool can be removed

C. The sum of all the buffers in the pool must be less than or equal to the total memory size of cache

D. The minimum pool size is determined by a configuration parameter

E. New pools are created using memory from the largest pool unless otherwise specified

A. sp_dboption

B. sp_monitorconfig

C. sp_helpconfig

D. sp_configure

E. sp_poolconfig

A. reorg rebuild tablename

B. bcp in

C. truncate table

D. insert

E. update statistics

A. 4 pages

B. depends on the server page size

C. 1 page

D. 8 pages

E. 2 pages

A. model

B. sybsecurity

C. sybsystemdb

D. sybsystemprocs

A. Tables may be partitioned logically as well as physically

B. Global indexes can be clustered ornonclustered on range, hash, or list partitioned tables.

C. Data in each partition may be processed differently.

D. Each partition must reside on its own segment.

E. Global indexes may be created on each partition.