Author Question: Which of the following statements creates a new database role? A) CREATE LOGIN StudentLogIn WITH ... (Read 65 times)

waynest · **on:** Jul 7, 2018

Which of the following statements creates a new database role?

A) CREATE LOGIN StudentLogIn WITH PASSWORD='pssw0rd1',
DEFAULT_DATABASE=TutorManagement
B) CREATE ROLE StudentRole
C) GRANT EXEC ON usp_StudentLogIn TO StudentRole
D) EXEC sys.sp_addrolemembe r StudentRole, StudentUser

Question 2

The definition of hacking is accessing a computer resource without authorization or in excess of authorization.

Indicate whether the statement is true or false.