CIW Exam 1D0-541 Topic 3 Question 83 Discussion

Actual exam question for CIW's 1D0-541 exam

Question #: 83
Topic #: 3

[All 1D0-541 Questions]

Consider the Registration relation shown in the exhibit. Which of the following SQL statements

would return all tuples that have course codes beginning with the letter M?

ASELECT *
FROM Registration
WHERE Course_Code = M#;

BSELECT *
FROM Registration
WHERE Course_Code LIKE M_;

CSELECT *
FROM Registration
WHERE Course_Code LIKE M%;

DSELECT *
FROM Registration
WHERE Course_Code = M%;

Show Suggested Answer

Suggested Answer: C

by Graciela at Mar 21, 2024, 08:17 AM

Limited Time Offer

25%

Off

Get Premium 1D0-541 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Paulina

10 months ago

I see your point, Carmela. But in this case, we need to find tuples that have course codes beginning with M, so C seems more appropriate.

upvoted 0 times

...

Carmela

10 months ago

I'm not sure, but I think A is also a possibility because it looks for an exact match with M#.

upvoted 0 times

...

Shawna

10 months ago

I agree with Paulina, C makes sense because % is used for wildcard matching.

upvoted 0 times

...

Paulina

10 months ago

I think the correct answer is C because the LIKE operator is used for pattern matching in SQL.

upvoted 0 times

...

Coral

10 months ago

I'm torn between option C and D, but I think I'll go with option C for now.

upvoted 0 times

...

Loren

10 months ago

I disagree, I believe option D is the correct answer since we need to use the equals sign for exact match.

upvoted 0 times

...

Virgina

11 months ago

I'm not so sure, I think option B could also work if we use the underscore wildcard.

upvoted 0 times

...

Carolann

12 months ago

I agree with Meghan, option C makes sense because of the LIKE operator.

upvoted 0 times

...

Meghan

12 months ago

I think the correct answer is option C.

upvoted 0 times

...