9A0-127 Online Practice Questions and Answers

What is the value of the variable b when the following code block executes?

a = 0;

b = 1;

a = (a)?b:a;

if (a) {

b = "apple";

}{

b = "pear";

}

A. 1

B. 0

C. apple

D. pear

Your application has the following query which is invalid:

SELECT * FROM ...

Which variable contains a string that describes the cause of the error?

A. cfcatch.message

B. cfcatch.type

C. cfcatch.detail

D. cfcatch.errorCode

Which tag action allows code between the starting and ending tags?

A. run

B. terminate

C. sleep

D. join

You have dynamically generated PDF files using . Customers complain that the PDF files are very large, resulting in long download times. Which two invocations of can you use to reduce the size of your PDF files? (Choose two.)

A.

B.

C.

D.

E.

Your application accesses a table named users to retrieve data. The users table has three columns: id of type int, name of type string, and email of type string. Which SQL statement retrieves the user with an ID value of 3?

A. SELECT * FROM users WHERE id = '3'

B. SELECT * FROM users WHERE ids = 3

C. SELECT * FROM users WHERE id = 3

D. SELECT * FROM users WHICH id = 3

Click the Exhibit button.

The table person contains the data shown in the exhibit. You have issued the following query:

select *

from person

where lastname like

Which ColdFusion expression safely parameterizes the query to return all records that have lastnames starting with data input to a form field (form.search)?

A.

B.

C.

D.

Which tag successfully queries data from a query object named qData?

A. SELECT * FROM PEOPLE ORDER BY FIRSTNAME

B. SELECT * FROM qData ORDER BY FIRSTNAME

C. SELECT * FROM PEOPLE ORDER BY FIRSTNAME

D. SELECT * FROM qData ORDER BY FIRSTNAME

In your application you run the following query:

SELECT id, name, email FROM users;

Which query tag allows you to query the results of the getUsers query?

A.

B.

C.

D.

You want to create a ColdFusion component using by CFScript with a single public method named doSomething().

Which syntax should you use?

A. public function doSomething() { ... }

B. component { public function doSomething() { ... } }

C. public function doSomething() { ... }

D. /* component */ public function doSomething() { ... }

You have configured the ColdFusion Web root directory to be C:\ColdFusion9\wwwroot. You have placed the components Anvil.cfc and Boomerang.cfc within the directory C:\com\acme. You want to use Anvil.cfc within the file C:\ColdFusion9 \wwwroot\wile\coyote.cfm.

Which two actions must you take to accomplish this? (Choose two.)

A. Within coyote.cfm, you reference the component com.acme.Anvil within a createObject function or CFOBJECT tag, or using the new keyword.

B. You add the directory C:\com\acme to the Custom Tag Paths within the ColdFusion Administrator.

C. You use the CFIMPORT tag to import C:\com\acme as a tag library.

D. Within coyote.cfm, you reference the component "/com/acme/Anvil.cfc" within the TEMPLATE attribute of CFOBJECT.

E. You add the mapping "/com" within the ColdFusion Administrator, pointing to the directory C:\com.

You want to use the script-based component Artist.cfc to represent entities within the table Artists in the datasource artGallery using the ColdFusion ORM.

Which two changes must be made within Artist.cfc? (Choose two.)

A. add persistent = "true" to the component declaration

B. add table = "Artists" to the component declaration

C. add persistent = "true" to the CFCOMPONENT tag

D. add ormEnabled = "true" to the component declaration

E. add entityName = "Artists" to the component declaration

You have a database table named Art, which uses an automatically-incremented integer for the artId primary key column. You want to create a persistent Art component that provides a default value of zero for new Art instances that do not correspond to existing database records.

Which statement is true about what must be done to accomplish this?

A. Nothing needs to be done as it happens automatically.

B. You cannot do anything at this time. You must explicitly set the value of artId when creating the new instance.

C. You must add unsavedValue = "0" to the artId property.

D. You must add default = "0" to the artId property.

In your application you have functionality for a menu contained in a file named menu.cfm. Which property of the cfmodule tag allows you to specify you want to display the menu.cfm file?

A. template

B. name

C. destination

D. source

You are using cfinvoke.

Which property allows you to specify the URL of the WSDL file you want to consume?

A. method

B. WSDL

C. URL

D. webservice

A file name data.txt is stored in the same directory as the currently executing CFM page.

What is the correct syntax to read the contents of the file into a variable named content?

A.

B.

C.

D.