单选题如果要启用所有角色，则应该使用哪一个命令？（）ASET ROLE ALLBSET ROLE ENABLE ALLCALTER SESSION ALLDALTER USER ROLE ALL
单选题
如果要启用所有角色，则应该使用哪一个命令？（）
A
SET ROLE ALL
B
SET ROLE ENABLE ALL
C
ALTER SESSION ALL
D
ALTER USER ROLE ALL
参考解析
解析：
暂无解析
相关考题：
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
要使“商品”表中所有商品的单价上浮10%，正确的SQL命令是（ ）。A. ALTER商品SET单价=单价*1．1 FOR ALLB. UPDATE商品SET单价=单价+单价*10%C. UPDATE商品SET单价=单价*1．1 FOR ALLD. UPDATE商品SET单价=单价*1．1
Examinethecode：CREATEROLEreadonlyIDENTIFIESUSINGapp.chk_readwrite；CREATEROLEreadwriteIDENTIFIEDUSINGapp.chk_readwrite；CREATEORREPLACEPROCEDUREapp.chk_readwriteAUTHIDCURRENT_USERISipchkSTRING（30）；BEGINIFsys_context（‘USERENV’，’ISDBA’）=’TRUE’THENDBMS_SESSION.SET_ROLE‘READWRITE’）；ELSEDBMS_SESSION.SET_ROLE（‘READONLY’）；END；/WhichthreestatementscorrectlydescribetheSecureApplicationroledefinition？（）A.Nouserorapplicationhastorememberorhideapassword.B.ItpreventseveryoneexceptatrueDBAsessionfromacquiringtheREADWRITErole.C.app.chk_readwriteiscalledwheneverausertriestoaccessrowsprotectedbytheREADONLYorREADWRITElabel.D.app.chk_readwriteiscalledbyusersorapplicationswhentheywanttoenabletheREADONLYor READWRITErole.
如果要启用所有角色,则应该使用哪一个命令?() A.SET ROLE ALLB.SET ROLE ENABLE ALLC.ALTER SESSION ALLD.ALTER USER ROLE ALL
假设需要在数据库中创建角色test_role,可以使用如下()语句。 A.ALTER DATABASE ROLE test_roleB.CREATE ROLE test_roleC.UPDATE ROLE test_roleD.ALTER ROLE test_role
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.
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 SSIDB、Enable IP redirection on this SSIDC、Set Data Beacon RateD、Multiple Basic Service Set Identification （BSSID）E、Set infrastructure SSID
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
假设需要在数据库中创建角色test_role，可以使用如下（）语句。A、ALTER DATABASE ROLE test_roleB、CREATE ROLE test_roleC、UPDATE ROLE test_roleD、ALTER ROLE test_role
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 ALLB、ALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1C、ALTER USER DEFAULT ROLE NONED、ALTER USER DEFAULT ROLE NONE EXCEPT ROLE_1
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.
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；statementB、 issuing the ALTER SESSION ENABLE RESUMABLE；statementC、 modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD、 issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=；statement
To allocate another role to a user, which command is most appropriate?（）A、ALTER USER B、ALTER DATABASE C、ALTER SYSTEM D、GRANT
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
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 usersB、grant RESOURCE role to all of the three usersC、grant both CONNECT and RESOURCE role to all of the three usersD、execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three usersE、create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users
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.
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 zoneB、 use the ALTER SESSION command to change the time zoneC、 use the ALTER DATABASE command to change the time zoneD、 set the value for the operating system variable ORA_SDTZ on the client machineE、 set the value for the operating system variable ORA_SDTZ on the database server machine
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 fileB、grant SINGLE SESSION privilege to all of the usersC、set the SESSIONS_PER_USER to 1 in the users’ profileD、grant RESTRICTED SESSION privilege to all of the database usersE、create a role with SINGLE SESSION privilege and assign the role to the users
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.
单选题The DBA is defining role for users. Which of the following is not an acceptable method for defining a default role?（）AALTER USER DEFAULT ROLE ALLBALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1CALTER USER DEFAULT ROLE NONEDALTER USER DEFAULT ROLE NONE EXCEPT ROLE_1
多选题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 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?（）AData is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.BData is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.CData is never redacted for the EMP_V.SAL column.DData is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.EData is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
单选题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.
单选题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? （）AThe set of statements contains an error and does not work.BIt 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.CIt 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.DIt creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.EIt creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.FIt creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.
单选题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？（）Agrant CONNECT role to all of the three usersBgrant RESOURCE role to all of the three usersCgrant both CONNECT and RESOURCE role to all of the three usersDexecute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three usersEcreate role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users