Oracle認證考試章節(jié)練習(2019.12.21)

You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.
How would you create these jobs?（）

To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows:
SQL> ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10;
What is the significance of this setting?（）

Which steps are mandatory to enable Direct NFS？（）  
1. Mount all required file systems using the kernel NFS driver. 
2. Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.   
3. Replace the ODM library libodm11.so_stub with libodm11.so.

You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD 
LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K 
LOG_ARCHIVE_DEST = +dgroupA 
LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" 
DB_CREATE_FILE_DEST = +dgroupA 
COMPATIBLE = 10.1.0.2.0 
CONTROL_FILES = +dgroupA 
Which parameter would be ignored while starting up the instance for the database PROD？（）

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

Given：

What is the result？（）