Refer to the exhibit.
The promo name should not begin with ‘T’ or ‘N’.
The promo should cost more than $20000.
The promo should have ended after 1st January 2001.
Which WHERE clause would give the required result?
A.
WHERE promo_name NOT LIKE ‘T%’ OR promo_name NOT LIKE ‘N%’ AND promo_cost > 20000 AND promo_end_date > ‘1-JAN-01’)
B.
WHERE (promo_name NOT LIKE ‘T%’ AND promo_name NOT LIKE ‘N%’)OR promo_cost > 20000 OR promo_end_date > ‘1-JAN-01’)
C.
WHERE promo_name NOT LIKE ‘T%’ AND promo_name NOT LIKE ‘N%’ AND promo_cost > 20000 AND promo_end_date > ‘1-JAN-01’)
D.
WHERE (promo_name NOT LIKE ‘%T%’ OR promo_name NOT LIKE ‘%N%’) AND(promo_cost > 20000 AND promo_end_date > ‘1-JAN-01’)
Incomplete question?
1. The promo name should not begin with ‘T’ or ‘N’.
2. The promo should cost more than $20000.
3. The promo should have ended after 1st January 2001.
Here it is what is missing.
Thanks Oscar.
hi,
Please let me know are these questions still in use fro the OCA 11g exams? Also, please provide me with the latest dumps.
id: [email protected]
It’s wrong!!!
It has to be:
The promo name should not begin with ‘T’ or ‘N’.
AND
The promo should cost more than $20000.
AND
The promo should have ended after 1st January 2001.
so it is:
promo_name NOT LIKE ‘T%’ AND promo_name NOT LIKE ‘N%’
(cannot be promo_name NOT LIKE ‘T%’ OR promo_name NOT LIKE ‘N%’
because it returns all the rows)
(from math: The negation of a disjunction is the conjunction of the negations, i.e. ~(P or Q) ~P and ~Q
AND
promo_cost > 20000
AND
promo_end_date > ’1-JAN-01′
in my comment above should be:
from math: The negation of a disjunction is the conjunction of the negations, i.e.
~(P or Q) ~P and ~Q
Answer C is missing the left parenthesis!
Copied from the above:
WHERE promo_name NOT LIKE ‘T%’ AND promo_name NOT LIKE ‘N%’ AND promo_cost > 20000 AND promo_end_date > ’1-JAN-01′)
hi, please assist with the latest dumb to [email protected] I will be writing this month. thanks