This is interesting:

<cfset x=1>
<cfswitch expression="#x#">
     <cfcase value="1">
          <cfset x=2>
          <cfoutput>World </cfoutput>
     </cfcase>
     <cfcase value="2">
          <cfset x=1>
          <cfoutput>Hello</cfoutput>
     </cfcase>
</cfswitch>

The output for this one is: World

<cfscript>
x=1;
switch(x) {
	case 1: {x=2; WriteOutput(" World ");}
	case 2: {x=1; WriteOutput("Hello");}
}
</cfscript>

The output for this one is: World Hello

To have the same result as the <cfswitch> statement above, it needs to be like this:

<cfscript>
x=1;
switch(x) {
	case 1: {x=2; WriteOutput(" World ");
                break;}
	case 2: {x=1; WriteOutput("Hello");
                break;}
}
</cfscript>

| Post New Message

This is depressing. The more tests I take, the lower scores I got. I took the sample test at forta.com. The first time I got 83% and now I got 70%.

I took the skilldrill at cramsession, the first time I got 3.66, the second time 3.00, and the third time 3.44.

I guess I should have taken the test a month ago. I would have passed with high score :-)

How are you doing, Dan?
| Post New Message

That is what I don't understand. How do you know you increase the randomness of your number? How do you know if it works? :-) Exactly how does ColdFusion process it because rand() doesn't take an argument so how does it actually know that we have called Randomize before we call rand()? We call the two functions totally independently from each other. Are we adding the randomize() and rand() together to increase the randomness?

| Post New Message

Johnny - Try this.


Randomize(number)

Randomize() generates a "random" number based on "seed"
value. By calling Randomize() with a seed value before
using Rand(), you increase the "randomness" of your number

Related functions:
Rand()
Randomize()
RandRange()

Example:

<cfset Seed = (Minute(now())&Second(now()))>

<cfoutput>

Seed = #Seed#
#Randomize(Seed)#
#Rand()#

<a href="#cgi.script_name#">reload</a>

</cfoutput>

| Post New Message

Thanks, Dan. I tried it but I can't tell the difference between randomize() and Rand(). You may need to show me the difference:-)
| Post New Message

Johnny -

The randomize function is very handy. I've use it to randomly select ads to appear on a homepage, generate temporary passowrds, etc. I can show you examples if you'd like. Better yet, give it a try and see if it works!
| Post New Message

Topics to discuss when we meet:

What exactly does Randomize() function do?

What is the point of using CFPARAM without the "default" attribute?

What does it mean "ColdFusion variable names can be variables themselves"? page 14. I tried <cfset "#TheVar#"=15> and it doesn't work.

Is * a wildcard in SQL statements? I know SELECT * means selecting every column in the table, but does * in WHERE USERNAME LIKE "da*" mean anything?

P.34. <cfloop index="i" list="#month#">
<cfoutput>#VARIABLES.i#</cfoutput>
<cfloop>
Does this mean cfloop always creates local variables?

What is the difference between ColdFusion mapping and web server mapping? It seems like they are doing the same thing.

In English term, are these two things mean the same thing?
(1)"Decrypting Secure Sockets Layer (SSL) webpages" and (2)"Decrypting Secure Sockets Layer (SSL) web browser requests".
(3)"Encrypting web server requests using Secure Sockets Layers(SSL)" and (4)"Encrypting webpages using Secure Sockets Layers (SSL)".
Why do I ask? It seems that according to CFMX Exam Buster (web development concepts), (1) and (3) are tasks of a web browser and (2) and (4) are tasks of a web server.

| Post New Message

http://tutorial68.easycfm.com/
http://www.scriptlance.com/cgi-bin/freelancers/r.cgi?epeople
Undocumented ColdFusion MX 1.0
Real Time=Real Problem
Database searching with Stored Procedures
Error Tracking
Aggregating CFC objects with polymorphism
| Post New Message

Info:

cffile prefix
After a file upload is completed, you can get status information using file upload parameters. The status parameters use the cffile prefix; for example, cffile.clientDirectory. Status parameters can be used anywhere other ColdFusion parameters can be used. The file prefix is deprecated, in favor of the cffile prefix. Do not use the file prefix in new applications.

Session & lock
Always put code that accesses session variables inside cflock tags... You must lock any code that accesses or changes session variables.

Inside CFScript
CFScript supports all CFML expressions. CFML expressions include operators (such as +, -, EQ, and so on), as well as all CFML functions. As in all ColdFusion expressions, you must use CFML operators, such as LT, GT, and EQ. You cannot use JavaScript operators, such as <, >, ==, or ++.

Document weight
A document’s weight is the time it takes for the page to download

Server Request Timeout
You can override the server request timeout (set on the ColdFusion Administrator Server Settings page) by adding a RequestTimeout parameter to the action page URL. Requests that take longer than the specified time are terminated. The following example specifies a request time-out of two minutes:

<form name="getReportCriteria"
action="runReport.cfm?RequestTimeout=120"method="post">

_________________

Controlling ColdFusion login behavior
When you use the cfloginuser tag within a cflogin tag, ColdFusion stores a login token in a memory-only browser cookie. Therefore, to use the cflogin tag to check for an authenticated user, the user must enable memory-only cookies in the browser. The login cookie does not lasts after the user closes the browser.

You can use the cfloginuser tag without user cookies, but the login information remains in effect for only the current page. For more information on user logins without cookies, see “Using ColdFusion security without cookies� below.

_________________

File Scope prefix: required or not?
We omitted "file" scope out because we don't generally document it as a scope, rather as "returned" struct with status variables, and we've deprecated the use of the name "file" (recommend cffile instead).

_________________

Operators & expressions

_________________

Learn string functions especially RTrim(), Asc(), and StripCR()

_________________

Writing a chart to a variable: Once written to a variable, other ColdFusion pages can access the variable to display the chart, or you can write the variable to disk to save the chart to a file. This lets you create or update charts only as needed, rather than every time someone requests a page containing a chart.

You use the name attribute of the cfchart tag to write a chart to a variable. If you specify the name attribute, the chart is not rendered in the browser but is written to the variable.

_________________

ColdFusion doesn't support Outer Join or Inner Join syntax for query of queries

_________________

QueryAddColumn(query, column-name, array-name): New in ColdFusion MX: If a user attempts to add a column whose name is invalid, ColdFusion throws an error. (In earlier releases, ColdFusion permitted the add operation, but the user could not reference the column after adding it.)

_________________

How to set and use Variables with periods

_________________

These variables need to have prefix:
Attributes (custom tag)
Caller (on the custom tag page)
ThisTag (custom tag)
Request (duration of an HTTP request)
Session
Application
Server
Flash (flash remoting)
This (cffunction)

___________________

ListContains: Determines the index of the first list element that contains a specified substring. If not found, returns zero.
ListContains(list, substring [, delimiters ])
list: A list or a variable that contains one.
substring: A string or a variable that contains one. The search is case-sensitive.
delimiters: A string or a variable that contains one. Character(s) that separate list elements. Default: comma. If this parameter contains more than one character, ColdFusion processes each occurrence of each character as a delimiter.

__________________

Browser cookies:
Simple implementation
Good performance
Can be set to automatically expire
Client-side control

Users can configure browsers to disallow cookies
ColdFusion limits individual cookie data to 4 KB
Netscape Navigator allows only 20 cookies from any one host; ColdFusion uses three cookies to store read-only data, leaving only 17 additional cookies available for use
| Post New Message

1. When passing a URL variable, a way to ensure the proper format is ahered to as Web criteria emerges is to use the ____ function.
a: UPDATEURL
b: URLEncodedFormat
c: BrowserFormatUpdate
d: None of the above

2. Which portion of a SELECT statement correctly stipulates the value to be returned is a number datatype rather than a text datatype?
a: WHERE song_id = #song_id#
b: WHERE song_id = "#song_id#"
c: WHERE song_id = "#number.song_id#"
d: WHERE song_id = "%song_id%"

3. <CFSET MAXCOUNT= 12> <CFSET MAXCOUNT= 15> <CFOUTPUT>#MAXCOUNT#</CFOUTPUT>
a: This returns 15.
b: This returns 12.
c: This returns 12 and 15.
d: This returns 27.

4. Which of the following is the correct format to access a CGI variable?
a: variable_name.CGI
b: CGI.variable_name
c: GATE.variable_name
d: variable_name.GATE

5. name(argument1, arugment2, argument3) is the format of a ________.
a: broad argument
b: function
c: expression
d: variable

