510-022 by Sybase Actual Free Exam Q&As

Question 1

During a rebuild of the master database, disk reinit is warranted when.

A. the master database is larger than 100 mb B. a valid backup of master is not available C. the model database has been modified D. to recreate server logins

Discussion 0

Correct Answer: B Vote an answer

Question 2

Which of the following dbcc commands can be run with a fix? Option?

A. Dbcc checkstorage. B. Dbcc checkdb. C. Dbcc checkcatalog D. Dbcc checkverify. E. dbcc checkalloc.

Discussion 0

Correct Answer: E Vote an answer

Question 3

Which of the following is true for an ASE timestamp?

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

Discussion 0

Correct Answer: A Vote an answer

Question 4

How would you locate the first OAM page for a given table?

A. listed in sysindexes B. has no fixed addresses C. listed in the GAM page D. listed in sysobjects

Discussion 0

Correct Answer: A Vote an answer

Question 5

Which of the following statements about update statistics behavior are true in ASE?
(Choose two)

A. Using sampled statistics can improve the accuracy of statistics B. Using sampled statistics can improve the concurrency of update statistics C. Update statistics can be run on a subset of data, expressed as a number of rows D. Using sampled statistics can improve the response time of update statistics E. Update statistics can be run on a subset of data, expressed as a percentage

Discussion 0

Correct Answer: D,E Vote an answer

Question 6

A DBA suspects a leaf-level index pointer does not point to the proper data pages. Which command can be used to verify this?

A. dbcc tablealloc B. dbcc checkstorage C. dbcc indexalloc D. dbcc checktable

Discussion 0

Correct Answer: D Vote an answer

Question 7

The improved recovery feature requires:

A. No additional configuration B. user configured large IO buffer pool C. #Umber of chackpoint tasks?1 D. #ax concurrently recovered db?>1

Discussion 0

Correct Answer: A Vote an answer

Sybase adaptive server Enterprise administrator professsional - 510-022 Exam Practice Test