Adaptive Server Enterprise 15 Administrator Associate (C-SASEAA-15) Free Practice Test

Question 1

How is a deadlock victim determined?

A. By the amount of elapsed time since the task was submitted

B. By the users permission settings

C. By the amount of the CPU time spent on the task

D. By the largest spid number of the processes involved

Correct Answer: C

Question 2

What are the reasons to create a user defined segment? (Choose two.)

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

B. To place a computed column on its own device

C. To place a transaction log on its own device

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

E. To place an index on its' own device

Correct Answer: A,E

Question 3

Which of the following tables do NOT store metadata in the metadata cache? (Choose two.)

A. syslogs

B. syscolumns

C. sysdatabases

D. syspartitions

E. sysindexes

Correct Answer: A,B

Question 4

Which of the following is the default partitioning strategy?

A. roundrobin

B. range

C. hash

D. list

Correct Answer: A

Question 5

Which commands can be used to specify the number of histogram steps in systatistics? (Choose two.)

A. update statistics

B. create index

C. sp_modifystats

D. reorg

E. optdiag

Correct Answer: A,B

Question 6

Which database option must be set to run dbcc checkalloc in fix mode?

A. dbo use only

B. ddl in tran

C. select into/bulkcopy/pllsort

D. no chkpt on recovery

E. single user

Correct Answer: E

Welcome to TestSimulate