6. What is the correct syntax of the CreateTime function?
a: CreateTime(hour.minute.second)
b: CreateTime((hour, minute, second))
c: CreateTime(second%minute%hour)
d: CreateTime(hour,minute,second)

7. 24 MOD 9 returns
a: 15
b: 6
c: 33
d: 2

8. The companion tag for CFSWITCH is
a: CFCASE
b: CFMOVE
c: CFELSEIF
d: CFELSE

9. The CFABORT tag without attributes
a: stops execution and displays data retrieved until the abort.
b: stops the execution and displays an error message.
c: stops the execution and redirects the user to an alternate URL.
d: show an error message with a "verify abort" link.

10. The Isolation attribute of the CFTRANSACTION tag has several levels, which of the following levels and descriptions is not a correct match?
a: Read_Uncommitted:No database locking
b: Read_Committed: No data reading allowed while data is being updated.
c: Repeatable_Read: Locking mechanisms are not employed, but message boxes will warn the user of possible overwrites.
d: Serialization:All locking mechanisms are deployed.

11. Consider the following: <CFQUERY NAME=GetInfo' DATA SOURCE='AddressBook' DBTYPE='ODBC' USERNAME='Admin' SELECT first_name, last_name, street, city, state., zip FROM address3 ORDER BY last_name </CFQUERY> Which of the CFQUERY components is not required?
a: NAME
b: DBTYPE
c: DATASOURCE
d: </CFQUERY>

12. If a field in the database will not accept a NULL value and you do not have access to the actual database, which SQL clause may be the remedy?
a: SELECT
b: GROUP BY
c: ALTER
d: DROP

13. Using the DateFormat function within CFOUTPUT, which of the following formats will create the output: "Jan 27, 1957"?
a: "m, d, y"
b: "mm-dd-yy"
c: 'mmm/d/yy'
d: "mmm. dd, yyyy"

14. Which of the following is a requirement in a list loop using CFLOOP?
a: DELIMITER
b: STARTROW
c: LOOP
d: NAME

15. In regard to this code, what is NOT a required attribute for CFLOOP? <CFLOOP INDEX="index_name" LIST="list_items" DELIMITERS="item_delimiter"> </CFLOOP>
a: </CFLOOP>
b: LIST
c: DELIMITERS
d: INDEX

16. In the following CFQUERY fragment what does the IN operator accomplish? SELECT * FROM Gear WHERE ID IN ( 15,16 )
a: Nothing is accomplished, IN is not valid in this instance.
b: The IN is identical to the XOR operator in this instance.
c: Records 15 and 16 are searched at once.
d: The result is formatted as two columns, 15 and 16.

17. Which of the following statements is true in regard to the CFGRIDUPDATE tag?
a: The tag is designed to update multiple tables and may cause errors when trying to update a single table.
b: All updating will stop when an editing error is encountered.
c: You have complete control over the order updating occurs when using this tag.
d: The Name attribute is required with CFDRIDUPDATE.

18. CFTREE only requires the NAME attribute.
a: True
b: False

19. Attributes of the CFTREEITEM tag include all of the following except
a: QUERY
b: IMG
c: CHILD
d: HREF

20. To ensure a field is filled in by users with the proper format, add the ____ attribute in the CFINPUT tag.
a: REQUIRED
b: VALIDATE
c: JAVASCRIPT
d: TEST

21. All of the following are built-in sessions variables except
a: session.CFTOKEN
b: session.sessionID
c: session.URLCookie
d: session.SessionID

22. The required attribute for the CFLOCK tag is
a: Nme
b: Timeout
c: Type
d: None of the above

23. The CFERROR tag must be placed within the CFAPPLICATION template to catch errors anywhere within the Cold Fusion project.
a: True
b: False

24. The ACTION attribute of the CFFILE tag supports several different values, which of the following is NOT a supported value?
a: MOVE
b: Appendix
c: COPY
d: READBINARY

25. This tag enables a user to work with directories, to create, to rename, to delete, and list them.
a: CFFILE
b: CFLIST
c: CFDIRECTORY
d: CFCATALOG

26. The Delete ACTION of the CFDIRECTORY tag uses automatically generated JavaScript to verify the deletion.
a: True
b: False

27. ColdFusion Studio defines 'document weight' as
a: how long it takes a document and the corresponding files to be downloaded
b: the size (in kb) of a document and the corresponding files
c: the total available real estate on a document
d: the height (in pixels) of all corresponding documents on a single Web site

28. Prepare ColdFusion for sending mail using the
a: CFMAIL tag
b: Mailto tag
c: ColdFusion Administrator
d: None of the above

29. To attach multiple files to a mail message, the ____ can be used.
a: CFMAILPARAM tag
b: MIMEATTACH attribute
c: GROUPFILESEND attribute
d: A and B above
e: All of the Above

30. The ACTION attribute of the CFPOP tag has three possible values, which of the following is one of those values?
a: GetPop
b: Erase
c: GetAll
d: GetHeader

31. Which of the following is NOT a true statement concerning the CFHTTP tag?
a: Retrieving Web pages is a common use of the tag, but it is identical to the CFLOCATION so rarely used.
b: The tag can be used to upload MIME file types to the server.
c: The tag can be used to convert a comma delimited text file into a query.
d: Data can be sent a server using this tag.

32. A CFFTP attribute for handling a poor quality connection is
a: TIMEON
b: CLEAR
c: RETRYCOUNT
d: TIMEOUTCONNECTION

33. The DE function can be used
a: to convert strings to string expressions
b: set a delay during an evaluation
c: to undo an ST (string conversion)
d: None of the above

34. ColdFusion supports IF-Else, While, For-In, Break in the form of statements, the ColdFusion tag associated with these
a: CFTAG
b: CFSCRIPT
c: CFPROG
d: CFWRITE

35. There is no < operator in CFScript.
a: True
b: False

36. To schedule a template there are three required parts, a name, a URL, and the date and time of the event.
a: True
b: False

37. Using Administrator to schedule a task, which of the following is NOT a timing option?
a: Daily at 21:00:02
b: Every 15 minutes Monthly
c: Weekly at 06:45:22
d: 08:00:00 Monthly

38. Using Administrator to schedule a task, if a start time and end time have been set in Duration, and a daily occurrence has also been set with a start time and end time, and there is a conflict, which will take precedence?
a: Duration settings
b: Daily settings

39. There are two functions that accompany CFAUTHENTICATE. They are
a: IsAuthenticated and IsAuthorized
b: Authentic and Validity
c: Secure and Unsecure
d: Valid and Invalid

40. Concerning the CFAUTHENTICATE tag, Users are authenticated
a: Administrator
b: an Application.cfm file
c: on the affected template
d: None of the above

41. To execute code as a particular user the ____ tag.
a: CFIMPERSONATE
b: CFADMINISTRATOR
c: CFOPENSECURTIY
d: None of the above


1. In the following code which is the variable ? <CFOUTPUT><CFSET today = Now()>#today#</CFOUTPUT>
a: today
b: Now
c: CFOUTPUT
d: #

2. When passing a URL variable, a way to ensure the proper format is ahered to as Web criteria emerges is to use the ____ function.
a: UPDATEURL
b: URLEncodedFormat
c: BrowserFormatUpdate
d: None of the above

3. Consider the code: <CFQUERY NAME="songquery" DATASOURCE="songbook"> SELECT Title, Key, Words FROM jazzset </CFQUERY> Which portion of the SELECT statement refers expressly to a database table?
a: Title
b: songbook
c: songquery
d: jazzset

4. Which of the following is used to validate a form field?
a: <INPUT TYPE="textarea" NAME="title_required" VALUE="Title required.">
b: <INPUT TYPE="hidden" NAME="title_required" VALUE="Title required.">
c: <INPUT TYPE=hidden NAME=title_required value=Title required.>
d: <INPUT = "hidden" NAME="title_required" VALUE="Title required.">

5. Which of the following is the correct format to access a CGI variable?
a: variable_name.CGI
b: CGI.variable_name
c: GATE.variable_name
d: variable_name.GATE

6. URL variables
a: are browser dependent.
b: are not browser dependent.

7. CreateTime, IsArray, DateFormat, and Len are all examples of ________.
a: built-in functions
b: custom functions
c: expressions
d: built-in variables

8. 24 MOD 9 returns
a: 15
b: 6
c: 33
d: 2

9. In relation to Boolean operators which of the following is true?
a: OR returns true if both values are false
b: XOR returns true if both values are true
c: AND returns true is either value is true
d: EQV returns true when both values are true or both values are false

