单选题

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?()

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

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

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

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

正确答案

来源:www.examk.com

答案解析

相似试题
  • You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb  Which three statements are correct regarding the connection string?()

    多选题查看答案

  • Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client  whileconnecting to the database instance from a remote machine()

    单选题查看答案

  • 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()

    单选题查看答案

  • Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client  while connecting to the database instance from a remote machine()

    单选题查看答案

  • Given: Which two classes use the Shape class correctly?()

    多选题查看答案

  • In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file:  In what sequence would you use this process to perform the recovery?()

    单选题查看答案

  • Which two statements are true regarding the starting of the database instance using the following command?() SQL>STARTUP UPGRADE  

    多选题查看答案

  • Assuming that the serializeBanana() and the deserializeBanana() methods will correctly use Javaserialization and given: What is the result?()

    单选题查看答案

  • Which statement is true about loading data using the conventional path of SQL*Loader()

    单选题查看答案

  • You are connecting to an Oracle database server from a client by using the following connect string:  SQL> CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb  Which naming method is being used in this case?()

    单选题查看答案