SAP Adaptive Server Enterprise 15 Administrator Associate - C-SASEAA-15 FREE EXAM DUMPS QUESTIONS & ANSWERS]

SAP Adaptive Server Enterprise 15 Administrator Associate - C-SASEAA-15 FREE EXAM DUMPS QUESTIONS & ANSWERS

Question 1

Which environment variable will be used if a server name is not provided in the runserver file?

A. $SYBASE B. $DSQUERY C. $SYBASE_ASE D. $DSLISTEN

Discussion 0

Correct Answer: D Vote an answer

Question 2

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

A. To place a transaction log on its own device B. To place an index on its' own device C. To place a computed column on its own device D. To place a user table on its' own device E. To place a system table on its' own device

Discussion 0

Correct Answer: B,D Vote an answer

Question 3

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

A. select into/bulkcopy/pllsort B. single user C. dbo use only D. no chkpt on recovery E. ddl in tran

Discussion 0

Correct Answer: B Vote an answer

Question 4

What is the command used to dynamically increase the size of a database device?

A. disk resize. B. alter database. C. disk reinit. D. disk init.

Discussion 0

Correct Answer: A Vote an answer

Question 5

Given the following partial histogram from optdiag, what percentage of the rows for this column have a value of 500.00?

A. 36.9% B. 0.0% C. 6.6% D. 7.1%

Discussion 0

Correct Answer: B Vote an answer

Question 6

Given that the following commands are successfully executed:
use mydb go select * into #myusers from sysusers go
In which database does #myusers exist?

A. master B. tempdb C. mydb D. model

Discussion 0

Correct Answer: B Vote an answer