10. In relation to Boolean operators which of the following is NOT true?
a: OR returns true if both values are true
b: XOR returns true if either values is true
c: AND returns true is both values are true
d: IMP returns false if the statement If A then B is true

11. Within Cold Fusion Studio you can create an SQL query using the
a: SQL Builder Tool
b: Expression DataBank
c: CFQUERY Creator
d: Pop-Up SQL Writer

12. Using Cold Fusion Studio,the SQL Query Builder will show you the results of your query before you paste the query into your document.
a: True
b: False

13. The result of this query will NOT include which of the following names? <CFQUERY NAME='GetInfo'> DATASOURSE="AddressBook' SELECT * FROM address3 WHERE LEFT(last_name, 1) BETWEEN 'a' AND 'p' ORDER BY last_name </CFQUERY>
a: Anderson
b: Rabinowitz
c: Partermann
d: Diltshire

14. What is the problem with this portion of a CFQUERY statement? <CFQUERY NAME="get_wood" DATASOURCE="Plywood"> CREATE TABLE 4by2
a: The statement is missing a tag.
b: The Table name is the problem.
c: The Create clause is not supported by the CFQUERY tag.
d: The query name is the problem.

15. In the following what does "_____.__" represent? <CFOUTPUT>#numberformat(9876.32, "$_____.__")#</CFOUTPUT>
a: The way the number is to be displayed on the page is represented.
b: This represents the way the data is formatted within the database.
c: This is called a mask and represents the way data is entered into the database.
d: None of the above

6. In <CFOUTPUT>, the default time display, if no mask is provided is
a: 06:45 PM
b: 6:45
c: 18:45
d: 6:45 PM

17. What is the result of the following as CFOUTPUT? #ListLen("1,2|3,4,"|")#
a: 1
b: 2
c: 4
d: 5

18. In ColdFusion a ten element array begins with the index ____ and ends with the index ____.
a: 0;9
b: 1;10
c: 2;10
d: x;10

18. In ColdFusion a ten element array begins with the index ____ and ends with the index ____.
a: 0;9
b: 1;10
c: 2;10
d: x;10

19. What is the role of the second use of CFSET in this fragment? <CFSET Gear2=ArrayNew(2)> <CFSET Gear2[1,1]="Value 1/1"> <CFSET Gear2[1,2]="Value 1/2">
a: to count the elements
b: to Find the elements
c: to populate the array
d: to convert an array into a series variable.

20. In the following CFQUERY fragment what does the IN operator accomplish? SELECT * FROM Gear WHERE ID IN ( 15,16 )
a: Nothing is accomplished, IN is not valid in this instance.
b: The IN is identical to the XOR operator in this instance.
c: Records 15 and 16 are searched at once.
d: The result is formatted as two columns, 15 and 16.

21. The VALIDATE attribute of the CFINPUT tag supports all of the following values, except
a: Float
b: Telephone
c: Creditcard
d: Natural

22. All of the following are built-in sessions variables except
a: session.CFTOKEN
b: session.sessionID
c: session.URLCookie
d: session.SessionID

23. When created, a server variable must be ____.
a: locked
b: timed
c: in the registry
d: tied to an application

24. The required attribute for the CFLOCK tag is
a: Nme
b: Timeout
c: Type
d: None of the above

25. Using CFTRY and CFCATCH error, which of the following is NOT a type of error that can be handled?
a: Template
b: Security
c: MissingInclude
d: Variable

26. The Default CFCATCH error type is
a: Default
b: Database
c: Custom
d: Any

27. What is the purpose of this code? <FORM ACTION='Cygn.cfm' METHOD="POST" ENCTYPE='multipart/form-data"> <INPUT TYPE="File" NAME="AnyFile"><BR> <INPUT TYPE="SUBMIT"> </FORM>
a: to create an upload form
b: to create a generic form
c: to redefine an existing multipart form
d: None of the above

28. when using this code fragment, <CFFILE ACTION="UPLOAD" which additional atrribute is associated only with a UNIX environment?
a: ACCEPT
b: MODE
c: DESTINATION
d: FILEFIELD

29. While using the CFFILE tag with the UPLOAD action, which File variable is not matched correctly with the return?
a: File.FileExisted: indicates whether a file already exists in the specific directory
b: File.ServerFile: the filename a file was saved as on the server
c: File.ServerFileName: the filname and extension of the file that was uploaded to the server
d: File.OldFileSize: the size of the file that was overwritten by the uploaded file

30. Using the Design view of ColdFusion Studio can adversely affect the non-HTML code in your application.
a: True
b: False

31. The tool within ColdFusion Studio to step through lines of code is the
a: CodeWatcher
b: Tag Chooser
c: Expression Builder
d: Debugger

32. Cold Fusion Studio allows a user to turn on and off a Tag Validation tool.
a: True
b: False

33. To reduce the file size of ColdFusion templates by reducing white space from the Administrator select ____ within the Server section.
a: Limit sile size
b: Enforce suppression
c: Suppress white space by default
d: Eliminate white space

34. Within the Basic Security screen in the Server section of ColdFusion Administrator, several tags can be disabled, which of the following is one of those tags?
a: CFAPPLICATION
b: CFLOCK
c: CFQUERY
d: CFCONTENT

35. When setting a maximum timeout for a session variable if there is a conflict with the setting in a CFAPPLICATION tag and the ColdFusion Administrator setting, which method will be applied.
a: the setting in a CFAPPLICATION tag
b: the setting in ColdFusion Administrator

36. Creating a form for sending an email does not require validation, the CFMAIL tag has these checks built-in.
a: True
b: False

37. The correct format for the CFMAIL parameters tag is
a: <PARAM='c:\report\expenses.txt'>
b: <CFMAILPARAM="c:\report\expenses.txt">
c: <CFMAILPARAM='c:\report\expenses.txt'>
d: <CFPARAM="c:\reports\expenses.txt.">

38. To attach multiple files to a mail message, the ____ can be used.
a: CFMAILPARAM tag
b: MIMEATTACH attribute
c: GROUPFILESEND attribute
d: A and B above
e: All of the Above

40. Consider the code: <CFFTP CONNECTION="ShallowConnection" ACTION="ListDir" DIRECTORY="/*"> To list the top level directory wat is wrong with this code?
a: The syntax of ACTION is incorrect
b: CONNECTION is unsupported
c: the syntax of DIRECTORY is incorrect
d: A required tag is missing

41. The ColdFusion function within scripting to output to a browser is
a: WriteOutPut
b: Write
c: Write.URL
d: Pass

42. Which of the following statements in reference to CFScript is true?
a: CFScript is not case-sensitive.
b: CFScript is a subset of JavaScript.
c: The Window object is not available.
d: User-defined functions are available.

43. This code will generally be found <CFIF IsAuthorized("UserObject","ListDisplayCode","Execute")>
a: in Administrator Setup
b: on an Application.cfm file
c: on an individual template
d: None of the above

44. Send dynamic attributes to CFX tags using the
a: DYNAMICATTRIBUTE attribute
b: ATTRIBUTECOLLECTION attribute
c: DYNCFX attribute
d: None of the above

45. To add a registry key use the ____ ACTION with CFREGISTRY.
a: GET
b: Set
c: GetAll
d: None of the above



1. What tags would be needed to upload a file from a client’s browser to the ColdFusion server and then syndicate the file to a remote FTP site? (select 1)
<CFFILE>
<CFCONTENT>
<CFFILE> and <CFCONTENT>
<CFFTP>
<CFCONTENT> and <CFFTP>
<CFFILE> and <CFFTP>

2. Which of these assignments are valid? (select 2)
<CFSET user[lastname]="Forta">
<CFSET user.last name="Forta">
<CFSET user.lastname="Forta">
<CFSET user."lastname"="Forta">

3. Which scope is used to access data submitted via Flash Remoting? (select 2)
URL
FLASH
ATTRIBUTES
ARGUMENTS

4. Which of the following CFML language elements create XML Document Objects? (select 2)
XMLSearch()
XMLFormat()
<CFXML>
XMLParse()

5. A Collection loop is used to loop over a structure that contains key-value pairs of Animal-Cow, Legs-4, and Tail-Yes. What is the value of the attribute ITEM in the loop? (select 1)
Animal, Legs, Tail
Cow, 4, Tail
Animal. Cow, Legs. 4, Tail. Yes
Cow, 4, Yes

6. Which protocols may be used to access ColdFusion? (select 2)
http
pop
snmp
https
ftp

