1z0-062 Exam Question 121
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the
following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER,
v_dept_id NUMBER)
BEGIN
INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id);
END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into
tables on which they do not have any privileges?
following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER,
v_dept_id NUMBER)
BEGIN
INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id);
END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into
tables on which they do not have any privileges?
1z0-062 Exam Question 122
Which three statements are true when the listener handles connection requests to an
Oracle 12c database instance with multithreaded architecture enabled In UNIX?
Oracle 12c database instance with multithreaded architecture enabled In UNIX?
1z0-062 Exam Question 123
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
1z0-062 Exam Question 124
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)
Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)
1z0-062 Exam Question 125
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated
Maintenance Task?
Maintenance Task?