Explanation:related function is HAS_PERMS_BY_NAME. 4. Syntax for fn_my_permissions function in SQL Server 2014 is :
A. fn_my_permissions ( securable , securable_class )
B. fn_my_permissions ( securable , ‘securable_class’ )
C. fn_my_permissions ( ‘securable’ , securable_class)
D. fn_my_permissions ( ‘securable’ , ‘securable_class’ )
Answer:A
Explanation:related function is HAS_PERMS_BY_NAME. 4. Syntax for fn_my_permissions function in SQL Server 2014 is :
A. fn_my_permissions ( securable , securable_class ) B. fn_my_permissions ( securable , ‘securable_class’ ) C. fn_my_permissions ( ‘securable’ , securable_class) D. fn_my_permissions ( ‘securable’ , ‘securable_class’ )
Explanation:securable is the name of the securable. If the securable is the server or a database, this value should be set to NULL. securable is a scalar expression of type sysname. securable can be a multipart name. 5. Point out the wrong statement :