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?
  • 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?
  • 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.)
  • 1z0-062 Exam Question 125

    What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated
    Maintenance Task?