Which two statements are true?
A.
A role cannot be assigned external authentication.
B.
A role can be granted to other roles.
C.
A role can contain both system and object privileges.
D.
The predefined resource role includes the unlimited_tablespace privilege.
E.
All roles are owned by the sys user.
F.
The predefined connect role is always automatically granted to all new users at the time of their
creation.
Explanation:
http://docs.oracle.com/cd/E11882_01/network.112/e36292/authorization.htm#DBSEG99878 (the
functionality of roles)
BC
This on is BC
https://docs.oracle.com/database/121/DBSEG/authorization.htm#DBSEG99937
B C
B and C may be correct but D is as well. Unlimited tablespace is a privilege in the resource role. The number of correct answers for this question is off….
For D, please note that from 12c onwards, “Resource” role will not provide “unlimited tablespace” privilege and no longer available too. As we already know resource role is deprecated from 11g onwards and will not be available in future releases.
B and C are correct, in Oracle 12C “RESOURCE role will no longer grant the UNLIMITED TABLESPACE system privilege by default.”
http://docs.oracle.com/database/121/DBSEG/release_changes.htm#BABEBGDI
BC
B-C
BC
Downlaod new Madden 17 Coin Glitch and Generator game!
Best Madden NFL 17 Coinn Glitch and Generator for unlimied
Cash and Coins!
DOWNLOAD LINK : Madden NFL 17 Cooin Glich and Generator
B and C