510-025 Exam Training Practice Tests (Sybase Adaptive Server Enterprise 15.0 Administrator Associate)]

Question 1

_______ represents the average amount of repeated data in a column.

A. Histogram weight B. RangeselectivityX C. Total density D. Cluster ratio

Correct Answer: C

Question 2

When rebuilding the master database without backups the disk refit command restores whichsystem tables? (Choose 2)

A. sysconfiguresX B. sysusages C. sysreferences D. sysdevices E. sysdatabases

Correct Answer: B,E

Question 3

Which of the following are true about the dump database command?(Choose 3)

A. makes a full backup copy of the database B. drops the database because it is no longer necessary C. makes a full backup copy of the transaction log D. can write a single database dump across multiple devices E. truncates the transaction log

Correct Answer: A,C,D

Question 4

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

A. select * fromsyslogshold B. select @@version C. select @@servername D. select * fromsysservers

Correct Answer: B

Question 5

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. model C. tempdbX D. mydb

Correct Answer: C

Question 6

Which of the following statements are true regarding proxy authorization? (Choose 2)

A. set proxy is only permitted at one level B. set proxy can be executed in a database with a guest user C. set proxy can be executed within a transaction D. set proxy within a procedure retains the identity of the proxy when you exit E. proxy authorization is granted by the System Administrator

Correct Answer: A,B

Question 7

When loading a database that was dumped with compression

A. the load syntax could use a different compression level than the dump. B. the database does not need to include the exact dump compression level. C. the load syntax does not need to specify the compression level. D. the load syntax does not need to use the word compression at all.

Correct Answer: D

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