Exam 98-364 topic 1 question 80 discussion

A is the correct answer in this case. In this case since its "<>" (not equals to), makes it a little trickier. AND - Removes all results that have color black OR country USA. Example: Black Germany -> TRUE AND FALSE -> FALSE This would not retrieve the record. If you have OR, it would retrieve all except BLACK AND USA. Example: Black Germany -> TRUE OR FALSE -> TRUE This would retrieve the record. Run the operation on your head and count them. It should be 4 retrieved.

The answer is D is D because we are using AND operator which requires both paramenters to be true

Four records returned is correct: Use Boolean on each row evaluating values in Country AND Colour and accounting for =! The first line for instance gives TRUE as both values are true acc to the query, as neither color is black nor country is USA. T and T gives T for AND. The second row gives FALSE - because the color isn't Black so we want that, it's TRUE acc to the <>, but the Country is USA, which we don't want, a false acc to <> part of the query. So we have T and F giving an overall F for AND. Evaluating in Boolean comparisons manner each record for values for each of the attributes (Colour and Country), only four records have True and True for our 'not Black and not USA' so overall TRUE to be returned for Boolean AND. From top to bottom Boolean for each record according to NOT and AND is T, F, T, T, F, T, F, F. For AND Boolean is: attribute1 attribute2 returns T T T T F F F T F F F F

A is correct. If that can help anyone, I found that adding in your head "rows where" on either side of the "AND" helped me understand that you need to deduct from the results all rows that have black as well as all rows that have a USA location, hence 4 rows in this case. (remove 3 black rows you get 5 rows that still include one USA row, then remove that one and you get 4).

The Answer is A. I recreated the table in SMSS and I ran the query just as it is in this question. It returned 4 rows.

If you run the operation the answer is A

La respuesta es D. AND implica que se cumplan las dos condiciones mientras que OR implica que se cumpla una u otra. Teniendo eso en cuenta la respuesta es clara.

A is correct

The option A is correct

For the answer to be A, the query would have OR in the statement instead of AND. Otherwise the answer is 1 which is not listed. The Convertible is the only car that is Black AND made in the US. "The AND operator displays a record if all the conditions separated by AND are TRUE. The OR operator displays a record if any of the conditions separated by OR is TRUE." The AND operator displays a record if all the conditions separated by AND are TRUE. The OR operator displays a record if any of the conditions separated by OR is TRUE.

a becouse it is not ,and and

I believe D is right answer... right ????

i think it's A because we have an AND in the statement, not an OR

it should be D

the answer should be D, right?