9A0-127 Online Practice Questions and Answers

You want to convert a query column containing numeric data into a comma-delimited list. Which function should you use?

A. ValueList()

B. ArrayToList()

C. ColumnList()

D. ListAppend()

The following command creates a spreadsheet containing data from an existing variable named myVar:

name="myVar"/>

Which type of data must the myVar variable contain?

A. a query object

B. a spreadsheet object or comma-delimited text

C. any data type

D. an array, query, or comma-delimited text

What is the default format of charts generated by the tag?

A. jpg

B. png

C. flash

D. gif

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

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

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 a ColdFusion component that contains mathematics methods, and can be accessed directly by a form post. Your Web root directory is c:\coldfusion9\wwwroot. Which filename should you use?

A. c:\coldfusion9\customtags\math.cfc

B. c:\math.cfm

C. c:\coldfusion9\wwwroot\math.cfm

D. c:\coldfusion9\wwwroot\math.cfc

You have a variable declared with the var keyword. You want to ensure that its visibility is limited to the function. Where must you place the variable in a CFC function to accomplish this?

A. anywhere inside the function

B. inside the function, but before any other functional code

C. inside a pair of tags

D. inside the CFC, but outside the function

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

Your application needs to consume an RSS feed hosted on another server.

You are using cfhttp.

Which property allows you to specify the address of the remote file?

A. url

B. address

C. server

D. destination