7. Which of the following cannot be achieved in a <CFSCRIPT> block? (select 2)
Custom tag execution
HTTP requests
Looping
CORBA object invocation
ColdFusion Component invocation
Variable assignments

8. Which of the following is a valid method of creating URL variables? (select 1)
<CFPARAM name="URL.FName" default="Emily">
<A NAME="index.cfm?#URLEncodedFormat("Emily Kim")#">
<A HREF="index.cfm?#URLEncodedFormat("Emily Kim")#">
<CFSET URLVar.FName="Emily">

9. The exact string you want to replace is not known, but a general pattern can be determined. What kind of string manipulation should you use? (select 1)
Constant
Regular expression

10. Which kind of join is being used in this statement? (select 1)
SELECT customers.customer_name,
customers.customer_id,
orders.order_id,
orders.order_date
FROM customers, orders
WHERE customers.customer_id*=orders.customer_id
Inner
Full outer
Left outer
Equi
Right outer

11. Which of the following statements would you use to convert a ColdFusion two-dimensional array called names into a WDDX packet and write the results to the page? (select 1)
<CFWDDX ACTION="CFML2WDDX" INPUT="#names#" OUTPUT="This.Page">
<CFWDDX ACTION="CFML2WDDX" INPUT="#names#" WRITETOPAGE="Yes">
<CFWDDX ACTION="CFML2WDDX" INPUT="#names#">
<CFWDDX ACTION="CFML2PAGE" INPUT="#names#">

12. What is the output of the following code? (select 1)
<CFSCRIPT>
x=1;
SWITCH(x){
CASE 1: {x=2; WriteOutput("-World-");}
CASE 2: {x=1; WriteOutput("-Hello-");}
}
</CFSCRIPT>
"Hello World"
"World"
"World Hello World"
"World Hello"

13. Which of the following <CFFUNCTION> arguments is required? (select 1)
OUTPUT
ACCESS
RETURNTYPE
NAME

14. Which SELECT clause must be used in order to obtain counts or other aggregates for different rows (as opposed to all rows)? (select 1)
WHERE
HAVING
ORDER BY
GROUP BY

15. Which of the following tags reuses code most efficiently? (select 1)
<CF_CustomTag>
<CFMODULE>
<CFPARAM>
<CFINCLUDE>

16. <CFCHART> drill-down variables are delimited with what characters? (select 1)
$
#
*
%
@
/
"

17. Which of the following are ways of setting the APPLICATION variable time-out? (select 2)
A <CFIF IsDefined()> statement
The Application.cfm file
ColdFusion Administrator settings
The <CFAPPLICATION> tag

18. Which <CFLDAP> attribute is used to specify the distinguished name of the entry for a directory branch within which a search is performed? (select 1)
STARTROW
DN
SCOPE
START

19. Where are APPLICATION variables stored? (select 1)
Server cookies
Database
Client cookies
Server memory

20. Database queries can be cached into which of the following scopes? (select 3)
APPLICATION
CLIENT
VARIABLES
COOKIE
SERVER

21. What does LDAP use as a unique reference or primary key in the directory hierarchy? (select 1)
RDN
objectclass
UUID
DN

22. What are valid reasons to use CFCs? (select 3)
Accessible outside of ColdFusion
Tiered development
Reuse
Error handling
Access to underlying Java

23. In which ExecutionMode should most Custom Tag processing typically occur? (select 1)
inactive
start
end

24. Which are valid <CFSCHEDULE> ACTION values? (select 3)
RUN
ADD
DELETE
UPDATE

25. Choose all the statements that are true. (select 2)
The letters in DE() stand for do evaluation.
The DE() function stops ColdFusion from processing expressions.
DE() and IIf() can be used together.
The DE() function is always used to display output.

26. Why are stored procedures better than views or queries? (select 3)
They work with all databases.
They execute faster.
They are more secure.
They are easier to create.
They are more powerful.

27. Which of the following is logically equivalent to TRUE? (select 3)
-1
1
ON
YES

28. ColdFusion will search for an Application.cfm file in which directories? (select 2)
The current directory
Any parent directory
Subdirectories of the current directory
Any directory

29. Which operators are used to test for equality? (select 2)
EQ
IS THE SAME AS
==
=
IS

30. Which of the following <CFERROR> types is used to check form input? (select 1)
Form
Validation
Exception
Error


Here's your score ...
You got 25 out of 30 right scoring 83%.

You have successfully passed the sample test and in our estimation you have a very good chance of passing the real certification exam!

Based on your responses, it is recommended that you review the following chapters in the Certified Macromedia ColdFusion MX Developer Study Guide:


3: Conditional Processing
16: Scripting
30: WDDX
31: Flash Remoting
37: LDAP
Here are the answers to the questions you got wrong:


Which scope is used to access data submitted via Flash Remoting?:
FLASH
ARGUMENTS


Which of the following statements would you use to convert a ColdFusion two-dimensional array called names into a WDDX packet and write the results to the page?:
<CFWDDX ACTION="CFML2WDDX" INPUT="#names#">


What is the output of the following code?:
<CFSCRIPT>
x=1;
SWITCH(x){
CASE 1: {x=2; WriteOutput("-World-");}
CASE 2: {x=1; WriteOutput("-Hello-");}
}
</CFSCRIPT>
"World Hello"


Which <CFLDAP> attribute is used to specify the distinguished name of the entry for a directory branch within which a search is performed?:
START


Which operators are used to test for equality?:
EQ
IS


1) Which of the following lines of code could be used to upload a file to a directory on the web server?
<CFFILE ACTION="upload" FILEFIELD="form.name" DESTINATION="c:\web\myfiles\">
<CFFILE Action="upload" filefield="form.name" destination="http://www.ncsacademy.com/uploads/">
<CFFORM Action="upload" filefield="form.name" method="post">
<CFFORM Action="upload" filefield="form.name" destination="C:\web\myfiles\">

2) Cookies have a maximum length, in Kilobytes, of what?
16
2
4
8

3) Which of the following tags is used by ColdFusion to interact with a database?
CFQUERY
CFSET
CFDB
CFDATA

4) When converting a number to a Boolean value which of the following would result in a 'True' value?
2
3
1
All of these

6) Which of the following is the default delimiter for a ColdFusion list?
Semicolon
Carriage Return
Tab
Comma

7) What would be the output of the following code?
#ListLen("1,2|3,4|5,6","|")#
4
2
6
3

8) Which list function returns a given list without the first element?
ListRest
ListLast
ListLen
ListAppend

9) Which of the following ColdFusion statements creates a one dimensional array named 'faculty'?
<CFSET faculty=ArrayNew[1]><CFSET faculty=ArrayNew(1)><CFSET faculty=NewArray[1]><CFSET faculty=NewArray(1)>
11) Which of the following attributes is not required when using the CFFTP tag?
SERVER
PASSWORD
USERNAME
TIMEOUT

12) What is the output of the following ColdFusion statement?
#DollarFormat(-1234.789)#
$1,234.79
-$1,234.79
($1,234.79)
-$1234.79

13) Which of the following is a valid ColdFusion variable name?
my variable
my-variable
m123
1ofmyvariables

14) What is the maximum number of cookies that can be set by a server?
8
64
20
16

