510-025 Online Practice Questions and Answers

Which of the following databases is used to store Job Scheduler information?

A. sybmigratedb

B. sybmgmtdb

C. sybsecurity

D. sybsystemdb

Specifying the server page is done during

A. createdatabasE.

B. createtablE.

C. server installation.

D. upgrade process.

Which of the following statements are true regarding free-space thresholds? (Choose 3)

A. They can be used on user defined segments.

B. They can be used on the transaction log.

C. They can be placed anywhere on the transaction log before the Last Chance ThresholD.

D. Each segment can have a maximum of 128 thresholds.

E. By default, only the Last Chance Threshold isactivE.

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

A. sysdevices

B. sysindexes

C. sysobjects

D. sysdatabases

E. sysusages

F. syspartitions

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

When loading a database that was dumped with compression

A. the load syntax does not need to specify the compression level.

B. the database does not need to include the exact dump compression level.

C. the load syntax could use a different compression level than the dump.

D. the load syntax does not need to use the word compression at all.

When rebuilding the master database without backups the disk refit command restores whichsystem tables? (Choose 2)

A. sysdatabases

B. sysreferences

C. sysusages

D. sysdevices

E. sysconfiguresX

What is the maximum configurable buffer pool size for a server configured with an 8Kpage size?

A. 8K

B. 16K

C. 32K

D. 64K

E. 128KX

Which of the following has permissions precedence?

A. The permission granted most recently

B. Group

C. Role

D. User

What is the value of @@trancount after the execution of a rollback transaction in a nestedtransaction?

A. 0

B. 1

C. Equal to the number of begin transaction statements executed

D. Equal to the number of begin transaction statements minus 1