AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-144





Question ID 2648

View the Exhibit and examine the structure of the departments table in SCOTT’s schema.
 
Examine the following block of code:
CREATE OR REPLACE PROCEDURE add_dept(
p_id NUMBER, p_name VARCHAR2) IS
BEGIN
INSERT INTO departments VALUES <p_id, p_name, NULL, NULL);
END;
/
The above procedure is created by user SCOTT. Another user JONES needs to use the procedure.
Which two statements are true in the above scenario? (Choose two.)

Option A

A.    JONES executes the procedure with definer's rights.
 

Option B

B.    JONES executes the procedure with invoker's rights.
 

Option C

C.    SCOTT should grant only theexecute privilege for the procedure to JONES.
 

Option D

D.    SCOTT should grant both the BXKCOTE privilege for the procedure and insert privilege for the table to
 

Correct Answer A,C
Explanation


Question ID 2649

Which two statements are true about statement-level and row-level triggers? (Choose two.)
 

Option A

A.    A row trigger fires once even if no rows are affected.

 

Option B

B.    A statement trigger fires once even if no rows are affected.
 

Option C

C.    Row triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.
 

Option D

D.    Statement triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.

Correct Answer B,C
Explanation

Send email to admin@getfreedumps for new dumps request!!!