当前位置:1Z0-052题库

问题:

[单选]

The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users: 
CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2, v_mgr NUMBER, v_loc NUMBER) BEGIN 
INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc); END; 
The users having permission to execute the procedure are able to insert records into the 
DEPARTMENTStable even though they do not have the INSERT privilege on the table. You want only those users whohave privileges on the DEPARTMENTS table to be able to execute the procedure successfully. 
What would you suggest to the PL/SQL developers to achieve this()

A . Create the procedure with definer’s right.
B . Create the procedure with invoker’s right.
C . Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.
D . Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected user

The following query will provide what information about transportable tablespaces for the current database?() select d.platform_name "Source", t.platform_name  "Compatible Targets", endian_format  from v$transportable_platform t, v$database d  where t.endian_format = (select endian_format  from v$transportable_platform t, v$database d  where d.platform_name = platform_name);    The list of target platforms having the same endian format as the source database。  The list of target platforms requiring endian conversion。  The list of target platforms that will not require endian conversion。  The list of all target platforms that can receive transportable tablespaces from the source database。  None of the above。 The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members?()  V$LOG。  V$LOGFILE。  DBA_LOG_GROUPS。  V$LOG_HISTORY。 抗心律失常药物的分类,每类各举一代表药。 男性,30岁。车祸致外伤性脾破裂,入院时已发生休克,直接送入手术室,在麻醉医生看患者的同时,巡回护士应首先处理的是() 给患者吸氧。 手术区备皮。 输液,抽血配血。 准备手术器械。 摆放手术体位。 Which command will list the top 5 memory intensive processes?()   lsmem -pu 5。 lsps -psu 5。 svmon -Put 5。 ps -au sort -rn +4head -5。

The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users: 
CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2, v_mgr NUMBER, v_loc NUMBER) BEGIN 
INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc); END; 
The users having permission to execute the procedure are able to insert records into the 
DEPARTMENTStable even though they do not have the INSERT privilege on the table. You want only those users whohave privileges on the DEPARTMENTS table to be able to execute the procedure successfully. 
What would you suggest to the PL/SQL developers to achieve this()

参考答案:

  参考解析

本题暂无解析

在线 客服