Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

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.

Exam 1z0-071 topic 1 question 50 discussion

Actual exam question from Oracle's 1z0-071
Question #: 50
Topic #: 1
[All 1z0-071 Questions]

Examine the description of the PRODUCT_DETAILS table:

Which two statements are true? (Choose two.)

  • A. EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it.
  • B. PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it.
  • C. PRODUCT_NAME cannot contain duplicate values.
  • D. EXPIRY_DATE cannot be used in arithmetic expressions.
  • E. PRODUCT_PRICE contains the value zero by default if no value is assigned to it.
  • F. PRODUCT_ID can be assigned the PRIMARY KEY constraint.
Show Suggested Answer Hide Answer
Suggested Answer: BF 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
lucemqy
6 months, 1 week ago
Selected Answer: BF
You can add NULL to a number it will result in NULL
upvoted 2 times
...
HassanMkhlalati
8 months, 1 week ago
Selected Answer: BF
BF correct
upvoted 1 times
...
TheOracleWasTaken
9 months, 3 weeks ago
Selected Answer: BD
We dont know if there's any duplicate values for the id column so how do we know if it can be a PK
upvoted 1 times
NSilva
2 weeks, 4 days ago
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.
upvoted 1 times
...
...
yanoolthecool
9 months, 3 weeks ago
Selected Answer: BF
B's correct, so is F
upvoted 1 times
...
CMjer
1 year ago
Selected Answer: BF
BF correct, see discussion on same question: https://www.examtopics.com/discussions/oracle/view/8221-exam-1z0-071-topic-1-question-229-discussion/
upvoted 1 times
...
Sbablo
1 year ago
B is wrong, absence of data means null. An arithmetic operation with a null value always yields null
upvoted 2 times
Marko_1991
1 year ago
what about nvl?
upvoted 1 times
...
HassanMkhlalati
8 months, 1 week ago
But it doesn't send an error message
upvoted 1 times
...
zouve
10 months, 2 weeks ago
BF PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it, but the result will be NULL
upvoted 1 times
...
...
dexdinh91
1 year, 4 months ago
Selected Answer: BF
BF are correct
upvoted 2 times
...
SantiBZ_07032022_1744
1 year, 4 months ago
Expiry_DATE cannot be used in arithmetic expressions -> FALSE.
upvoted 1 times
KizTine
7 months, 1 week ago
yes 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)
upvoted 1 times
...
...
JCKOMI
1 year, 4 months ago
why expiry date can not be used in arithmetic expressions ?
upvoted 1 times
karols32
1 year, 1 month ago
EXPIRY_DATE cannot be used in arithmetic expressions. - FALSE Because on date data type you can use a "MINUS" arithmetic expressions.
upvoted 1 times
TheOracleWasTaken
9 months, 3 weeks ago
But can you multiply a date or divide it?
upvoted 1 times
...
...
...
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.

SaveCancel
Loading ...