CIW 1D0-541 Exam - Topic 8 Question 12 Discussion

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

Question #: 12
Topic #: 8

[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 Cristal at May 07, 2022, 07:13 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Alisha

4 months ago

A is definitely wrong, it needs a wildcard!

upvoted 0 times

...

Clorinda

4 months ago

Wait, can you really use % like that? Seems odd.

upvoted 0 times

...

Giuseppe

4 months ago

No way D is correct, that syntax is off.

upvoted 0 times

...

Gayla

4 months ago

I think B is also valid, but not as precise.

upvoted 0 times

...

Dorothy

5 months ago

Option C is the right one! It uses LIKE correctly.

upvoted 0 times

...

Royal

5 months ago

The key here is to identify the root cause of the connection issue between the controllers. Configuring the tunnel interfaces with the right color seems like the most logical approach to me.

upvoted 0 times

...

Erick

5 months ago

Wait, I thought the ASBR could be in any area, not just the backbone. Let me double-check that.

upvoted 0 times

...