Adobe® ColdFusion 9 ACE Exam v6.0

The following Application.cfc file is placed in the application root folder:
<cfcomponent>
<cffunction name="onRequest">
<div>On Request</div>
</cffunction>
<cffunction name="onRequestStart">
<div>On Request Start</div>
</cffunction>
</cfcomponent>
A CFM page in the application root folder contains the following HTML and text:
<div>Current Page</div>
When you browse the CFM page, what is the output?

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 />
<cfset variables.myVar = 3 />
<cfset local.myVar = 4 />
</cffunction>
</cfcomponent>
If accessed from a cfm page, what is the value of application.myVar?

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 FIRSTNAME and LASTNAME?

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 statement retrieves the user with an ID value of 3?

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 *
from person
where lastname like <!--- insert code here --->
</cfquery>
Which ColdFusion expression safely parameterizes the query to return all records that have lastnames starting with data input to a form field (form.search)?

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 results of the getUsers query?

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 of time the query takes so you can log it.
Which variable contains the length of time the query took to run?

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