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

题目

单选题

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

Create the procedure with definer’s right.

Create the procedure with invoker’s right.

Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.

Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users

参考答案和解析

正确答案： B

解析：暂无解析

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

相似问题和答案

第1题：

Which statement creates a new user? ()

A. CREATIVE USER susan;

B. CREATIVE OR REPLACE USER susan;

C. CREATE NEW USER susan DEFAULT

D. CREATE USER susan IDENTIFIED BY blue;

E. CREATE NEW USER susan IDENTIFIED BY blue;

F. CREATE OR REPLACE USER susan IDENTIFIED BY blue;

参考答案：D

第2题：

更改oracle用户HR，使其变为不可用（锁定）状态（）

A、UPDATE USER HR ACCOUNT DISABLE
B、UPDATE USER HR ACCOUNT LOCK
C、ALTER USER HR ACCOUNT DISABLE
D、ALTER USER HR ACCOUNT LOCK

正确答案:D

第3题：

The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command?()

A. The job is enabled by default after creation

B. The job is automatically dropped after the end date

C. The job executes with the privileges of the user SYS

参考答案：B, C

第4题：

下列选项中，能够解除HR用户的锁定的语句是（）。

A、alter user hr unlock
B、alter user hr account unlock
C、alter table alter hr unlock
D、alter table alter unlock hr

正确答案:B

第5题：

Examine these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do? （）

A、The set of statements contains an error and does not work.
B、It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
C、It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
D、It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.
E、It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.
F、It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.

正确答案:C

第6题：

下列选项中,能够解除HR用户的锁定的语句是()。

A.alter user hr unlock

B.alter user hr account unlock

C.alter table alter hr unlock

D.alter table alter unlock hr

参考答案：B

第7题：

Which statement creates a new user?（）

A、CREATE USER susan;
B、CREATE OR REPLACE USER susan;
C、CREATE NEW USER susan DEFAULT;
D、CREATE USER susan IDENTIFIED BY blue;
E、CREATE NEW USER susan IDENTIFIED by blue;
F、CREATE OR REPLACE USER susan IDENTIFIED BY blue;

正确答案:D

第8题：

You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）

A. They execute and create a virtual catalog for pre-Oracle 11g clients.

B. They produce an error because PROD1 and PROD2 databases belong to the older version.

C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.

D. They produce an error because you need to connect to the target database to execute this packaged procedure.

参考答案：A

第9题：

Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）

A、Control Center
B、Development Center
C、Developer Workbench
D、Stored Procedure Builder

正确答案:C

第10题：

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.

正确答案:D

The HR user creates a stand-alone procedure as follows and g

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容