Sybase, Inc 510-022 Exam

• Exam Number/Code : 510-022
• Exam Name : sybase adaptive server enterprise administrator professsional
• Questions and Answers : 120 Q&As
• Update Time: 2010-04-15

 

1. 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

2. 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
B. 3
C. 4
D. 5
E. 6
F. Unknown
Answer: F

3. What dboption must be true to fix allocation errors on a system table?
A. dbo only
B. no free space acctng.
C. select into/bulkcopy/pllsort
D. single user
E. trunc log on chkpt
Answer: D

4. Which of the following are true about the mount/unmount commands?
A. Mount detaches the database and its devices from ASE.
B. Only 1 database can be unmounted in a single unmount command.
C. The master database cannot be unmounted.
D. The mount/unmount commands require sybase_ts_role.
Answer: C

5. 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

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. Which of the following attributes are NOT set using sp_dbcc_updateconfig?
A. Maximum number of worker processes to use.
B. Size of the named cache to use.
C. Sizes of the of the workspaces to use.
D. Size of the extent IO buffer pool to use.
Answer: B

8. 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

9. 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

10. Which of the following statements about named caches are true in ASE? (Choose 4)
A. Named caches can be created dynamically.
B. Named caches can be dropped dynamically.
C. Named caches can be made larger dynamically.
D. Named caches can be made smaller dynamically.
E. Named cache partitions can be changed dynamically.
F. Named cache replacement policies can be changed dynamically.
Answer: CDEF

11. If a user-defined tempdb is unavailable at login the user will be placed in the system tempdb if ?
A. the binding was created using the soft option.
B. the binding was created using the hard option.
C. user tempdb belongs to a group.
D. the system tempdb is over 1 GB in size.
Answer: A

12. Which of the following dbcc commands can be run with a fix option?
A. dbcc checkalloc.
B. dbcc checkcatalog
C. dbcc checkdb.
D. dbcc checkstorage.
E. dbcc checkverify.
Answer: A

13. The dbcc checkverify command should be run ?
A. only once, to aid in configuring the dbccdb.
B. prior to creation of a new index, to ensure the table's page linkage is accurate.
C. prior to most dbcc commands, to ensure the database is in the proper state.
D. immediately following the dbcc checkstorage command.
E. immediately following any non-logged action.
Answer: D

14. 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.
Answer: A

15. Which of the following statements about the async log service async log service (DB option) Database
optionsasync log service is true?
A. async log service is a server-wide configuration parameter.
B. async log service can be enabled only in an ASE server with at least 4 engines.
C. async log service is designed to improve ASE performance by performing transaction log I/O using the largest
available buffer pool.
D. When enable, the async log service functionality is perfomed by additional, dedicated ASE system processes.
Answer: BD

16. Which of the following is the minimum size for object allocation for ASE 12.5 with a logical page size of 16K?
A. 16K
B. 32K
C. 64K
D. 128K
Answer: D

17. How would you locate the first OAM page for a given table?
A. has no fixed addresses
B. listed in sysindexes.
C. listed in sysobjects
D. listed in the GAM page
Answer: B

18. How are OAM pages linked?
A. Each OAM page is linked to its allocation page.
B. Linear page chain for APL; not linked for DOL.
C. No more than one OAM page per object, so no chain.
D. OAM pages are circularly linked.
Answer: D

19. 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 checkdb
D. dbcc checkstorage
E. dbcc checktable
Answer: BD

20. When should dbcc reindex be used?
A. after the sort order in ASE has been changed
B. when a new language has been installed in ASE.
C. when corruptions have been found in text/image page chains.
D. when corruptions have been found in indexes on system tables.
Answer: A