Which two statements are true about the roles in the Oracle database？（）A、A role can be granted to itself.B、Roles are owned by the SYS user.C、Roles can be granted to other roles.D、A role cannot be assigned external authentication.E、A role can contain both system and object privileges.
Which two statements are true about the roles in the Oracle database？（）
- A、A role can be granted to itself.
- B、Roles are owned by the SYS user.
- C、Roles can be granted to other roles.
- D、A role cannot be assigned external authentication.
- E、A role can contain both system and object privileges.
相关考题：
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:Which two statements are true?() A. The C # # ROLE1 role is created in the root database and all the PDBs.B. The C # # ROLE1 role is created only in the root database because the container clause is not used.C. Privileges are granted to the C##A_ADMIN user only in the root database.D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.E. The statement for granting a role to a user fails because the CONTAINER clause is not used.
A redaction policy was added to the SAL column of the SCOTT.EMP table:All users have their default set of system privileges.For which three situations will data not be redacted?() A. SYS sessions, regardless of the roles that are set in the sessionB. SYSTEM sessions, regardless of the roles that are set in the sessionC. SCOTT sessions, only if the MGR role is set in the sessionD. SCOTT sessions, only if the MGR role is granted to SCOTTE. SCOTT sessions, because he is the owner of the tableF. SYSTEM session, only if the MGR role is set in the session
Which two statements are true regarding redundancy groups? ()(Choose two.) A. When priority settings are equal and the members participating in a cluster are initialized at the same time, the primary assigned to node 0.B. The preempt option determines the primary and secondary roles for redundancy group 0 during a failure and recoveryC. 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.
If Host Checker restrictions are applied at the role level and the "Allow access to the role if any ONE of the select policies is passed" option is unchecked, which two statements are true?() A. All roles are evaluated together.B. Each role is evaluated separately.C. Clients must pass all policies to access the role.D. Clients will pass as long as one policy is accepted.
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.
A system administrator wants to configure 802.1X on an Ethernet switch to enable access to specific parts of the network based on group memberships.How can the administrator accomplish this goal?（）A、Configure roles based on departments and assign access based on source IP address.B、Configure roles based on the user's manager and assign access based on the user's MAC addressC、Configure roles based on group memberships and assign a specific VLAN to the role.D、Configure roles based on RADIUS request attribute and assign a specific VLAN to the role.
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.
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
Which statement is true regarding redundancy groups？（）A、The preempt option determines the primary and secondary roles for redundancy group 0 during a failure and recovery scenario.B、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 1.C、The primary role can be shared for redundancy group 0 when the active-active option is enabled.D、Redundancy group 0 manages the control plane failover between the nodes of a cluster.
An outside vendor is eligible for the guest role and the contractor role when accessing your network, that is secured with the Junos Pulse Access Control Service.What is the default role-mapping behavior?（）A、The vendor must select a role from a list of eligible roles.B、The vendor must select a rule from a list of eligible rules.C、The vendor is automatically mapped to the first configured roleD、The vendor is automatically granted a merged role.
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
Examine the command： SQL ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）A、The SKD user cannot log in to the database instance.B、The objects owned by the SKD user are not accessible to any user.C、The other users can access the objects owned by the SKD user， on which they have access.D、The password for the SKD user expires and the user is forced to change the password at the next log in
Examine the command： SQL ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）A、The SKD user cannot log in to the database instance.B、The objects owned by the SKD user are not accessible to any user.C、The other users can access the objects owned by the SKD user， on which they have access.D、The password for the SKD user expires and the user is forced to change the password at the next log in.
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.
A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?（）A、SYS sessions, regardless of the roles that are set in the sessionB、SYSTEM sessions, regardless of the roles that are set in the sessionC、SCOTT sessions, only if the MGR role is set in the sessionD、SCOTT sessions, only if the MGR role is granted to SCOTTE、SCOTT sessions, because he is the owner of the tableF、SYSTEM session, only if the MGR role is set in the session
Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）A、System privileges apply only to the PDB in which they are used.B、Local users cannot use local system privileges on the schema of a common user.C、The granter of system privileges must possess the set container privilege.D、Common users connected to a PDB can exercise privileges across other PDBs.E、System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.
You issued the following block of code： SQLBEGIN 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.
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.
多选题Which two statements are true regarding redundancy groups？（）AWhen 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.BThe preempt option determines the primary and secondary roles for redundancy group 0 during a failure and recovery scenario.CRedundancy group 0 manages the control plane failover between the nodes of a cluster.DThe primary role can be shared for redundancy group 0 when the active-active option is enabled
多选题A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?（）ASYS sessions, regardless of the roles that are set in the sessionBSYSTEM sessions, regardless of the roles that are set in the sessionCSCOTT sessions, only if the MGR role is set in the sessionDSCOTT sessions, only if the MGR role is granted to SCOTTESCOTT sessions, because he is the owner of the tableFSYSTEM session, only if the MGR role is set in the session
单选题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（）AThe user must enable the role explicitly.BThe user can grant the role to other users.CThe user cannot use the role until the DBA enables it explicitly.DThe user can start using the role immediately without any changes
单选题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？（）AThe user cannot use the role at all.BThe role would not be granted to the user.CThe user needs to enable the role explicitly.DThe user can start using the role immediately.EThe user would have the admin option for the role.
多选题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?（）AIt will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.BIt contains username and passwords of database users who are members of the OSOPER operating system group.CIt contains usernames and passwords of database users who are members of the OSDBA operating system group.DIt will permit the use of lowercase passwords for database users who have granted the SYSDBA role.EIt will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
单选题View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been grantedthe CONNECT and RESOURCE roles only. The database administrator （DBA） grants MGR_ROLE to the userSKD by executing the command： SQL GRANT MGR_ROLE TO SKD WITH ADMIN OPTION； Which statement is true about the user SKD afterhe/she is granted this role（）A The user SKD can grant only the MGR_ROLE role to other users， but not the privileges in it.B The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.C The user SKD can grant the privileges in the MGR_ROLE role to other users， but not with ADMIN OPTION.D The user SKD can grant the privileges in the MGR_ROLE role to other users， but cannot revoke privilegesfrom them
多选题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?（）AIt will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.BIt contains username and passwords of database users who are members of the OSOPER operating system group.CIt contains usernames and passwords of database users who are members of the OSDBA operating system group.DIt will permit the use of lowercase passwords for database users who have granted the SYSDBA role.EIt will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
多选题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 system and object privileges.
单选题Which statement is true regarding redundancy groups？（）AThe preempt option determines the primary and secondary roles for redundancy group 0 during a failure and recovery scenario.BWhen 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 1.CThe primary role can be shared for redundancy group 0 when the active-active option is enabled.DRedundancy group 0 manages the control plane failover between the nodes of a cluster.