B. PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it.
Why? Because while the result is NULL, the expression itself is valid SQL and won’t cause an error.
EXPIRY_DATE cannot be used in ALL arithmetic operators
As there is no information on whether PRODUCT_ID contains duplicate values, we cannot determine whether PK can be assigned on it.
D. EXPIRY_DATE cannot be used in arithmetic expressions.
False. You can use Arithmetic expressions in Dates, just not all of them.
SELECT
DATE'2023-05-20' - 1 AS expire_date,
DATE'2023-05-20' + 1 AS extra_day
FROM DUAL;
I agree that the primary key could contain duplicated values, but is the one that seems most feasible out of the remaining options.
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.
826cb95
1 day, 20 hours agobraintop
5 months agolucemqy
1 year, 5 months agoHassanMkhlalati
1 year, 7 months agoTheOracleWasTaken
1 year, 8 months agoNSilva
11 months, 3 weeks agoyanoolthecool
1 year, 8 months agoCMjer
1 year, 11 months agoSbablo
1 year, 11 months agoMarko_1991
1 year, 11 months agoHassanMkhlalati
1 year, 7 months agozouve
1 year, 9 months agodexdinh91
2 years, 3 months agoSantiBZ_07032022_1744
2 years, 3 months agoKizTine
1 year, 6 months agoJCKOMI
2 years, 3 months agokarols32
2 years agoTheOracleWasTaken
1 year, 8 months ago