Sybase adaptive server Enterprise administrator professsional

QUESTION NO: 1
Which of the following commands will not delete statistics?

A. delete statistics B. alter table?drop column C. drop table D. alter table?modify column. E. drop index

Correct Answer: E

QUESTION NO: 2
What dboption must be trunk to fix allocation errors on a system table?

A. no free space acctng B. dbo only C. select into/bulkcopy/pllsort D. trunc log on chkpt E. single user

Correct Answer: E

QUESTION NO: 3
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 checkalloc B. dbcc checkcatalog. C. Dbcc checktable D. Dbcc checkdb E. Dbcc checkstorage

Correct Answer: B,E

QUESTION NO: 4
If there are 8 duplicate key values referenced by a single APL index page, how many times is that key stored on that index page?

A. 1 B. 8 C. 7 D. 2 E. 4

Correct Answer: B

QUESTION NO: 5
Which of the following is true for an ASE timestamp?

A. It is identical for all databases on a single ASE server B. It is the date and time the database was last modified C. It cannot be selected using SQL commands D. It is a sequence number incremented when the database is modified

Correct Answer: D

QUESTION NO: 6
Which of the following attributes are NOT set using sp_dbcc_updateconfig?

A. Size of the named cache to use B. Size of the of the workspaces to use C. Size of the extent IO buffer pool to use D. Maximum number of worker processes to use

Correct Answer: A

QUESTION NO: 7
The DBTABLE structure?(Choose three)

A. Is flushed to disk during checkpoints B. Is stored in memory C. Is stored on disk in page 24 of every database D. Is persistent across ASE reboots E. Contains the highest timestamp for a database

Correct Answer: A,B,C

QUESTION NO: 8
Given the following information from allocation page 768, how many pages are presently used in extent #800?
Extend ID 800 on allocation page 768
Object ID is 560001995
Index ID is 1
Extent Partition ID (Virtual) is 1
Allocation bitmap: 0x3c

A. 1 B. 3 C. 5 D. 2 E. 4

Correct Answer: E

QUESTION NO: 9
Which of the following statistics is stored in the systatistics table?

A. OAM page count B. Row count C. Total density D. Leaf count

Correct Answer: C

Sybase adaptive server Enterprise administrator professsional - 510-022 Exam Questions