Point out the correct statement :
A. In versions of SQL Server through SQL Server 2014, sub-securables cannot use brackets in the form ‘[sub name]’. Use ‘sub name’ instead.
B. HAS_PERMS_BY_NAME returns NULL when the query fails.
C. In ADO.net, the sub-securable_class argument is valid only if the securable_class argument is set to OBJECT.
D. None of the mentioned
Answer:A
Point out the correct statement :
A. In versions of SQL Server through SQL Server 2014, sub-securables cannot use brackets in the form ‘[sub name]’. Use ‘sub name’ instead. B. HAS_PERMS_BY_NAME returns NULL when the query fails. C. In ADO.net, the sub-securable_class argument is valid only if the securable_class argument is set to OBJECT. D. None of the mentioned
Explanation: Use ‘sub name’ instead of ‘[sub name]’. 3. _________ returns a list of the permissions effectively granted to the principal on a securable.