Sybase adaptive server Enterprise administrator professsional (510-022) Free Practice Test

Question 1

Overflow pages are used to manage duplicate entries in

A. APL nonclustered indexes

B. APL clustered indexes

C. DOL nonclustered indexes

D. DOL clustered indexes

Correct Answer: B

Question 2

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

A. listed in sysobjects

B. listed in the GAM page

C. listed in sysindexes

D. has no fixed addresses

Correct Answer: C

Question 3

The Undo pass recovery phase scans[]

A. from the beginning of the log to the oldest active transaction's row id.

B. From the secondary truncation point row id to the end of the log.

C. From the checkpoint record's row id for the oldest active transaction to the end of the log.

D. From the end of the log to the oldest incomplete transaction's row id.

E. From the checkpoint record to the end of the log.

Correct Answer: D

Question 4

Which of the following can be used to drop a corrupt or suspect database?

A. reorg rebuild

B. sp_dbcc_deletedb

C. dbcc dbrepair

D. drop database

Correct Answer: C

Question 5

A checkpoint command writes ______ to disk.

A. Only command changes

B. Committed and uncommitted changes

C. Just log pages

D. Only pages that passed the wash marker

Correct Answer: B

Question 6

Which of the following can prevent ASE from performing a large I/O? (Choose three)

A. There are no buffers available in the requested pool to perform the large I/O

B. The page is in a system table

C. The page is already in another pool

D. The page is in the first extent of an allocation unit

E. The #sync? Property on that device is set to #else?

Correct Answer: A,C,E

Question 7

Which of the following is true for an ASE timestamp?

A. It cannot be selected using SQL commands

B. It is a sequence number incremented when the database is modified

C. It is the date and time the database was last modified

D. It is identical for all databases on a single ASE server

Correct Answer: B

Question 8

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

A. user tables

B. temporary tables

C. cursors

D. derived tables

E. views

Correct Answer: A,D,E

Question 9

What is the page number of the first GAM page of a database?

A. 256

B. 128

C. 72

D. No fixed value

Correct Answer: D

Question 10

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

A. partition the cache

B. use MRU replacement

C. create a large I/O pool

D. expand metadata caches

Correct Answer: A

Welcome to TestSimulate

Sybase adaptive server Enterprise administrator professsional (510-022) Free Practice Test