052(五）

21、View the Exhibit and examine the privileges granted to the SL_REP user.

The EMP table is owned by the SCOTT user. 
The SL_REP user executes the following command: 
SQL> GRANT SELECT ON scott.emp TO hr; 
Which statement describes the outcome of the command? 
A. The command executes successfully 
B. The command produces an error because the EMP table is owned by SCOTT 
C. The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE 
without ADMIN_OPTION 
D. The command produces an error because SL_REP does not have the SELECT privilege with 
GRANT_OPTION on the EMP table 
Answer: A 

GRANT ANY OBJECT PRIVILEGE 可以把任何用户下的表授权给其他用户

 

22、

22.You executed this command to create a temporary table:
SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (
startdate DATE,
enddate DATE,
class CHAR(20)
) ON COMMIT PRESERVE ROWS;
Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a 
transaction?
A. The rows stay in the table only until session termination 
B. The rows stay in the table only until the next transaction starts on the table 
C. The rows are visible to all current sessions after the transaction in committed
D. The rows stay available for subsequent sessions after the transaction is committed 
Answer: A 

ON COMMIT DELETE ROWS 事务临时表
ON COMMIT PRESERVE ROWS 会话临时表

 

23、

23.You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to 
add a new column to the EMPLOYEE table to achieve this.
Which data types would you use for the new column?
A. CLOB 
B. BLOB 
C. BFILE 
D. LONG RAW 
Answer: C

bfile是数据库外部文件

 

24、

24.The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the
procedure 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 DEPARTMENTS 
table even though they do not have the INSERT privilege on the table. You want only those users who 
have 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 users. 
Answer: B 

invoker调用者权限

 

25、

25.Examine the following command that is used to create a table:
SQL> CREATE TABLE orders (
oid NUMBER(6) PRIMARY KEY,
odate DATE,
ccode NUMBER (6),
oamt NUMBER(10,2)
) TABLESPACE users;
Which two statements are true about the effect of the above command? (Choose two.)
A. A CHECK constraint is created on the OID column 
B. A NOT NULL constraint is created on the OID column 
C. The ORDERS table is the only object created in the USERS tablespace 
D. The ORDERS table and a unique index are created in the USERS tablespace 
E. The ORDERS table is created in the USERS tablepsace and a unique index is created on the OID 
column in the SYSTEM tablespace 
Answer: BD 

参考052(二）第10题。