510-025 Online Practice Questions and Answers

If a transaction places an update lock on a data page, what type of lock will a second transaction get if it attempts to read the data using a SELECT statement?

A. Another UPDATE lock

B. SHARED lock

C. EXCLUSIVE lock

D. No lock is placed as process will be blocked

Given the following partial histogram from optdiag, what percentage of the rows for thiscolumn have a value of 500.00? Step Weight Value 1 0.00000000 < 0.00 2 0.36899999 = 0.00

3 0.00000000 < 1000.00 4 0.07100000 = 1000.00 5 0.00000000 < 2000.00 6 0.06580000 = 2000.00

A. 0.0%

B. 36.9%

C. 7.1%

D. 6.6%

Maximum database size for 2K pages is?

A. 32 GB

B. 256 GB

C. 2 TB

D. 4 TB

E. 8 TB

What is the maximum system device size which ASE 15.0 can support?

A. 1 TB

B. 2 TB

C. 4 TB

D. 6 TB

Specifying the server page is done during

A. createdatabasE.

B. createtablE.

C. server installation.

D. upgrade process.

Which system tables contain information regarding segments? (Choose 3)

A. sysdevices

B. sysindexes

C. sysobjects

D. sysdatabases

E. sysusages

F. syspartitions

Why should data and log be located on separate devices? (Choose 2)

A. to ensure recoverability

B. reuse of space efficiently

C. ease of maintenance

D. improves performance

E. improvesdbcc checkstorage performance

Which of the following is true regarding the execution of dbcc checkstorage?

A. Named cache must be configured

B. Large buffer pool must be configured

C. Workspace segments must be configured

D. Number of worker processes must be configured greater than 2

Which of the following statements are NOT true about database dumps? (Choose 2)

A. performs a checkpoint

B. backs up the transaction log

C. truncates the transaction log

D. may dump unallocated pages

E. cannot be run while anyone is in the database

Which of the following privileges are associated with the Systems Security Officer role?

A. The ability to shut down the server

B. The ability to back up any database

C. The ability to perform a disk init or diskresize command

D. The ability to create user-defined roles