网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Which of the following approval member groups can an organization administrator grant privileges to？（）
- A、ApprovalGroup
- B、Order Process
- C、User Group
- D、User Registration
- E、AccessGroup
参考答案
更多 “Which of the following approval member groups can an organization administrator grant privileges to？（）A、ApprovalGroupB、Order ProcessC、User GroupD、User RegistrationE、AccessGroup” 相关考题
考题
The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? ()
A. GRANT select ON dept TO ALL_ USER;B. GRANT select ON dept TO ALL;C. GRANT QUERY ON dept TO ALL_USERSD. GRANT select ON dept TO PUBLIC;
考题
The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）A. Alice onlyB. Alice and ReenaC. Alice, Reena, and TimberD. Sue, Alice, Reena, and Timber
考题
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.
考题
Which of the following groups should a user be added to for the ability to restore files, withoutgranting any ownership privileges?()
A. Remote Desktop UsersB. Power UsersC. AdministratorsD. Backup Operators
考题
Which of the following is the access level of a user that belongs to both the Administrators andUsers groups?()
A. UserB. AdministratorC. Power UserD. Remote Desktop User
考题
Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?()
A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrpB.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrpD.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
考题
Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?()
A.REVOKE ALL PRIVILEGES FROM USER tomB.REVOKE ALL ON EMPLOYEE FROM USER tomC.REVOKE EXECUTE ON EMPLOYEE FROM USER tomD.REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
考题
Which of the following privileges permits a user to update the comment on a sequence?()
A.CONTROLB.UPDATEC.USAGED.ALTER
考题
The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command： GRANT ALL ON orders， order_items TO PUBLIC； What correction needs to be done to the above statement？ （）A、 PUBLIC should be replaced with specific usernames.B、 ALL should be replaced with a list of specific privileges.C、 WITH GRANT OPTION should be added to the statement.D、 Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.
考题
Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）A、GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrpB、GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1C、GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrpD、GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
考题
Which of the following is the access level of a user that belongs to both the Administrators andUsers groups?（）A、UserB、AdministratorC、Power UserD、Remote Desktop User
考题
Which of the following groups should a user be added to for the ability to restore files, withoutgranting any ownership privileges?（）A、Remote Desktop UsersB、Power UsersC、AdministratorsD、Backup Operators
考题
Which role should a site administrator assign to a user in the selling organization to allow the user to manage suborganizations and users in their organization？（）A、Organization AdministratorB、SellerC、Seller AdministratorD、Store AdministratorE、Account Representative
考题
Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）A、REVOKE ALL PRIVILEGES FROM USER tomB、REVOKE ALL ON EMPLOYEE FROM USER tomC、REVOKE EXECUTE ON EMPLOYEE FROM USER tomD、REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
考题
If a parent organization is not specified when registering a user， which organization will the user be a member of？（）A、Buyer OrganizationB、Default OrganizationC、No OrganizationD、Root OrganizationE、Seller Organization
考题
Which of the following privileges permits a user to update the comment on a sequence?（）A、CONTROLB、UPDATEC、USAGED、ALTER
考题
The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?（）A、GRANT select ON dept TO ALL_ USER;B、GRANT select ON dept TO ALL;C、GRANT QUERY ON dept TO ALL_USERSD、GRANT select ON dept TO PUBLIC;
考题
You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）A、The tablespace TBS1 is full.B、The user is not the owner of the SYSTEM tablespace.C、The user does not have quota on the TBS1 tablespace.D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.E、The user does not have sufficient privileges to create table on the default permanent tablespace.
考题
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.
考题
The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）A、Alice onlyB、Alice and ReenaC、Alice, Reena, and TimberD、Sue, Alice, Reena, and Timber
考题
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.
考题
The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command： SQL GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim； Now， the user HR decides to revoke privileges from JIM using this command： SQL REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）A、The command fails because SCOTT still has privileges.B、The command succeeds and privileges are revoked from JIM.C、The command fails because HR cannot revoke the privileges from JIM.D、The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.
考题
单选题The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command： GRANT ALL ON orders， order_items TO PUBLIC； What correction needs to be done to the above statement？ （）A
PUBLIC should be replaced with specific usernames.B
ALL should be replaced with a list of specific privileges.C
WITH GRANT OPTION should be added to the statement.D
Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.
考题
单选题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
考题
多选题An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?（）AYou can conned as a common user by using the connect statement.BYou can connect as a local user by using the connect statement.CYou can connect by using easy connect.DYou can connect by using OS authentication.EYou can connect by using a Net Service name.FYou can connect as a local user by using the SET CONTAINER statement.
考题
多选题Which of the following approval member groups can an organization administrator grant privileges to？（）AApprovalGroupBOrder ProcessCUser GroupDUser RegistrationEAccessGroup
考题
单选题Which role should a site administrator assign to a user in the selling organization to allow the user to manage suborganizations and users in their organization？（）A
Organization AdministratorB
SellerC
Seller AdministratorD
Store AdministratorE
Account Representative
热门标签
最新试卷