15) Which character/character sequence is used to end a multi-line comment when using ColdFusion scripting?
//
-->
*/
/*

16) When scripting with ColdFusion which of the following statements is used to cease execution of a loop immediately?
Break
Continue
Exit
Abort

17) Which of the following data types is not supported by ColdFusion?
Date/time values
COM objects
Boolean values
Enumerations

18) Which ColdFusion tag causes the execution of a template to stop and the results displayed?
<CFEND><CFBREAK><CFABORT><CFSHOW>
19) What are the two allowed values for the CFERROR tag TYPE attribute?
Request, Validation
Validation, Query
Request, Processing
Processing, Query

20) When using the ColdFusion application framework what are the two options for storage of client variables?
Registry, Database
Registry, Cookie
Logfile, Cookie
Logfile, Database

21) The ____________ function can be used to delete a specific session variable while the __________ function will delete all session variables?
StructDelete, StructRemove
StructDelete, StructClear
StructErase, StructClear
StructErase, StructRemove

23) When defining a mask for use with the DateFormat function which of the following specifies the full name of the month?
monthname
mmmm
mmm
mm

24) About how long should it take for the cookie set below to expire?<CFCOOKIE name="testitem" value="correct" expires="60">
One hour
One minute
Two months
After 60 visits to the website

25) If an expiration date is not indicated when setting a cookie, when will it expire?
Immediately
When the client browser closes
Never
After approximately 24 hours

26) When scripting with ColdFusion which of the following statements causes the loop to proceed immediately to the next iteration?
Break
Continue
Proceed
Exit

27) How are special characters such as pound signs and quotation marks escaped in ColdFusion?
By preceding them with a backslash
By repeating them
By preceding them with a forward slash
By using the function Escape( )

28) Which string operator is used to concatenate strings?
||
+(string)
&
>>

29) Which Boolean operator evalutes to false if and only if each input value is false?
XOR
IMP
OR
AND

30) Which ColdFusion operator is used to raise a number to a power?
*
-
^
/

31) Which of the following ColdFusion operators takes the highest precedence?
*
+
&
^

32) Which of the following notations would be used to reference a custom tag written in standard ColdFusion?
CFX_tagname
CF_tagname
CF(tagname)
CFX(tagname)

33) Which ColdFusion tag is used to create and modify variables?
CFVARIABLE
CFSET
CFOUTPUT
CFIF

34) The DE( ) function in ColdFusion does which of the following?
Converts numbers to a given number of decimal places
Destroys an environmental variable
Converts a number to base 10
Delays evaluation of contents

35) A CFCATCH tag must be nested within which of the following tags to function properly?
CFTHROW
CFTRY
CFIF
CFERROR
| Post New Message

How does the ColdFusion scheduler execute code in a specified template? (select 1)
Using cron or at processes, depending on the operating system
Using an HTTP call
Using command-line arguments

When can deadlocks occur? (select 2)
When locks are in a different order on different pages
When locks are nested
When locks wait for each other and are not nested
When READONLY locks are declared against the CLIENT scope

What is the output from the following loop? (select 1)
<!--- Set up variables for condition --->
<CFSET NumToGet="3">
<CFSET i="1">
<!--- Now loop --->
<CFLOOP CONDITION="i LTE NumToGet">
<CFSET i=i+1>
<CFOUTPUT>#i#
</CFLOOP>
2 3 4
2 3
1 2
1 2 3

Which of the following CFML language elements create XML Document Objects? (select 2)
XMLFormat()
<CFXML>
XMLParse()
XMLSearch()

The loop variable is assigned using the INDEX attribute in which types of loops? (select 2)
List
Conditional
Index
Collection

Which function is used to convert an XML Document Object to its string representation? (select 1)
DOMToString()
XMLFormat()
ToXML()
ToString()
XMLParse()

Which two of the following statements are false? (select 2)
An associative array is a form of array.
Arrays can have a maximum of three dimensions.
One-dimensional arrays can contain simple values.
Multidimensional arrays are "arrays in arrays."

Which SELECT clause must be used in order to obtain counts or other aggregates for different rows (as opposed to all rows)? (select 1)
HAVING
WHERE
GROUP BY
ORDER BY

Which variable type can be shared among clustered servers (using standalone ColdFusion)? (select 1)
SESSION
CLIENT
SERVER
COOKIE

Application.cfm should not be used for which of the following tasks? (select 1)
Defining the application using <CFAPPLICATION>
Including a generic HTML header file to maintain a standard look and feel across the application
Implementing error handling using <CFERROR>
Assigning default variables and global constants

Which are valid <CFPOP> actions? (select 3)
RECEIVE
GETHEADERONLY
GETATTACHMENTS
SEND
GETALL
DELETE

What advantages does the Verity K2 version have over the VDK interface? (select 2)
File formats
Performance
Distributability
Languages

When many conditions will be tested, what tag is best to use? (select 1)
<CFTESTCASE>
<CFIF>/<CFELSEIF>
<CFSWITCH>/<CFCASE>
<CFLOOP>

Which of the following may be used to populate a <CFCHART>? (select 4)
Stored procedure results
Database queries
Manually provided data points
XML
Structures
Web Services

Which function should you use to ensure that extra white space around a string is removed? (select 1)
URLEncodedFormat()
Trim()
Val()
StripSpaces()

What tags would be needed to upload a file from a client’s browser to the ColdFusion server and then syndicate the file to a remote FTP site? (select 1)
<CFFTP>
<CFFILE> and <CFFTP>
<CFCONTENT>
<CFFILE>
<CFCONTENT> and <CFFTP>
<CFFILE> and <CFCONTENT>

What types of variables are exposed through server-side debug options? (select 3)
CGI
ARGUMENTS
SESSION
VARIABLES
REQUEST

Where should <CFLOGIN> be used? (select 1)
In index.cfm
In OnRequestEnd.cfm
In Application.cfm
In a <CFAPPLICATION> tag

What will be the output of the following code? (select 1)
<CFOUTPUT>#IIF(1 is 1,"1;2;3","'Hello'")#</CFOUTPUT>
1
2
3
Hello

Which counter is an indicator of sufficient memory for the cache? (select 1)
Bytes In/Sec
DB Hits/Sec
Cache Pops/Sec
Queued Requests

Which counter is an indicator of sufficient memory for the cache? (select 1)
Bytes In/Sec
DB Hits/Sec
Cache Pops/Sec
Queued Requests

Which of the following is a valid method of creating URL variables? (select 1)
<CFSET URLVar.FName="Emily">
<A HREF="index.cfm?#URLEncodedFormat("Emily Kim")#">
<A NAME="index.cfm?#URLEncodedFormat("Emily Kim")#">
<CFPARAM name="URL.FName" default="Emily">

How many elements are in the list "Ben Forta"? (select 1)
0
1
2
5 or less
9 or less

Where must OnRequestEnd.cfm be in order to be executed? (select 1)
In the current directory
In the Web root
In the same directory as the executed Application.cfm
In the application root

Assuming a default installation on a Windows machine, which file could be executed if <CF_MyTag> were used in your code? (select 2)
MyTag.cfm in the current directory
c:\customtags\MyTag.cfm
C:\cfusionmx\MyTag.cfm
C:\cfusionmx\customtags\MyTag.cfm

Which tag would you use to obtain the size of a file? (select 1)
<CFDIRECTORY>
<CFSIZE>
<CFCONTENT>
<CFFILE>

The exact string you want to replace is not known, but a general pattern can be determined. What kind of string manipulation should you use? (select 1)
Constant
Regular expression

When should the TYPE attribute of the <CFPROCPARAM> tag be set to INOUT? (select 1)
A parameter is sent to a stored procedure and a different parameter is returned.
A parameter needs to be sent back from a stored procedure only.
A stored procedure optionally accepts parameters.
A parameter of the same name is sent and received from the stored procedure.

Which of the following are ways of setting the APPLICATION variable time-out? (select 2)
The Application.cfm file
ColdFusion Administrator settings
A <CFIF IsDefined()> statement
The <CFAPPLICATION> tag

Which isolation level is the least efficient? (select 1)
READ UNCOMMITTED
SERIALIZABLE
REPEATABLE READ
READ COMMITTED

Which kind of join is being used in this statement? (select 1)
SELECT customers.customer_name,
customers.customer_id,
orders.order_id,
orders.order_date
FROM customers, orders
WHERE customers.customer_id*=orders.customer_id
Equi
Right outer
Left outer
Inner
Full outer

A Collection loop is used to loop over a structure that contains key-value pairs of Animal-Cow, Legs-4, and Tail-Yes. What is the value of the attribute ITEM in the loop? (select 1)
Cow, 4, Tail
Cow, 4, Yes
Animal. Cow, Legs. 4, Tail. Yes
Animal, Legs, Tail

What output would the following code generate? (select 1)
<CFSET name="Ben">
<CFSWITCH EXPRESSION="name">
<CFCASE VALUE="Ben">
Hello Ben.
</CFCASE>
<CFCASE VALUE="Angela">
Hello Angela.
</CFCASE>
<CFCASE VALUE="Jeff">
Hello Jeff.
</CFCASE>
<CFDEFAULTCASE>
I have no idea who you are.
</CFDEFAULTCASE>
</CFSWITCH>
Hello Ben.
Hello Angela.
Hello Jeff.
I have no idea who you are.

Which of the following is not a valid ACTION attribute for the <CFWDDX> tag? (select 1)
CFML2JS
CFML2WDDX
CFML2ASP
WDDX2CFML

Which tag is used to optimize a Verity collection? (select 2)
<CFOPTIMIZE>
<CFINDEX>
<CFFILE>
<CFCOLLECTION>

Which value of the ENCTYPE attribute of <FORM> is required to enable file uploads from the browser? (select 1)
ENCTYPE="upload"
ENCTYPE="multipart/form-data"
ENCTYPE="text/plain"
ENCTYPE="application/x-www-form-urlencoded"

Which protocols are Web Services built on? (select 2)
POP
MIME
SOAP
XML
LDAP

Which <CFQUERY> attribute is used to reduce the number of round-trips to the database server during data retrieval? (select 1)
PACKETSIZE
BLOCKSIZE
CACHEDWITHIN
BLOCKFACTOR
KEEPALIVE
CACHEDAFTER

Which tag is used to invoke Web Services? (select 1)
<CFSERVICE>
<CFOBJECT>
<CFINVOKE>
<CFXML>
<CFWSDL>
<CFHTTP>

Which of the following is an example of a form control that does not pass a value to the action page by default? (select 1)
Text box
Checkbox
Text area
Drop-down select control


Based on your responses, it is recommended that you review the following chapters:
19: Transactions
27: Web Services
29: XML
30: WDDX
32: Graphing
33: Full Text Searching
43: Improving Performance
45: Server Performance Tuning
Here are the answers to the questions you got wrong:

Which counter is an indicator of sufficient memory for the cache?:
Cache Pops/Sec

Which of the following CFML language elements create XML Document Objects?:
XMLParse()
<CFXML>

Which of the following may be used to populate a <CFCHART>?:
Database queries
Web Services
Manually provided data points
Stored procedure results

Which isolation level is the least efficient?:
SERIALIZABLE

Which of the following is not a valid ACTION attribute for the <CFWDDX> tag?:
CFML2ASP

Which tag is used to optimize a Verity collection?:
<CFINDEX>
<CFCOLLECTION>

Which protocols are Web Services built on?:
SOAP
XML

Which <CFQUERY> attribute is used to reduce the number of round-trips to the database server during data retrieval?:
BLOCKFACTOR

Which tag is used to invoke Web Services?:
<CFINVOKE>

Hey Dan, this is the exam guide that I want you to see, not those sample questions that made me stumble :-)
| Post New Message

Dan's server is funny. I was trying to use querying queries and it says my datasource is missing. I checked with ColdFusion 5 documentation and it has querying queries. So I tried to use CFDUMP var="#server#" to see what version he is running and it says "ColdFusion cannot determine how to process the tag . The tag name may be misspelled." So I can't use querying queries and can't use CFDUMP either. Dan, I guess you are running on 4.5 then. :-( We need to get you to ColdFusion MX, dude :-)

# posted by Johnny : 6:02 PM

| Post New Message

What is the difference between:

select Customers.Customer_name
FROM customers c1 inner join customers c2
on (c1.customer_city=c2.customer_city)
WHERE c1.customer_state='CA'

(page 348)
AND

select Customers.Customer_name
FROM customers c1
WHERE c1.customer_state='CA'

I don't see the difference. c1.customer_city is always equal c2.customer_city. I think the only difference is that the first statement would eliminate NULL customer_city.
| Post New Message

18) Which of the following statements is true concerning NAME attribute of the CFLOCK tag?
It is not required and its use does not effect the functioning of your code.
It is required and your code will create an error if it is omitted.
It is not required but failure to use it may result in locking problems with multiple users.
It is normally required however you can override it's use in the Application.cfm template.


19) You want to allow users who do not have cookies enabled to access your site which utilizes session management. Which of the following ColdFusion variables should you append to each URL in order to allow this?
application.URLTOKEN
application.CFTOKEN
session.CFTOKEN
session.URLTOKEN

5. The CGI variable that represents the IP address or DNS name of a Web server is
a: SERVER_PROTOCOL
b: HTTP_REFERER
c: SERVER_PORT
d: SERVER_NAME

6. You cannot assign a value to a CGI variable using CFSET.
a: True
b: False

18. What is the result of the following SQL statement? SELECT Name INTO First_Name FROM Addresses
a: A new table, First_Name, is created and populated from the Addresses table.
b: A new table, Addresses, is created and populated from the First_Name table.
c: First_Name populates a drop down list from the Addresses table with name.
d: First_Name populates an existing table from the Addresses table with name

23. A built-in function that affects the position of an element in an array is
a: ArraySwap
b: ArrayMove
c: ArrayCut
d: ArrayPlace

25. Within the CFGRID tag, SELECTMODE="Browse" indicates
a: elements in the grid will not be available for editing.
b: the particular browser value stipulated by the W3C.
c: the query will yield all data that has not been updated since a stipulated date.
d: the selection of the NAME is done by the browser.

32. While using the CFFILE tag with the UPLOAD action, which File variable is not matched correctly with the return?
a: FileClientDirectory: the directory to file was uploaded to on the server
b: FileContentType: the MIME type of the uploaded file
c: File.TimeCreated: the time the uploaded file was saved unto the server
d: File.FileExisted: indicates whether a file already exists in the specific directory

33. The ACTION=READ attribute of the CFFILE tag has two required tags, they are
a: FILE and OUTPUT
b: FILE and VARIABLE
c: FILE and MODE
d: FILE and ATTRIBUTES

35. The section in ColdFusion Administrator to record the Administrator email for error messages is
a: Server
b: Data Source
c: Logging
d: Misellaneous

36. When using this tag: <CFHTTP METHOD=GET URL='http://www/skilldrill.com'> Where is the data, by default, stored on your server?
a: CFHTTP.File-Content
b: COLDFUSION/LOG/Content
c: HTTP/LOG/Content
d: HTTP.Content-File

37. In this code what role does the username and password take? <CFHTTP METHOD=GET URL='http://www/skilldrill.com' USERNAME: doublephi PASSWORD: 4257x>
a: To gain access to the downloading server
b: To enable the GET method username and password are required
c: To gain access to a protected site to download from
d: None of the above

38. Which of the following statements is NOT true concerning CFScript?
a: CFScript supports all CFML expressions.
b: You cannot use CFML tags in CFScript.
c: You cannot read or write variables within the script region.
d: All statements end in a semi-colon.

39. Scheduling a ColdFusion template can be arranged through
a: Administrator
b: the CFSCRIPT tag
c: the CFSCHEDULE tag
d: A and C Above
e: None of the above

41. In relation to security, if running Enterprise, to manage what each individual developer is authorized to do, create what is termed
a: a Sandbox
b: a Safe
c: an Admin Block
d: a Nest

42. -Using Administrator to set security, to secure a UserObject, the default action is Execute.
a: True
b: False

43. To reference a custom tag that has been created using a language other than ColdFusion,
a: CFX_TagName
b: CF_TagName
c: CM_TagName
d: CU_TagName

44. Concerning custom tags, variables that are available to all custom tags begin with
a: ThisTag
b: Variable
c: TagVar
d: Assoc

45. Disable CFREGISTRY processing ColdFusion Administrator
a: Advanced Security section
b: Logging section
c: Registry section
d: Basic Security

Which of the following keywords creates protected variables within a UDF? (select 1)
set
return
variable
var

Why are CFCs the preferred method for utilizing Flash Remoting? (select 2)
Performance
Portability
Separation of presentation and content
Access to all CFML
Simplified integration

Why will the following code fail? (select 2)

<CFSET a = ArrayNew(1)>
<CFSET ArrayResize(a, 400)>
<CFSET LoopUntil = ArrayLen(a)>
<CFLOOP FROM="1" TO="#LoopUntil#" INDEX="i">
<CFSET ArrayDelete(a, i)>
</CFLOOP>
The loop will go past the array's length.
<CFSET> requires an equals sign.
The index passed to ArrayDelete() will be invalid.
An array must be resized to a size greater than 500.

Which of the following are true about <CFHEADER>? (select 2)
It can be used to prevent a browser from caching a page.
It can be used to prevent a server from caching a page.
It creates attribute/value pairs in the request header.
It creates attribute/value pairs in the response header.

What CFML language element can be used to invoke a Java object? (select 2)
<CFOBJECT>
CreateObject()
<CFJAVA>
JavaCast()

Which of the following are valid scheduler intervals? (select 2)
weekly
hourly
15
90

<CFHTTP> with METHOD="GET" can send what type of parameters to the remote URL? (select 1)
FILE uploads
URL parameters
FORM variables
COOKIE variables

What tag would you use to access a JSP Tag Library? (select 1)
<CFJSP>
<CFINVOKE>
<CFIMPORT>
<CFJAVA>
<CFOBJECT>
<CFMODULE>

What is the best way to set default values for optional Custom Tag attributes? (select 1)
<CFPARAM NAME="MyAttribute" DEFAULT="MyValue">
<CFSET MyAttribute="MyValue">
<INPUT TYPE="hidden" NAME="MyAttribute" VALUE="MyValue">
<CF_MYCUSTOMTAG MYATTRIBUTE="MyValue">

<CFMAILPARAM> is used to perform which of the following? (select 2)
Set mail headers
Generate HTML email
Retry undelivered mail
Send attachments

From which of the following can ColdFusion MX debugging output be accessed? (select 3)
Flash MX
Web browser
ColdFusion Administrator
Dreamweaver MX
ColdFusion Studio

Which of the following statements are true? (select 2)
Variable based caching can be disabled.
Query-based caching requires the use of locks.
Query-based caching can be disabled.
Variables based caching requires the use of locks.

In LDAP, the distinguished name is what? (select 2)
A unique reference to an attribute in the directory
The objectclass definition
A concatenation of an RDN and its ancestor attributes
The name of an entry in the directory

Which Verity features are inherent in a SIMPLE query expression? (select 3)
MANY modifier
Wildcards
STEM operator
NEAR operator

Where are APPLICATION variables stored? (select 1)
Database
Server memory
Server cookies
Client cookies

What are the advantages of tag-based UDFs over <CFSCRIPT>-based UDFs? (select 2)
Ability to be used as tag attributes
Execution speed
Ability to be passed as a parameter to another UDF
Automatic argument and type checking
Ability to access any CFML language elements

Which code would you use to create a variable in a Custom Tag that could be passed back into the calling page? (select 1)
<CFSET ExposeVariable(FirstName, "Emily")>
<CFSET FirstName="Emily">
<CFSET Caller.FirstName="Emily">
<CFSET SetVariable(FirstName, "Emily")>

Which <CFFUNCTION> attributes are required for a function to be accessible as a Web Service? (select 3)
OUTPUT
RETURNTYPE
ACCESS
NAME
ROLES

<CFPROCRESULT> returns what type of data? (select 1)
Simple data
Queries
Structure of arrays
Arrays

Which character should never appear alone on a line in a generated email message? (select 1)
#
<
.
>

Which of the following statements is false? (select 1)
SQL is not typeless.
Single statements should never include double quotes (single quotes should be used instead).
SQL SELECT statements return columns in the order specified.
SQL may be case sensitive.

Which variable scopes should be locked to ensure controlled access (preventing race-conditions)? (select 4)
APPLICATION
SESSION
SERVER
REQUEST
CLIENT

Which of the following database features could you use to ensure data consistency? (select 2)
Trigger
Stored procedure
Primary key
Index

Which tag is used to optimize a Verity collection? (select 2)
<CFOPTIMIZE>
<CFFILE>
<CFCOLLECTION>
<CFINDEX>

Choose the legal <CFLOCK> statement. (select 1)
<CFLOCK TIMEOUT="16">
<CFLOCK NAME="myLock" TIMEOUT="16">
<CFLOCK SCOPE="myLock" TIMEOUT="16" TYPE="readonly">
<CFLOCK NAME="myLock" SCOPE="session" TIMEOUT="16">

What is the primary purpose of <CFTRANSACTION>? (select 1)
To commit all inserts to the database
To supplement the <CFLOCK> tag in locking database records
To make sure dirty reads do not take place
To support COMMIT and ROLLBACK features of a relational database system

Which <CFHTTP> variable would you inspect to learn information about the remote Web server? (select 1)
StatusCode
FileContent
Header
MimeType

Which of the following statements are true? (select 3)
ColdFusion enforces isolation when a database does not.
Isolation levels affect performance.
The <CFTRANSACTION> tag can control isolation levels.
Isolation levels affect locking.

Which one of the following is not true of Index loops? (select 1)
They can iterate over the alphabet.
The loop value variable is assigned using the INDEX attribute.
They can iterate over numeric values.
They can step by negative increments.


Here are the answers to the questions you got wrong:


From which of the following can ColdFusion MX debugging output be accessed?:
Flash MX
Web browser
Dreamweaver MX


Which of the following statements are true?:
Query-based caching can be disabled.
Variables based caching requires the use of locks.


In LDAP, the distinguished name is what?:
A unique reference to an attribute in the directory
A concatenation of an RDN and its ancestor attributes


Which Verity features are inherent in a SIMPLE query expression?:
MANY modifier
Wildcards
STEM operator


What are the advantages of tag-based UDFs over <CFSCRIPT>-based UDFs?:
Automatic argument and type checking
Ability to access any CFML language elements


<CFPROCRESULT> returns what type of data?:
Queries


Which of the following are counters for the ColdFusion object in Performance Monitor?:
Average DB Time
Average Queue Time
Average Request Time

Here are the answers to the questions you got wrong:


Which variable scopes should be locked to ensure controlled access (preventing race-conditions)?:
APPLICATION
SESSION
SERVER
CLIENT


Which of the following database features could you use to ensure data consistency?:
Trigger
Stored procedure


Which tag is used to optimize a Verity collection?:
<CFCOLLECTION>
<CFINDEX>


Which isolation level is the least efficient?:
SERIALIZABLE


What advantages does the Verity K2 version have over the VDK interface?:
File formats
Performance


New tags, attributes, and values
Deprecated tags, attributes, and values
Obsolete tags, attributes, and values

New functions, parameters, and values
Deprecated functions, parameters, and values
Obsolete functions, parameters, and values

Rules for embedding comments in CFML code
| Post New Message

CGI server variables
The following table describes common CGI environment variables that the server creates (some of these are not available with some servers): CGI server variable Description
SERVER_SOFTWARE
Name and version of the information server software answering the request (and running the gateway). Format: name/version.

SERVER_NAME
Server's hostname, DNS alias, or IP address as it appears in self-referencing URLs.

GATEWAY_INTERFACE
CGI specification revision with which this server complies. Format: CGI/revision.

SERVER_PROTOCOL
Name and revision of the information protocol this request came in with. Format: protocol/revision.

SERVER_PORT
Port number to which the request was sent.

REQUEST_METHOD
Method with which the request was made. For HTTP, this is Get, Head, Post, and so on.

PATH_INFO
Extra path information, as given by the client. Scripts can be accessed by their virtual pathname, followed by extra information at the end of this path. The extra information is sent as PATH_INFO.

PATH_TRANSLATED
Translated version of PATH_INFO after any virtual-to-physical mapping.

SCRIPT_NAME
Virtual path to the script that is executing; used for self-referencing URLs.

QUERY_STRING
Query information that follows the ? in the URL that referenced this script.

REMOTE_HOST
Hostname making the request. If the server does not have this information, it sets REMOTE_ADDR and does not set REMOTE_HOST.

REMOTE_ADDR
IP address of the remote host making the request.

AUTH_TYPE
If the server supports user authentication, and the script is protected, the protocol-specific authentication method used to validate the user.

REMOTE_USER
AUTH_USER
If the server supports user authentication, and the script is protected, the username the user has authenticated as. (Also available as AUTH_USER.)

REMOTE_IDENT
If the HTTP server supports RFC 931 identification, this variable is set to the remote username retrieved from the server. Use this variable for logging only.

CONTENT_TYPE
For queries that have attached information, such as HTTP POST and PUT, this is the content type of the data.

CONTENT_LENGTH
Length of the content as given by the client.


CGI client variables
The following table describes common CGI environment variables the browser creates and passes in the request header: CGI client variable Description
HTTP_REFERER
The referring document that linked to or submitted form data.

HTTP_USER_AGENT
The browser that the client is currently using to send the request. Format: software/version library/version.

HTTP_IF_MODIFIED_SINCE
The last time the page was modified. The browser determines whether to set this variable, usually in response to the server having sent the LAST_MODIFIED HTTP header. It can be used to take advantage of browser-side caching.


CGI client certificate variables
ColdFusion makes available the following client certificate data. These variables are available when running Microsoft IIS 4.0 or Netscape Enterprise under SSL if your web server is configured to accept client certificates. CGI client certificate
variable
Description
CERT_SUBJECT
Client-specific information provided by the web server. This data typically includes the client's name, e-mail address, etc. For example:
O = "VeriSign, Inc.", OU = VeriSign Trust Network, OU = "www.verisign.com/repository/RPA Incorp. by Ref.,LIAB.LTD(c)98", OU = Persona Not Validated, OU = Digital ID Class 1 - Microsoft, CN = Matthew Lund, E = mlund@macromedia.com

CERT_ISSUER
Information about the authority that provided the client certificate. For example:
O = "VeriSign, Inc.", OU = VeriSign Trust Network, OU = "www.verisign.com/repository/RPA Incorp. By Ref.,LIAB.LTD(c)98", CN = VeriSign Class 1 CA Individual Subscriber-Persona Not Validated

CLIENT_CERT_ENCODED
The entire client certificate binary, base-64 encoded. This data is typically of interest to developers,so they can integrate with other software that uses client certificates.
| Post New Message

Client variables
The following client variables are read-only:
Client.CFID
Client.CFToken
Client.HitCount
Client.LastVisit
Client.TimeCreated
Client.URLToken

Server variables
Server.ColdFusion.ProductName
Server.ColdFusion.ProductVersion
Server.ColdFusion.ProductLevel
Server.ColdFusion.SerialNumber
Server.ColdFusion.SupportedLocales
Server.OS.Name
Server.OS.AdditionalInformation
Server.OS.Version
Server.OS.BuildNumber

Form variable
Form.FieldNames

query variables
queryname.CurrentRow
queryname.RecordCount
queryname.ColumnList

CFCATCH variables
Within a cfcatch block, the active exception properties can be accessed as the following variables:
CFCATCH.Type
CFCATCH.Message
CFCATCH.Detail
CFCATCH.ErrNumber
CFCATCH.NativeErrorCode
CFCATCH.SQLState
CFCATCH.LockName
CFCATCH.LockOperation
CFCATCH.MissingFileName
CFCATCH.TagContext
CFCATCH.ErrorCode
CFCATCH.ExtendedInfo

CFDIRECTORY variables
The cfdirectory tag, with action=list, returns a query object as follows, where queryname is the name attribute value:
queryname.Name
queryname.Size
queryname.Type
queryname.DateLastModified
queryname.Attributes
queryname.Mode

CFERROR variables
When cferror generates an error page, the following error variables are available if type="request", "exception", or "monitor".
Error.Diagnostics
Error.MailTo
Error.DateTime
Error.Browser
Error.GeneratedContent
Error.RemoteAddress
Error.HTTPReferer
Error.Template
Error.QueryString

The following error variables are available if type="validation".
Error.ValidationHeader
Error.InvalidFields
Error.ValidationFooter

Any cfcatch variable that applies to exception type can be accessed within the Error scope, as follows:
Error.Type
Error.Message
Error.Detail
Error.ErrNumber
Error.NativeErrorCode
Error.SQLState
Error.LockName
Error.LockOperation
Error.MissingFileName
Error.TagContext
Error.ErrorCode
Error.ExtendedInfo

Note: You can substitute the prefix CFERROR for Error, if type = "Exception" or "Monitor"; for example, CFERROR.Diagnostics, CFERROR.Mailto or CFERROR.DateTime.

CFFILE ACTION=Upload variables
File variables are read-only. Use the CFFILE prefix to reference file variables; for example, CFFILE.ClientDirectory. The File prefix is deprecated in favor of the CFFILE prefix.
CFFILE.AttemptedServerFile
CFFILE.ClientDirectory
CFFILE.ClientFile
CFFILE.ClientFileExt
CFFILE.ClientFileName
CFFILE.ContentSubType
CFFILE.ContentType
CFFILE.DateLastAccessed
CFFILE.FileExisted
CFFILE.FileSize
CFFILE.FileWasAppended
CFFILE.FileWasOverwritten
CFFILE.FileWasRenamed
CFFILE.FileWasSaved
CFFILE.OldFileSize
CFFILE.ServerDirectory
CFFILE.ServerFile
CFFILE.ServerFileExt
CFFILE.ServerFileName
CFFILE.TimeCreated
CFFILE.TimeLastModified


Standard CGI variables
This section lists the CGI 1.1 variables that some web servers create when a CGI script is called.

The CGI variables that are available for your use vary with the web server and configuration. Some of the following variables may not be available.

Request
CGI.AUTH_TYPE
CGI.CONTENT_LENGTH
CGI.CONTENT_TYPE
CGI.PATH_INFO
CGI.PATH_TRANSLATED
CGI.QUERY_STRING
CGI.REMOTE_ADDR
CGI.REMOTE_HOST
CGI.REMOTE_USER
CGI.REQUEST_METHOD
CGI.SCRIPT_NAME

Server
CGI.GATEWAY_INTERFACE
CGI.SERVER_NAME
CGI.SERVER_PORT
CGI.SERVER_PROTOCOL
CGI.SERVER_SOFTWARE

Client
CGI.CERT_ISSUER
CGI.CERT_SUBJECT
CGI.CLIENT_CERT_ENCODED
CGI.HTTP_ACCEPT
CGI.HTTP_IF_MODIFIED_SINCE
CGI.HTTP_USER_AGENT

The CERT_ISSUER, CERT_SUBJECT, CLIENT_CERT_ENCODED variables are available only when you use client certificates.


CFFTP error variables
When you use the cfftp stoponerror attribute, these variables are populated:
CFFTP.Succeeded
CFFTP.ErrorCode
CFFTP.ErrorText

CFFTP ReturnValue variable
Some cfftp file and directory operations provide a return value, in the variable CFFTP.ReturnValue. Its value is determined by the results of the action attribute. When you specify any of the following actions, cfftp returns a value:
GetCurrentDir
GetCurrentURL
ExistsDir
ExistsFile
Exists

CFFTP query object columns
When you use the cfftp tag with the listdir action, cfftp returns a query object, where queryname is the name attribute value, and row is the row number of each file or directory entry:
queryname.Name[row]
queryname.Path[row]
queryname.URL[row]
queryname.Length[row]
queryname.LastModified[row]
queryname.Attributes
queryname.IsDirectory
queryname.Mode

CFHTTP variables
A cfhttp get operation can return text and binary files. Files are downloaded and the contents stored in a variable or file, depending on the MIME type, as follows:
CFHTTP.FileContent
CFHTTP.MimeType
CFHTTP.Header
CFHTTP.ResponseHeader[http_hd_key]
CFHTTP.StatusCode

CFLDAP variables
The cfldap action=query tag returns information about the LDAP query, as follows:
queryname.CurrentRow
queryname.RecordCount
queryname.ColumnList

CFPOP variables
The cfpop tag returns the following result columns, depending on the action attribute value and the use of other attributes, such as attachmentpath, where queryname is the name attribute value:
queryname.Date
queryname.From
queryname.Body
queryname.Header
queryname.MessageNumber
queryname.ReplyTo
queryname.Subject
queryname.CC
queryname.To
queryname.CurrentRow
queryname.RecordCount
queryname.ColumnList
queryname.Attachments
queryname.AttachmentFiles

CFQUERY and CFSTOREDPROC variables
The cfquery tag returns information about the query in this variable:
CFQUERY.ExecutionTime

The cfquery tag uses the query name to scope the following data about the query:
queryname.CurrentRow
queryname.RecordCount
queryname.ColumnList

The cfstoredproc tag returns the following variables:
CFSTOREDPROC.ExecutionTime
CFSTOREDPROC.StatusCode
CFREGISTRY variables

The cfregistry tag returns a query record set that you can reference after executing the GetAll action, as follows, where queryname is the name attribute value:

queryname.Entry
queryname.Type
queryname.Value

CFSEARCH variables
A cfsearch operation returns the following variables, where searchname is the name attribute value:
searchname.URL
searchname.Key
searchname.Title
searchname.Score
searchname.Custom1 and Custom2
searchname.Summary
searchname.RecordCount
searchname.CurrentRow
searchname.RecordsSearched
searchname.ColumnList
http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Expressions4.jsp

| Post New Message

Refererences in HTML
References in PDF
ColdFusion tips
| Post New Message

Dan, here is the study guide from Macromedia.
Sample questions

The Certified ColdFusion MX Developer Exam consists of 66 challenging multiple choice and true/false questions delivered in a secure, proctored testing environment. You will have 75 minutes to complete the exam. Reference materials and discussion between examinees is strictly prohibited.

Candidates need to score 65% correct or better on the Certified ColdFusion MX Developer exam to pass and become certified. Candidates who score 80% or above are granted Advanced Certified ColdFusion MX Developer status.

So we have about a minute to answer each question. Let's shoot for over 80% score :-)
| Post New Message

Yah, I found that site about a month ago. I was just about to add it to the list.
| Post New Message

Have you see http://www.cfcertification.com/ yet? It has some good sections, including study tips, section reviews, practice questions, etc. With this, our book, and CFBuster, we'll be set.
| Post New Message

Okay, I've joined! I don't have anything to share right now. Lots of fusebox stuff, but no MX news. :) I'm now 1/3 of the way through the book. I'm looking forward to taking the practice exams.
| Post New Message

This is the most useful page I found on Macromedia
| Post New Message