单项选择题

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.

<上一题目录下一题>

热门试题

多项选择题Datafilesofwhichthreetablespacescanberecoveredbyperforminganopenrecovery？（）

A.TEMP
B.UNDO
C.INDEX
D.SYSAUX
E.SYSTEM

单项选择题Youareworkingonthe24X7databasewithhightransactionvolume，toensurefasterinstancerecoveryonyourdatabaseyousettheFAST_START_MTTR_TARGETinitializationparametertoaverylowvalue.Whateffectitwillhaveonthedatabase？（）

A.The database performance would be enhanced.
B.The redo log files would be get filled more frequently.
C.The overall database performance would be degraded.
D.The mean time to recover （MTTR） would be increased.

多项选择题Whichtwostatementsaretrueabouttheprimarykeyconstraintinatable？（）

A.It is not possible to disable the primary key constraint.
B.It is possible to have more than one primary key constraint in a single table.
C.The primary key constraint can be referred by only one foreign key constraint.
D.The primary key constraint can be imposed by combining more than one column.
E.The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.

单项选择题Youareusingflatfilesasthedatasourceforoneofyourdatawarehousingapplications.YouplantomovethedatafromtheflatfilestructurestoanOracledatabasetooptimizetheapplicationperformance.Inyourdatabaseyouhaveclusteredtables.Whilemigratingthedata，youwanttohaveminimalimpactonthedatabaseperformanceandoptimizethedataloadoperation.WhichmethodwouldyouusetoloaddataintoOracledatabase？（）

A.use the external table population
B.use the Oracle Data Pump export and import utility
C.use the conventional path data load of SQL*Loader utility
D.use the direct path data load of Oracle export and import utility

单项选择题Inyourdatabase，theSTATISTICS_LEVELinitializationparameterissettoBASIC.Whatistheimpactofthissetting？（）

A.The optimizer statistics are collected automatically.
B.Only the timed operating system （OS） statistics and plan execution statistics are collected.
C.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
D.The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.
E.Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

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？（）

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？（）