Examine the description of the PRODUCT_DETAILS table:
Which two statements are true? (Choose two.)
1z0-071 Exam QuestionsBrowse all questions from this exam
1z0-071 Exam - Question 50
Show AnswerHide Answer
Correct Answer: BF
PRODUCT_ID can be assigned the PRIMARY KEY constraint since it is NOT NULL and using it as a primary key will uniquely identify records in the table, ensuring there are no duplicate values. Additionally, PRODUCT_PRICE can indeed be used in arithmetic expressions even if it has no value stored in it; however, the result of the arithmetic operation with a NULL value will itself be NULL and won't trigger any error. The other options are incorrect because EXPIRY_DATE cannot be assumed to have a default SYSDATE, PRODUCT_NAME can contain duplicate values unless explicitly constrained, and EXPIRY_DATE can indeed be used in arithmetic expressions such as adding or subtracting days.
Discussion
9 commentsdexdinh91Options: BF
Jan 10, 2023BF are correct
SbabloOptions: CF
May 11, 2023B is wrong, absence of data means null. An arithmetic operation with a null value always yields null
Marko_1991
May 14, 2023what about nvl?
zouve
Jul 5, 2023BF PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it, but the result will be NULL
HassanMkhlalati
Sep 12, 2023But it doesn't send an error message
lucemqyOptions: BF
Nov 13, 2023You can add NULL to a number it will result in NULL
JCKOMI
Dec 21, 2022why expiry date can not be used in arithmetic expressions ?
karols32
Apr 17, 2023EXPIRY_DATE cannot be used in arithmetic expressions. - FALSE Because on date data type you can use a "MINUS" arithmetic expressions.
TheOracleWasTaken
Aug 2, 2023But can you multiply a date or divide it?
SantiBZ_07032022_1744
Jan 8, 2023Expiry_DATE cannot be used in arithmetic expressions -> FALSE.
KizTine
Oct 9, 2023yes it's possible. Foe example : SELECT expiry_date + 3 FROM product_details; (to add 3 days) SELECT expiry_date + interval '1' month FROM product_details; (to add 1 month)
CMjerOptions: BF
May 12, 2023BF correct, see discussion on same question: https://www.examtopics.com/discussions/oracle/view/8221-exam-1z0-071-topic-1-question-229-discussion/
yanoolthecoolOptions: BF
Jul 27, 2023B's correct, so is F
TheOracleWasTakenOptions: BD
Aug 2, 2023We dont know if there's any duplicate values for the id column so how do we know if it can be a PK
NSilva
May 1, 2024D. 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.
HassanMkhlalatiOptions: BF
Sep 12, 2023BF correct