READ Free Dumps For Oracle- 1z0-144

Question ID 2729	View the Exhibit and examine the structure of the AUDIR_CUST table. Exhibit Missing CUST_ID and CUST_LIMIT are existing columns in the CUSTOMER table. Examine the following trigger code:   Which statement is true about the above trigger?
Option A	A.    It gives an error on compilation because it should be a statement-level trigger.
Option B	B.    It compiles and fires successfully when the credit limit is updated in the customer table.
Option C	C.    It gives an error on compilation because of the commit command in the trigger code
Option D	D.    It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigger.
Correct Answer	D

Explanation

Question ID 2730	Which three statements are true about anonymous blocks and subprograms? (Choose three.)
Option A	A.    Only subprograms can be parameterized.
Option B	B.    Only subprograms are persistent database objects.
Option C	C.    Both anonymous blocks and subprograms can be parameterized.
Option D	D.    Both anonymous blocks and subprograms are persistent database objects
Option E	E.    Only subprograms can return values that persist after the execution of the subprogram.
Option F	F.    Both anonymous blocks and subprograms can return values that persist In SQL*Plus variables after their execution.
Correct Answer	B,E,F

Explanation

Previous-Page 1 2. . . 44 45 46 47 48 49 50. . . 62 63 Next-Page

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