9A0-127 Exam Questions

When should you use the <cfthrow> tag?

Given the following code: <cferror type="validation" template="handler.cfm"/> <cfform> Enter a value: <cfinput type="text" required="true" name="myinput" validateat="onServer" /> <...

You have a ColdFusion Component with a function that returns the total number of arguments passed into this function. You want to expose this function as a Web service. Which tags...

You have a Web page that you want to display in a PDF document format. Which tag should you use?

You write code that changes a value in the application scope. You are using the <cflock> tag to prevent race conditions and do not want to lock the entire application scope. What s...

You are using four scopes within a pageRL, Variables, Form, and CGI. Which of these four scopes is checked first by ColdFusion?

You want to keep track of the number of visitors on your Web site at any given time. Which variable scope allows you to do this?

The following <cfspreadsheet> command creates a spreadsheet containing data from an existing variable named myVar: <cfspreadsheet action="write" filename="#expandpath('sheet.xls')#...

What is the default format of charts generated by the <cfchart> tag?

Which font is NOT supported by <cfchart type="jpg">?

What is the order of precedence (greatest to least) for execution of the <cferror>, onError(), and <cftry>/<cfcatch> error handling strategies?

You are using the onError method of Application.cfc. Which two types of arguments can be passed to the onError method? (Choose two.)

The following Application.cfc file is placed in the application root folder: <cfcomponent> <cffunction name="onRequest"> <div>On Request</div> </cffunction> <cffunction name="onReq...

When your application is accessed for the first time, you must set initial data. Which method of Application.cfc should be used to detect the first request in a visit of a user?

The following code is placed in Application.cfc, outside of any function definitions: <cfset myvariable="a value"> What is the scope and visibility of the variable?

Given the following Application.cfc file: <cfcomponent> <cfset this.name="myapp" /> <cffunction name="onRequestStart"> <cfset application.myVar = 1 /> <cfset this.myVar = 2 /> <cfs...

Which <cfquery> command successfully inserts a row of data into a table with an automatically generated incremental primary key column named RECORDID and two String columns named F...

You are using cfquery to access a database. Which SQL clause allows you to modify records already stored in the database?

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

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

What are two valid locations in which to place a CFC file on the server disk so its functions can be called from CFM pages in a ColdFusion application? (Choose two.)

Your application makes use of functions. Which benefit can be gained by organizing those functions into a ColdFusion component?

You want to create a ColdFusion component using by CFScript with a single public method named doSomething(). Which syntax should you use?

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

You have created a ColdFusion component in your application. Inside that component you need to create a property called user that CANNOT be seen outside the component. Which defini...

You want to create an instance of the component Part, then access the property partID by using the following code: <cfobject component="Part" name="thisPart"> <cfset thisPart.partI...

A CFC file named MyComponent.cfc is stored in the cfc subfolder of the web server's document root folder. Which <cfscript> statement correctly creates an instance of the CFC?

You want to instantiate a component, then call two methods of that component and capture the return values in two variables, val1 and val2. Which two should you use to accomplish t...

What is the correct value of the <cffunction> tag's access attribute for CFC functions that you want to expose over the Web using SOAP or Flash Remoting?

You want to publish a web service. Where must your CFC be located for the service to be accessible?

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

Given the following code: <cfcomponent> <cfset x = 1> <cfset y = 2> <cffunction name="F1" access="remote"> <cfset var x = 5> <cfset y = 3> <cfreturn x + y> </cffunction> </cfcompon...

Which attribute is used in a component definition to create an inheritance relationship with a super or base component?

In your application you must model the relationship between several objects. If object A extends object B, which OO technique is being used?

In which situations will ColdFusion validate data types defined by the <cfproperty> tag? (Choose two.)

Your application utilizes ColdFusion components exposed as web services. Which tag allows you to define complex data types for your web service?

Your application utilizes ColdFusion components organized into folders. The User.cfc file is stored in the vo folder inside the app directory of your webroot. Which tag instantiate...

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

You want to use the component Art.cfc to represent entities within the table Art in the datasource artGallery using the ColdFusion ORM. This datasource refers to a MySql database....

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

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

You want to delete an Art entity from the ColdFusion ORM and from the database. The array of Art entities is stored within the array aArt, and the entity to be deleted is the secon...

You are utilizing ORM in ColdFusion 9. Which tag should you use to map table fields to variables of the component?

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 which value should the access attribute of a CFC function be set, so the function is available only to CFCs in the same physical folder?

By using the <cfset> tag, you declare variables inside the onApplicationStart() method in the Application.cfc file. The variables are declared without any specific scope or var key...

You do NOT have an Application.cfc or Application.cfm file in your application. When ColdFusion processes the Web pages in the application, how far up the folder structure will Col...

You set up an Application.cfc file that includes the onApplicationStart() method to initialize application-level variables. Which three options trigger the onApplicationStart() met...

You enable session management and set the default time-out to be 30 minutes for a session using code placed after the <cfcomponent> tag in the Application.cfc. When does this code...

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