9A0-127 Exam Questions

What is the correct syntax for extracting an XML document from the XML object xmlObj in utf-16 format?

Given the XML object definition: <cfxml variable="xmlData"> <cars> <car> <name>Ford</name> <year>1990</year> <color>Red</color> </car> <car> <name>Toyota</name> <year>1995</year> <...

You are using the xmlSearch() function to retrieve data from an XML document. Which function signature most accurately describes the data types of the arguments?

Given the following XML data: <cfxml variable="xmlData"> <cars> <car> <name>Ford</name> <year>1990</year> <color>Red</color> </car> <car> <name>Toyota</name> <year>1995</year> <col...

You are using the <cfinclude> tag to include one page of code into another page of code. Where does ColdFusion look for the file if the value of the template attributes starts with...

Which ColdFusion tag allows you to render the body of a file into another?

You are using <cf_...> syntax to call a CFM file as a custom tag. Where does ColdFusion look first for the custom tag file?

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...

What is the correct syntax for a CFC function declared within a <cfscript> block that always returns a structure and throws a runtime error if the incorrect type is returned?

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

What must you do when calling a SOAP-based web service by its service name rather than the service's WSDL URL?

You are using cfinvoke. Which property allows you to specify the URL of the WSDL file you want to consume?

After migrating your fully-tested application from development into production, you begin receiving the following error message on your production server: Unable to read WSDL from...

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

Which declaration of the variable columnmap results in the successful output of an RSS feed? <cfscript> qdata = querynew("name,description,url"); queryaddrow(qdata,3); querysetcell...

What is the name of the <cfhttp> tag attribute that should be set to the remote URL when retrieving content over the web?

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 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?

What is the correct syntax for creating a new directory named subfolder under the directory containing the currently executing code?

In your application, you need to create a directory to which files can be copied. Which attribute specifies the location of the directory to be created?

What is the correct prefix for addressing files stored in server memory?

Given the following statement: <cffile action="write" output="#cfcData#" file="#filename#/> Which value for the variable filename writes the cfcData to a file named data.txt in RAM...

Given the following code stub: <cfset obj = {key='Apple',basic=['one','two']} /> Which returns the string "two"?

Given the following snippet: <cfset x=2> <cfoutput> #--x# - #x++# </cfoutput> What is the output?

What is the value of the variable b when the following code block executes? <cfscript> a = 0; b = 1; a = (a)?b:a; if (a) { b = "apple"; }{ b = "pear"; } </cfscript>

What is the value of the variable output when the following code executes? <cfset output = "There is no answer" /> <cfif 1 eq true> <cfset output = "The answer is one" /> <cfelseif...

Given the follow code snippet: <cfset startTime = CreateDateTime(2009,1,1,0,0,0)> <cfset endTime = CreateDateTime(2009,1,3,12,0,0)> <cfset i = 2> <cfloop from="#startTime#" to="#en...

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

You want to load a single entity of type ART from your ORM, using the primary key value 5 as a filter. Which two function signatures can you use to accomplish this task? (Choose tw...

In which variable scope is the init variable available?

Which code segment can be used to store an array of structures as a client variable?

Your application has the following query which is invalid: <cftry> <cfquery datasource="goodphoto" name="test"> SELECT * FROM ... </cfquery> <cfcatch type="any"> </cfcatch> </cftry...

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 *...

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

In your application you run the following query: <cfquery datasource="test" name="getUsers"> SELECT id, name, email FROM users; </cfquery> Which query tag allows you to query the r...

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

Your application has the following query that is running slowly: <cfquery datasource="testdb" result="data" name="result"> SELECT * FROM ... </cfquery> You want to know the amount...

What is the required data type of the <cftransaction> tag NESTED attribute?

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

Which use of <cfqueryparam> in a WHERE clause successfully filters a column named RECORDID to retrieve rows with primary key values that match a set of values in a list?

Given the following code: <cfset form.lcategories = "1,3,5"> <cfquery name="qcategories"> select * from category where categoryid in <!--- insert cfqueryparam here ---> </cfquery>...

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

Which Web application development task is most likely to benefit from the use of CFML- based regular expressions?

Which statement about a regular expression is true?

A <cfquery> tag with a well-formed SQL statement attempts to save a query object to the SESSION scope but generates a runtime error. When the same tag is executed with its name pro...

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...

Where is cached content saved by the <cfcache> tag by default?

Which ORM function should you use when loading data from the database to ensure that you receive the most recent data on the server?

Given the following CFQUERY tag: <cfquery name="qArtist" datasource="cfartgallery"> SELECT * FROM Artists </cfquery> Which statement caches the query object in memory?

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