exam questions

Exam 1z0-148 All Questions

View all questions & answers for the 1z0-148 exam

Exam 1z0-148 topic 1 question 56 discussion

Actual exam question from Oracle's 1z0-148
Question #: 56
Topic #: 1
[All 1z0-148 Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: BDE 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
chrishillinger
2 years, 8 months ago
Selected Answer: BDF
BDF ist correct
upvoted 1 times
...
yurijk
5 years, 3 months ago
Correct: BDF
upvoted 2 times
CosminCof
4 years, 7 months ago
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
...
...
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago