9A0-127 Online Practice Questions and Answers

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 are using to retrieve data asynchronously from a CFC function on the server.

Which data format is used to send back the data response?

A. plain text

B. AMF

C. JSON

D. XML

The following CFM page named input.cfm receives a URL variable and returns its value in upper case.

Echoing input:

#uCase(url.InputText)#

No input

Which tag uses the correct binding expression to pass the value of a control named myInput and display the value returned from the first page?

A.

B.

C.

D.

The following code is placed in Application.cfc, outside of any function definitions:

What is the scope and visibility of the variable?

A. Request scope; visible to all code executed during the current page request

B. Application scope; visible to code in all pages of the application

C. This scope; visible as public properties of the CFC

D. Variables scope; visible only to code in Application.cfc

How can you restrict the number of rows returned from a stored procedure to 100 or fewer using ?

A. add a MAXROWS="100" attribute to the tag

B. add a BLOCKFACTOR="100" attribute to the tag

C. add a MAXROWS="100" attribute to the tag

D. add a MAXROWS="100" attribute to the tag

You want to create an instance of the component Part, then access the property partID by using the following code:

Which component syntax should you use?

A.

B. component { var partID = 0; }

C. component { local.partID = 0; }

D. component { this.partID = 0; }

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.

You have read xml stored in a database column into the variable xData.

Which two statements convert the variable from an XML document to an XML object? (Choose two.)

A.

B. #xData#

C. #xData#

D.

E. #xData#

Which declaration of the variable columnmap results in the successful output of an RSS feed?

qdata = querynew("name,description,url");

queryaddrow(qdata,3);

querysetcell(qdata,"name","Larry",1);

querysetcell(qdata,"description","Larry was the middle stooge",1);

querysetcell(qdata,"url","http://www.larryfine.com",1);

querysetcell(qdata,"name","Moe",2);

querysetcell(qdata,"description","Moe was the leader",2);

querysetcell(qdata,"url","http://en.wikipedia.org/wiki/Moe_Howard",2);

querysetcell(qdata,"name","Curly",3);

querysetcell(qdata,"description","Curly is everyone's favorite",3);

querysetcell(qdata,"url","http://stoogeworld.com/_Biographies/Curly.htm",3);

query="#qdata#"

xmlvar="xRSS"

columnmap="#columnmap#"

properties="#properties#">

#xRSS#

A.

B.

C.

D.

Which function definition defines a private function named fullName that returns a string?

A. string function fullName()

B. function fullName():String

C. private string function fullName()

D. private function fullName():String