单选题如果要启用所有角色，则应该使用哪一个命令？（）A SET ROLE ALLB SET ROLE ENABLE ALLC ALTER SESSION ALLD ALTER USER ROLE ALL

第1题：

第2题：

用来为一个用户分配概要文件的命令是（）。

• A、ALTER PROFILE
• B、ALTER USER
• C、SET PROFILE
• D、ALTER ROLE

第3题：

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

第4题：

The DBA is defining role for users. Which of the following is not an acceptable method for defining a default role?（）

• A、ALTER USER DEFAULT ROLE ALL
• B、ALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1
• C、ALTER USER DEFAULT ROLE NONE
• D、ALTER USER DEFAULT ROLE NONE EXCEPT ROLE_1

第5题：

You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level？（） 

• A、 issuing the ALTER SYSTEM ENABLE RESUMABLE；statement
• B、 issuing the ALTER SESSION ENABLE RESUMABLE；statement
• C、 modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
• D、 issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=；statement

第6题：

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 session
• B、SYSTEM sessions, regardless of the roles that are set in the session
• C、SCOTT sessions, only if the MGR role is set in the session
• D、SCOTT sessions, only if the MGR role is granted to SCOTT
• E、SCOTT sessions, because he is the owner of the table
• F、SYSTEM session, only if the MGR role is set in the session

第7题：

Examine the code：   CREATE ROLE readonly IDENTIFIES USING app.chk_readwrite ； CREATE ROLE readwrite IDENTIFIED USING app.chk_readwrite ；   CREATE OR REPLACE PROCEDURE app.chk_readwrite  AUTHID CURRENT_USER IS  ipchk STRING（30）；  BEGIN  IF sys_context（‘USERENV’，’ISDBA’）=’TRUE’  THEN DBMS_SESSION.SET_ROLE‘READWRITE’） ；  ELSE DBMS_SESSION.SET_ROLE（‘READONLY’） ；  END； /   Which three statements correctly describe the Secure Application role definition？（）

• A、No user or application has to remember or hide a password. 
• B、It prevents everyone except a true DBA session from acquiring the READWRITE role. 
• C、app.chk_readwrite is called whenever a user tries to access rows protected by the READONLY or READWRITE label. 
• D、app.chk_readwrite is called by users or applications when they want to enable the READONLY or READWRITE role.

第8题：

The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？ （）

• A、set the SESSIONS to 1 in the parameter file
• B、grant SINGLE SESSION privilege to all of the users
• C、set the SESSIONS_PER_USER to 1 in the users’ profile
• D、grant RESTRICTED SESSION privilege to all of the database users
• E、create a role with SINGLE SESSION privilege and assign the role to the users

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第14题：

When setting an access point to a non-root role， what two parameters，other than Role in theRadio Network，must be configured on the SSID Manager page？（）

• A、Infrastructure devices to associate only to this SSID
• B、Enable IP redirection on this SSID
• C、Set Data Beacon Rate
• D、Multiple Basic Service Set Identification （BSSID）
• E、Set infrastructure SSID

第15题：

假设需要在数据库中创建角色test_role，可以使用如下（）语句。

• A、ALTER DATABASE ROLE test_role
• B、CREATE ROLE test_role
• C、UPDATE ROLE test_role
• D、ALTER ROLE test_role

第16题：

You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）

• A、Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
• B、Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
• C、Data is never redacted for the EMP_V.SAL column.
• D、Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
• E、Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

第17题：

To allocate another role to a user, which command is most appropriate?（）

• A、ALTER USER 
• B、ALTER DATABASE 
• C、ALTER SYSTEM 
• D、GRANT

第18题：

You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for granting the required privileges？（）

• A、grant CONNECT role to all of the three users
• B、grant RESOURCE role to all of the three users
• C、grant both CONNECT and RESOURCE role to all of the three users
• D、execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users
• E、create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users

第19题：

The current time zone for one of the user sessions is set to the database local time zone. For one application， the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions. Which two solutions could the user implement to achieve this objective？ （）

• A、 use the ALTER SYSTEM command to change the time zone
• B、 use the ALTER SESSION command to change the time zone
• C、 use the ALTER DATABASE command to change the time zone
• D、 set the value for the operating system variable ORA_SDTZ on the client machine
• E、 set the value for the operating system variable ORA_SDTZ on the database server machine

第20题：

Examine these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do?（）

• A、The set of statements contains an error and does not work.
• B、It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
• C、It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
• D、It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.
• E、It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.
• F、It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.

第21题：

第22题：

第23题：