Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Sybase 510-022
Title
: Sybase Adaptive Server
Enterprise Administrator
Professional
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. Which of the following pages is NOT found on an allocation unit?
A. Data
B. Index
C. OAM
D. GAM
E. Control
F. None of the above
Answer: E
2. The first page on a device fragment must? (Choose 2)
A. be listed in the lstart column of sysusages.
B. be listed in the low column of sysdevices.
C. be an OAM page.
D. be an allocation page.
E. have a logical page number that is a multiple of 1024.
Answer: AD
3. How many allocation pages are created in a 4 MB database (assuming 4K page size)?
A. 2
B. 4
C. 8
D. 16
Answer: B
4. Consider the following page header:
PAGE HEADER:
pageno=720 nextpg=0 prevpg=0 objid=64000228 timestamp=0000 000022b5
nextrno=5 level=0 indid=0 freeoff=150 minlen=6
How many data rows are currently on this page?
A. 0
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
B. 3
C. 4
D. 5
E. 6
F. Unknown
Answer: F
5. Whcih SQL statement finds the first page of sysgams"
A. select first from sysobjects where id = object_id("sysgams")
B. select first from sysindexes where id = object_id("sysgams")
C. select first from syscolumns where id = object_id("sysgams")
D. select first from sysgams
Answer: B
6. All of the following are causes of fragmentation in a table EXCEPT
A. no clustered index
B. page splits
C. row level locking
D. too many indexes
Answer: D
7. 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. None of the pages of this extent are in use.
B. The OAM page for this table is page 5121.
C. This table has a nonclustered index.
D. The first page of this extent is 5336.
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You