ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam
Go to Exam

Exam 1z0-071 topic 1 question 58 discussion

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

Which two statements are true about selecting related rows from two tables based on an Entity Relationship Diagram (ERD)? (Choose two.)

  • A. Rows from unrelated tables cannot be joined.
  • B. Relating data from a table with data from the same table is implemented with a self join.
  • C. Implementing a relationship between two tables might require joining additional tables.
  • D. Every relationship between the two tables must be implemented in a join condition.
  • E. An inner join relates rows within the same table.
Show Suggested Answer Hide Answer
Suggested Answer: BC 🗳️
by Poke90 at March 8, 2023, 9:04 a.m.

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
Submit Cancel
rani_12
5 months, 4 weeks ago
why D is not correct ?
upvoted 1 times
...
Patrick_Alan
1 year, 5 months ago
I thought that the option "A" for this question would apply the same reasoning as the question 50, where the option that said "PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it." was justified by saying "it doesn't make sense, it's not advisable, but it can be done".
upvoted 3 times
...
Sagarkpvs
1 year, 10 months ago
Inner join can be done on different tables . Same table is called self join
upvoted 4 times
...
Poke90
1 year, 11 months ago
How is E wrong?
upvoted 1 times
karols32
1 year, 9 months ago
You can join tables in where. SELECT * FROM FIRST_TABLE F, SECOND_TABLE S WHERE F.ID = S.ID. This example uses a where clause, not a join.
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago