多选题Which two statements are true about the roles in the Oracle database？（）AA role can be granted to itself.BRoles are owned by the SYS user.CRoles can be granted to other roles.DA role cannot be assigned external authentication.EA role can contain both sy

第1题：

Which two statements are true about using the isUserInRole method to implement security in a Java EEapplication？（）

• A、It can be invoked only from the doGet or doPost methods.
• B、It can be used independently of the getRemoteUser method.
• C、Can return "true" even when its argument is NOT defined as a valid role name in the deployment descriptor.
• D、Using the isUserInRole method overrides any declarative authentication related to the method in which it is invoked.

第2题：

View the Exhibit to observe the roles assigned to the SL_REP user.  Which statement is true about theassignment of the SELECT_CATALOG_ROLE role to the SL_REP user（）

• A、The user must enable the role explicitly.
• B、The user can grant the role to other users.
• C、The user cannot use the role until the DBA enables it explicitly.
• D、The user can start using the role immediately without any changes

第3题：

第4题：

You issued the following block of code：        SQL>BEGIN   DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（        ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）；        END；        SQL>/   Which option is NOT a result of executing the above code？（）  

• A、 The switch privilege is granted to the PROG_ROLE role.
• B、 The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.
• C、 The users cannot grant the switch privilege to other users.
• D、 The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.

第5题：

Which two statements accurately describe a role?（）

• A、A role can be given to a maximum of 1000 users.
• B、A user can have access to a maximum of 10 roles.
• C、A role can have a maximum of 100 privileges contained in it.
• D、Privileges are given to a role by using the CREATE ROLE statement.
• E、A role is a named group of related privileges that can be granted to the user.
• F、A user can have access to several roles, and several users can be assigned the same role.

第6题：

Which two statements are true regarding redundancy groups？（）

• A、When priority settings are equal and the members participating in a cluster are initialized at the same time， the primary role for redundancy group 0 is assigned to node 0.
• B、The preempt option determines the primary and secondary roles for redundancy group 0 during a failure and recovery scenario.
• C、Redundancy group 0 manages the control plane failover between the nodes of a cluster.
• D、The primary role can be shared for redundancy group 0 when the active-active option is enabled

第7题：

Which two statements are true regarding a PL/SQL package body？（）

• A、It cannot be created without a package specification.
• B、It cannot invoke subprograms defined in other packages.
• C、It can contain only the subprograms defined in the package specification.
• D、It can be changed and recompiled without making the package specification invalid.

第8题：

You work as a database administrator for Certkiller .com. While granting a role，SELECT_CATALOG_ROLE， to a user， Certkiller， using Oracle Enterprise Manager 10g Database Control， you have cleared the DEFAULT check box. What will be the result？（）

• A、The user cannot use the role at all.
• B、The role would not be granted to the user.
• C、The user needs to enable the role explicitly.
• D、The user can start using the role immediately.
• E、The user would have the admin option for the role.

第9题：

Examine the commands executed in the following sequence：  1：SQL> CREATE ROLE mgrrole；  2：SQL> GRANT create user，select any table，connect，resource TO mgrrole；  3：SQL> GRANT select，update ON sh.sales TO mgrrole；  4：SQL> CREATE ROLE ceo IDENTIFIED BY boss；  5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo；  6：SQL> GRANT ceo TO mgrrole；  Which statement is true about the above commands（）

• A、The commands execute successfully.
• B、Command 6 produces an error because of circular role grant.
• C、Command 5 produces an error because a role cannot be granted to another role.
• D、Command 3 produces an error because the MGRROLE role already contains system privileges.
• E、The table created by HR remains and HR still has the CREATE TABLE system privilege.
• F、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

第10题：

You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two statements are true about the password file?（）

• A、It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
• B、It contains username and passwords of database users who are members of the OSOPER operating system group.
• C、It contains usernames and passwords of database users who are members of the OSDBA operating system group.
• D、It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
• E、It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.