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?
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.
BDF makes sense but why would you want to add BEQUEATH CURRENT_USER and AUTHID CURRENT_USER ? Both come default with DEFINER and is still good, it works.
upvoted 1 times
...
...
This section is not available anymore. Please use the main Exam Page.1z0-148 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
chrishillinger
2 years, 8 months agoyurijk
5 years, 3 months agoCosminCof
4 years, 7 months ago