On multiple choice questions like this, it would be best if they did not say "(Select 2)", because four of the options will "use up" those two options: either the database is marked as trustworthy or it is not marked as trustworthy, and either the database will be set to read only or the database will not be set to read only. That means that the other two options must be false.

Aside from that minor suggestion, I do like this question, because it makes you think about which keywords are reserved and which are not (even though it's not a good idea to use a keyword for a database name), and it's interesting that a setting that is changed by ALTER DATABASE is not actually stored in the database.

stephen.long 56048 (2/20/2014)On multiple choice questions like this, it would be best if they did not say "(Select 2)", because four of the options will "use up" those two options: either the database is marked as trustworthy or it is not marked as trustworthy, and either the database will be set to read only or the database will not be set to read only. That means that the other two options must be false.

Aside from that minor suggestion, I do like this question, because it makes you think about which keywords are reserved and which are not (even though it's not a good idea to use a keyword for a database name), and it's interesting that a setting that is changed by ALTER DATABASE is not actually stored in the database.