单选题The HR user creates a view with this command： SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp； Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario？（）A HR can grant the privilege to

题目内容(请给出正确答案)

单选题

The HR user creates a view with this command： SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp； Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario？（）

HR can grant the privilege to JIM but without GRANT OPTION.

HR can grant the privilege to JIM because HR is the owner of the view.

SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.

HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

多选题On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）AIt succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.BIt fails because no SQL *Loader data file location is specified.CIt fails if the HR user does not have the CREATE ANY DIRECTORY privilege.DIt fails because no SQL *Loader control file location is specified.

点击查看答案
第2题

单选题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.

点击查看答案
第3题

单选题The HR user creates a view with this command： SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp； Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario？（）A HR can grant the privilege to JIM but without GRANT OPTION.B HR can grant the privilege to JIM because HR is the owner of the view.C SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.D HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.

点击查看答案
第4题

单选题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.

点击查看答案
第5题

单选题A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?（）A When view V1 is createdB Each time the REFRESH VIEW v1 statement is executedC Each time an SQL statement is executed against view V1D Only the first time an SQL statement is executed against view V1

点击查看答案
第6题

单选题The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? （）A No privileges.B Only the SELECT privilege.C Only the CONNECT privilege.D All the privileges of a default user.

点击查看答案
第7题

单选题Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 isperformed（）A The table created by SKD is not accessible and SKD cannot create new tables.B The tables created by SKD and HR remain， but both cannot create new tables.C The table created by HR remains and HR still has the CREATE TABLE system privilege.D The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

点击查看答案

The HR user creates a view with this command： SQL> CREATE V

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容