CIS 336 STUDY Extraordinary Life/cis336study.com CIS 336 STUDY Extraordinary 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 )