Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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;
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 1 year, 4 months agoWingL
10 months agoamizh
Most Recent 2 months, 2 weeks agoamizh
2 months, 2 weeks agoArslanAltaf
2 weeks, 2 days agoyaya32
3 months, 2 weeks agolucemqy
5 months, 3 weeks agojm9999
7 months, 2 weeks agoWingL
10 months agoOrxan_H
11 months agoDarnun
1 year, 1 month agojfc1
1 year, 3 months agodexdinh91
1 year, 3 months agocadcadley
1 year, 3 months agoabdullah_barham
1 year, 4 months ago