Pass4itsure > Sybase > Sybase Certification > 510-025 > 510-025 Online Practice Questions and Answers

510-025 Online Practice Questions and Answers

Questions 4

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

A. the database must be at least as large as the size of the database dump

B. the database must have been created with the for load option

C. the database must be exactly the same size as the database dump

D. the database must not be in use

E. the database need not exist because load database will create the database

F. thedatabase must not be marked as suspect

Buy Now
Questions 5

Given that the following set of commands are executed in a 2k server: sp_cacheconfig mycache, 100M, go sp_poolconfig mycache, 50M, 4K go sp_poolconfig mycache, 10M, 16K, 4K go Which of the following are TRUE? (Choose 2)

A. mycache is 40M

B. 4K buffer pool is 50M

C. 4k buffer pool is 40M

D. 2K buffer pool is 50M

E. no 2K buffer pool

Buy Now
Questions 6

Which system database is used to store distributed transaction management data?

A. sybsystemprocs

B. model

C. sybsystemdb

D. sybsecurity

Buy Now
Questions 7

Which of the following is true regarding semantic partitioning? (Choose 3)

A. Configuration parameter is on by default

B. Requiressa_role to enable

C. Partitioned tables can be created

D. Rows are assigned to different partitions based on a logical test

E. Partitions can be dropped

F. Computedcolumns are allowed in the key of range partitions

Buy Now
Questions 8

In ASE 15, what is the relationship between the virtual device number chosen for a device and the number of devices configuration parameter?

A. None

B. One of the chosen device numbers must equal the parametervaluE.

C. All virtual device numbers must be a factor of the parametervaluE.

D. The maximum virtual device number allowed is the value of the parameter minus 1.

Buy Now
Questions 9

Which system table contains a row for every transaction log fragment?

A. sysdatabases

B. sysusages

C. sysdevices

D. syslogs

Buy Now
Questions 10

Which of the following statements are true regarding free-space thresholds? (Choose 3)

A. They can be used on user defined segments.

B. They can be used on the transaction log.

C. They can be placed anywhere on the transaction log before the Last Chance ThresholD.

D. Each segment can have a maximum of 128 thresholds.

E. By default, only the Last Chance Threshold isactivE.

Buy Now
Questions 11

When the is crossed, active transactions will be suspended or aborteD.

A. default segment

B. last chance threshold

C. lock hash table

D. truncation marker

E. wash marker

Buy Now
Questions 12

Cross-platform dump and load requires (Choose 2)

A. additional syntax for the dump databasecommanD.

B. additional syntax for the online databasecommanD.

C. that all non-unique indexes be rebuilt following theloaD.

D. that all statistics be updated following theloaD.

E. thatservers use the same byte order.

Buy Now
Questions 13

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

A. sysdatabases

B. sysreferences

C. sysusages

D. sysdevices

E. sysconfiguresX

Buy Now
Exam Code: 510-025
Exam Name: Adaptive Server Enterprise 15.0 Administrator Associate Exam
Last Update: Mar 20, 2024
Questions: 120
10%OFF Coupon Code: SAVE10

PDF (Q&A)

$45.99

VCE

$49.99

PDF + VCE

$59.99