（单选题）
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.
正确答案
答案解析
略
相似试题
（多选题）
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？（）
