1Z0-148 Web TestEngine demo

Examine the structure of the DEPT table which exists in both BRANCH1 and BRANCH2 schemas:

Examine this code:

Which three modifications must be done to endure the anonymous block displays the output form the BRANCH2.
DEF DEPT table?

Select all that apply.

• A

  Change the IF condition in the anonymous block to 1_dept IS EMPTY.

• B

  Change the IF condition in the anonymous block to CARDINALITY (1_dept) IS NULL.

• C

  Add BEQUEATH DEFINER to the EMP_COUNT_VW view.

• D

  Add BEQUEATH CURRENT_USER to the EMP_COUNTS_VW view.

• E

  IN BRANCH2 execute GRANT INHERIT PRIVILEGES ON USER branch2 TO branch1;

• F

  Add AUTHID CURRENT_USER to the EMP_COUNT function.