510-022 Online Practice Questions and Answers

Which command can be used to extend the master device?

A. Disk init

B. Disk reint

C. Disk refit

D. Disk resize

Which of the following factors affect whether ASE will use large i/o when reading a table? (Choose 3)

A. How well the pages of the tables fill its extents.

B. Whether ASE has been built with a page size greater than 2kb

C. The current data cache hit rate in the cache to which the table is bound.

D. How well the logical clustering of the table matches its physical clustering.

E. At least one large I/O pool is configured in the cache to which the table is bound.

F. At least two large I/O pools are configured in the cache to which the table is bound.

During recovery of a failed master device, if the scripts required to run the disk reint commands are not available, the required device information may be obtained by

A. Executing the disk refit command.

B. Executing sp_helpdevice against the new master device.

C. Selecting the information from the old master..syspartitions table.

D. Checking the ASE error log from the last boot cycle.

Which ASE features can be used to determine the temporary database assigned to a session other than your own ? (Choose 2 )

A. The global variable @@tempdbid

B. The built-in function tempdb_ id()

C. The command bcc pravailabletempdb

D. sp_tempdb,with the how ?subcommand

E. sp_tempdb, with the who ?subcommand

F. sp_helpdb

ASE writes a Compensation Log Record

A. At the beginning of every transaction

B. At the beginning of every transaction log dump

C. If a logged data change is rolled back

D. If a logged data change is committed

Which of the following is NOT a valid number of cache artitions?

A. 1

B. 2

C. 3

D. 4

Examine the following page header:

PAGE HEADER: Page header for page 0xcf7a0000 Pagenno=872 nextpg=872 prevpg=872

What type of page is this?

A. GAM

B. Allocation

C. OAM

D. Dbinfo

Which of the following statements about OAM pages are true ? (Choose 2)

A. A proxy table can have multiple OAM pages

B. Each stored procedure, trigger or view has at least one OAM page

C. The OAM pages for an object are organized as a double-linked list

D. An OAM page points to extents where space for the object is allocated

E. An OAM page points to allocation units where space for an object is allocated

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

A. reorg rebuild

B. dbcc dbrepair

C. drop database

D. sp_dbcc_deletedb

Which of the following are true of a DOL Placement Index ? (Choose 2)

A. Structurally the same as a Clustered Index

B. Force new rows to be inserted in key order

C. Similar instructure to a non-clustered index

D. Does not force inserts to be in key order