Which command can be used with "static options" to list all the static server configurationoptions?

A. sp_configure

B. sp_helpconfig

C. sp_monitorconfig

D. sp_poolconfig

E. sp_dboption

What is the system stored procedure used to display metadata cache usage statistics?

A. sp_configure

B. sp_helpconfig

C. sp_cacheconfig

D. sp_monitorconfig

What happens when a row is inserted into a list partitioned table but the key value is not within the list?

A. The row is inserted into the first partition.

B. The row is inserted into the last partition.

C. The insert fails with an errormessagE.

D. The insert is discarded without an errormessagE.

An expression used in a function based index MUST contain

A. a base column.

B. an aggregate function.

C. a computed column.

D. a search argument.

E. asubquery.

Automatic database expansion

A. can be configured to run diskinit.

B. is configured viasp_dbextenD.

C. is only available on file system devices, NOT raw partitions.

D. is only available on system databases.

E. occurs by default on user databases.

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 database option must be set to run dbcc checkalloc in fix mode?

A. dbo use only

B. ddl in tran

C. nochkpt on recovery

D. select into/bulkcopy/pllsort

E. single user

Which load database parameter is used to view the archive page size?

A. listonly

B. blocksize

C. dumpvolume

D. headeronly

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

Which of these minimally logged operations will NOT prevent a transaction log dump?

A. select into

B. truncate table

C. fast bcp

D. create index parallel

E. writetext

F. reorg rebuild