Which of the following approval member groups can an organization administrator grant privileges to？（）A、ApprovalGroupB、Order ProcessC、User GroupD、User RegistrationE、AccessGroup

第1题：

第2题：

第3题：

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.

第4题：

Which of the following is the access level of a user that belongs to both the Administrators andUsers groups?（）

• A、User
• B、Administrator
• C、Power User
• D、Remote Desktop User

第5题：

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 Administrator
• B、Seller
• C、Seller Administrator
• D、Store Administrator
• E、Account Representative

第6题：

If a parent organization is not specified when registering a user， which organization will the user be a member of？（）

• A、Buyer Organization
• B、Default Organization
• C、No Organization
• D、Root Organization
• E、Seller Organization

第7题：

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_USERS
• D、GRANT select ON dept TO PUBLIC;

第8题：

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.

第9题：

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.

第10题：

第11题：

第12题：

第13题：

第14题：

第15题：

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 appgrp
• B、GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1
• C、GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp
• D、GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom

第16题：

Which of the following groups should a user be added to for the ability to restore files, withoutgranting any ownership privileges?（）

• A、Remote Desktop Users
• B、Power Users
• C、Administrators
• D、Backup Operators

第17题：

Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）

• A、REVOKE ALL PRIVILEGES FROM USER tom
• B、REVOKE ALL ON EMPLOYEE FROM USER tom
• C、REVOKE EXECUTE ON EMPLOYEE FROM USER tom
• D、REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom

第18题：

Which of the following privileges permits a user to update the comment on a sequence?（）

• A、CONTROL
• B、UPDATE
• C、USAGE
• D、ALTER

第19题：

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.

第20题：

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 only
• B、Alice and Reena
• C、Alice, Reena, and Timber
• D、Sue, Alice, Reena, and Timber

第21题：

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.

第22题：

第23题：