9A0-127 Online Practice Questions and Answers

Given the following snippet:

#--x# - #x++#

What is the output?

A. 1 - 1

B. 1 - 3

C. 1 - 2

D. -1

What is the value of the variable output when the following code executes?

A. "The answer is one"

B. "The answer is two"

C. "The answer is three"

D. "There is no answer"

Given the following code:

Enter a value:

What happens when the form is submitted and validation rules are broken?

A. The file handler.cfm page is displayed.

B. The ColdFusion default validation error handler page is displayed.

C. The form page is displayed.

D. A runtime error occurs.

Your application has a page that has very high traffic. The page is rendered from data in a database. Your application should only run a query if it has been longer than 60 seconds since its last execution.

Which attribute of the cfquery tag allows you to specify a time where a query should NOT be executed again?

A. cachedAfter

B. cachedBefore

C. cachedWithin

D. cachedFor

You capture the RESULT structure of a query that performs an INSERT, UPDATE, or DELETE operation. What does the structure's RECORDCOUNT property represent?

A. the number of rows in the table after the query is executed

B. the number of rows in the table before the query is executed

C. different values for the INSERT, UPDATE or DELETE operations

D. the number of rows affected by the query

Which three isolation attributes allow dirty read, non-repeatable read, or phantom? (Choose three.)

A. read_committed

B. repeatable_read

C. serializable

D. read_uncommitted

You need to execute a stored procedure against a database in your application What allows you to access the data returned from that call?

A. the name property of the cfstoredproc tag

B. the name property of the cfquery tag

C. the result property of the cfquery tag

D. the name property of the cfprocresult tag

You are utilizing ORM in ColdFusion 9.

Which tag should you use to map table fields to variables of the component?

A. cfsetting

B. cfproperty

C. cfargument

D. cfmapping

You want to allow Flash Remoting and web service clients to fetch all of the records from the Art table through the ColdFusion ORM, sorted by the artName field in ascending order. To perform this action, you create another CFC to act as a service layer, ArtService.cfc, and write a method named getAllArt.

How should you write the method to retrieve the correct data and most accurately represent the type of that data?

A. public Array function getAllArt() { return entityLoad("Art, {}, "artName ASC"); }

B. remote Art[] function getAllArt() { return entityLoad("Art", {}, "artName ASC"); }

C. remote Array function getAllArt() { return entityLoad("Art", {}, "artName ASC"); } records = arrayNew(1);

D. remote Array function getAllArt() { records = entityLoad("Art", {}, "artName ASC"); }

Which tag allows you to retrieve an RSS document and save it to a file?

A. CFoutput

B. cffeed

C. CFrss

D. cfatom