Which WHERE clause would give the required result?

The promo should have ended after 1st January 2001.
exhibit Which WHERE clause would give the required result?

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’)



Leave a Reply 9

Your email address will not be published. Required fields are marked *


Luis

Luis

Incomplete question?

Oscar Copado Silva

Oscar Copado Silva

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.

admin

admin

Thanks Oscar.

kamarockon

kamarockon

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]

Ivan Ticona

Ivan Ticona

It’s wrong!!!

Justyna

Justyna

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′

Justyna

Justyna

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

user

user

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′)

Morgan Onyekachi

Morgan Onyekachi

hi, please assist with the latest dumb to [email protected] I will be writing this month. thanks