Checked: A, B
Check:
CREATE TABLE COLORS_120
(
RGB_HEX_VALUE VARCHAR2(100)
, COLOR_NAME VARCHAR2(100)
);
CREATE TABLE BRIKS_120
(
BRICK_ID NUMBER
, COLOR_RGB_HEX_VALUE VARCHAR2(100)
);
INSERT INTO COLORS_120
SELECT 'FF0000','red' FROM DUAL
UNION ALL
SELECT '00FF00','green' FROM DUAL
UNION ALL
SELECT '0000FF','blue' FROM DUAL;
INSERT INTO BRIKS_120
SELECT 1,'FF0000' FROM DUAL
UNION ALL
SELECT 2,'00FF00' FROM DUAL
UNION ALL
SELECT 3,'FFFFFF' FROM DUAL;
A;
SELECT *
FROM BRIKS_120 b
RIGHT JOIN COLORS_120 c
ON b.COLOR_RGB_HEX_VALUE = c.RGB_HEX_VALUE;
B;
SELECT *
FROM BRIKS_120 b
FULL JOIN COLORS_120 c
ON b.COLOR_RGB_HEX_VALUE = c.RGB_HEX_VALUE;
C;
SELECT *
FROM c
FULL JOIN BRIKS_120 b
USING(RGB_HEX_VALUE);
D;
SELECT *
FROM COLORS_120 c
LEFT JOIN BRIKS_120 b
ON b.COLOR_RGB_HEX_VALUE = c.RGB_HEX_VALUE
WHERE b.brick_id > 0
;
E;
SELECT *
FROM BRIKS_120 b
LEFT JOIN COLORS_120 c
ON b.COLOR_RGB_HEX_VALUE = c.RGB_HEX_VALUE;
This section is not available anymore. Please use the main Exam Page.1z0-071 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.
anzac
Highly Voted 2 years, 7 months agoWingL
2 years ago2339ac0
Most Recent 2 months, 2 weeks agoamizh
1 year, 5 months agoamizh
1 year, 5 months agoArslanAltaf
1 year, 3 months agoyaya32
1 year, 6 months agolucemqy
1 year, 8 months agojm9999
1 year, 10 months agoWingL
2 years agoOrxan_H
2 years, 1 month agoa947739
1 year agoDarnun
2 years, 4 months agojfc1
2 years, 6 months agodexdinh91
2 years, 6 months agocadcadley
2 years, 6 months agoabdullah_barham
2 years, 7 months ago