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.
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.
braintop
1 month, 2 weeks agolucemqy
1 year, 1 month agoHassanMkhlalati
1 year, 3 months agoTheOracleWasTaken
1 year, 5 months agoNSilva
8 months, 1 week agoyanoolthecool
1 year, 5 months agoCMjer
1 year, 7 months agoSbablo
1 year, 7 months agoMarko_1991
1 year, 7 months agoHassanMkhlalati
1 year, 3 months agozouve
1 year, 6 months agodexdinh91
1 year, 12 months agoSantiBZ_07032022_1744
1 year, 12 months agoKizTine
1 year, 2 months agoJCKOMI
2 years agokarols32
1 year, 8 months agoTheOracleWasTaken
1 year, 5 months ago