CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your Life/cis336study.com | Page 14

Oracle will raise and error and all current transactions will be rolled back.

8.( TCO 10) Which of the following commands is used to establish a user account?( Points: 4)

CREATE NEW USER username IDENTIFIED BY password; CREATE USERNAME username IDENTITY password; CREATE USER username PASSWORD password; CREATE USER username IDENTIFIED BY password;

9.( TCO 10) Which command will grant a system privilege to a user?( Points: 4)

GRANT systemprivilegeUSERNAME username GRANT PRIVILEGE systemprivilegeTO username GRANT systemprivilegeTO username GRANT systemprivilege ON Username ============================================= CIS 336 Final Exam 2( Devry)

Oracle will raise and error and all current transactions will be rolled back.

8.( TCO 10) Which of the following commands is used to establish a user account?( Points: 4)

CREATE NEW USER username IDENTIFIED BY password; CREATE USERNAME username IDENTITY password; CREATE USER username PASSWORD password; CREATE USER username IDENTIFIED BY password;

9.( TCO 10) Which command will grant a system privilege to a user?( Points: 4)

GRANT systemprivilegeUSERNAME username GRANT PRIVILEGE systemprivilegeTO username GRANT systemprivilegeTO username GRANT systemprivilege ON Username ============================================= CIS 336 Final Exam 2( Devry)