What of the following is TRUE about triggers?

What of the following is TRUE about triggers? A. Triggers are activated by INSERT, UPDATE, DELETE and SELECT statements B. Triggers can be used to perform data manipulation operations against complex views C. Triggers can only be used to execute logic before or after appropriate SQL statements D. Only one trigger for a particular event […]

Read More

What is the purpose of a role?

What is the purpose of a role? A. To define exactly what a specific user can and cannot do within a particular database once they have been authenticated B. To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges C. To group a collection of […]

Read More

Which of the following statements regarding locking is TRUE?

Which of the following statements regarding locking is TRUE? A. The same lock modes apply to tables, rows, or blocks B. Lock conversion can take place implicitly as a query executes C. Changing the mode of a lock that is already held is called lock escalation D. Lock conversion is not necessary if an X […]

Read More