nerdexam
Adobe

9A0-127 · Question #83

9A0-127 Question #83: Real Exam Question with Answer & Explanation

Sign in or unlock 9A0-127 to reveal the answer and full explanation for question #83. The question stem and answer options stay visible for context.

Question

Click the Exhibit button. The table person contains the data shown in the exhibit. You have issued the following query: <cfquery name="qPeople" datasource="myDatasource"> select * from person where lastname like <!--- insert code here ---> </cfquery> Which ColdFusion expression safely parameterizes the query to return all records that have lastnames starting with data input to a form field (form.search)?

Exhibit

9A0-127 question #83 exhibit

Options

  • A<cfqueryparam cfsqltype="cf_sql_char" value="#form.search#*">
  • B<cfqueryparam cfsqltype="cf_sql_string" value="#form.search#_">
  • C<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.search#%">
  • D<cfqueryparam cfsqltype="cf_sql_varchar" value="%#form.search#%">

Unlock 9A0-127 to see the answer

You've previewed enough free 9A0-127 questions. Unlock 9A0-127 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 9A0-127 Practice