最新的Sybase Certification認證 510-022考試題庫

問題1

Given the following information from an allocation page, which of the following is NOT true?
OAMPG: 5121 Extent ID 5336
Object ID is 1264004503
Index ID is 2
Allocation bitmap: 0xff

A. The OAM page for this table is page 5121.

B. None of the pages of this extent are in use.

C. This table has a nonclustered index.

D. The first page of this extent is 5336

正確答案: B

問題2

If a user-defined tempbd is unavailabale at login the user will be placed in the system tempdb if?

A. The system tempdb is over 1 GB in size.

B. The binding was created using the hard option.

C. User tempdb belongs to a group.

D. the binding was created using the soft option.

正確答案: D

問題3

When setting the value for the configuration option "number of open object:, you must condsider which object types? (choose 3)

A. derived tables

B. views

C. temporary tables

D. cursors

E. user tables

正確答案: A,B,E

問題4

Which of the following commands will not perform a checkpoint on the database?

A. dump database

B. dump tran....with truncate_only

C. dump tran

D. dump tran...with no_truncate

正確答案: D

問題5

Which of the following statements about the ASE transaction log are TRUE? (Choose three)

A. The size of a transaction log dump is proportional to the amount truncated

B. A database can be brought online for read only access after loading a transaction dump, without preventing further loads

C. The trnsaction log can be truncated up to the oldest checkpoint

D. Consecutive dumps of the transaction log must overlap log pages

E. The transaction log can be truncated up to the oldest committed transaction

正確答案: A,E

問題6

Which of the following is the minimum size for object allocation for ASE 12.5 with a logical page size of 16k?

A. 32K

B. 64K

C. 16K

D. 128K

正確答案: D

問題7

Running dbcc tablealloc(titles, optimized) will

A. Identify only allocation errors based on the OAM page entries

B. Identify all allocation errors on titles

C. Identify all allocation errors on titles and its indexes

D. Identify only allocation errors on referenced pages

正確答案: A

問題8

Select name, ((high-low+1)-sum(size)) from sysdevices, sysusages where cstart between low and high and type <>16 group by name The above code displays the :

A. Size of each database and the free space is available

B. Size of each device and the free space available

C. Size of each table and the free space available

D. Size of the transaction log and the free space available

正確答案: B

問題9

When performance suffers due to spinlock contention on a named cache the SA can
_____________

A. expand metadata caches

B. use MRU replacement

C. partition the cache

D. create a large I/O pool

正確答案: C

問題10

For a database with its log on a separate device, which of the following dbcc commands show the percentage of free log space? (choose 2)

A. Dbcc checkstorage

B. dbcc checkalloc

C. Dbcc checkdb

D. dbcc checkcatalog.

E. Dbcc checktable

正確答案: A,D

最新的Sybase adaptive server Enterprise administrator professsional - 510-022免費考試真題

最新更新

站內鏈接

聯系我們