21. Which of the following is NOT correct about ColdFusion 9?
ColdFusion 9 has a new caching function cacheGetSession.
IIS 7 configuration for ColdFusion has no dependency on IIS 6 Metabase compatibility.
ColdFusion 9 does not support storing of data in Amazon S3.
Answer
Correct Answer:
ColdFusion 9 does not support storing of data in Amazon S3.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
22. What will be the name of the CFC if the component file name is myFirstComponent.cfc?
myfirstcomponent
MyFirstComponent
myFirstComponent
Firstcomponent
Answer
Correct Answer:
myFirstComponent
Note: This Question is unanswered, help us to find answer for this one
Check Answer
23. In which of the following ways can you instantiate CFCs and invoke CFC methods?
cfinvoke tag
URL
Form control
Web services
Answer
Correct Answer:
cfinvoke tag URL Form control Web services
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
Check Answer
24. In cftry block, which of the following is an optional tag and always executes, whether or not there is a file upload exception?
cffinally
cfcatch
Answer
Correct Answer:
cffinally
Note: This Question is unanswered, help us to find answer for this one
Check Answer
25. Which of the following are reserved words in ColdFusion 9 and should NOT be used for ColdFusion variables, user-defined function names, or custom tag names?
Any name starting with cf
ColdFusion Operators
HASH
CGI variable names
None of the above should be used.
Answer
Correct Answer:
None of the above should be used.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
26. Which of the following is INCORRECT with regard to referring to the contents of an XML object?
By default, ColdFusion ignores element name case.
If the XML object is case sensitive, use dot notation to refer to an element or attribute name.
You cannot use DOM methods in place of structure entry names.
Answer
Correct Answer:
If the XML object is case sensitive, use dot notation to refer to an element or attribute name.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
27. Which of the following tags can be used to create a CFC?
cfcomponent
cfargument
cffunction
cfapplication
Answer
Correct Answer:
cfcomponent cfargument cffunction
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
Check Answer
28. Which of the following values of the action attribute of the cffile tag have been added in ColdFusion 9?
readBinary
uploadAll
write
rename
Answer
Correct Answer:
uploadAll
Note: This Question is unanswered, help us to find answer for this one
Check Answer
29. Which of the following statements holds true if you import CFCs in the Application.cfm page?
The CFC is not imported on other pages of the application.
The CFC is available to the default application page only.
The CFC is available to all the application pages.
Answer
Correct Answer:
The CFC is not imported on other pages of the application.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
30. For which of the following tags does the cfprocparam define its parameters?
cfquery
cfstoredproc
cfprocresult
Answer
Correct Answer:
cfstoredproc
Note: This Question is unanswered, help us to find answer for this one
Check Answer
31. Which of the following DOM level core specifications does ColdFusion 9 conform to?
DOM Level 1
DOM Level 2
DOM Level 3
Answer
Correct Answer:
DOM Level 2
Note: This Question is unanswered, help us to find answer for this one
Check Answer
32. If ColdFusion mappings and custom tag roots can exist within the web root, then from which of the following locations can the CFC be accessed?
URL
Form
Web services
Flash Remoting
Answer
Correct Answer:
URL Form Web services Flash Remoting
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
Check Answer
33. Which of the following tags is used to catch and process exceptions in ColdFusion application pages?
cfcache
cfcatch
cfcase
cfbreak
Note: This Question is unanswered, help us to find answer for this one
Check Answer
34. Which of the following is the correct way to define a component method parameter named temp?
<cfargument name="temp" required="yes" type="numeric">
</cffunction>
</cfcomponent>
<cffunction name="ctof" output="false">
</cffunction>
</cfcomponent>
<cffunction name="ctof" output="false">
</cffunction>
</cfcomponent>
Answer
Correct Answer:
<cfargument name="temp" required="yes" type="numeric">
</cffunction>
</cfcomponent>
Note: This Question is unanswered, help us to find answer for this one
Check Answer
35. Which of the following ColdFusion 9 tags do NOT allow custom attributes and do NOT return any value?
cfabort
cfcomponent
cfthrow
cfloop
Answer
Correct Answer:
cfabort cfthrow
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
Check Answer
36. Which of the following tags specifies the name of the file to be included in your ColdFusion page?
cfset
cfinclude
cfparam
cfloop
Answer
Correct Answer:
cfinclude
Note: This Question is unanswered, help us to find answer for this one
Check Answer
37. Which of the following ColdFusion conversion functions validates XML against a DTD?
xmlParse()
xmlTransform()
xmlNew()
isXMLDoc()
Answer
Correct Answer:
xmlParse()
Note: This Question is unanswered, help us to find answer for this one
Check Answer
38. You have defined a field (EmailAd) on your user registration form to get the user email. Which of the following helps you validate the data before passing it to the database?
IsValid("email", Form.EmailAd)
IsEmail(Form.EmailAd)
IsEmail(#Form.EmailAd#)
IsValidType("email", Form.EmailAd)
Answer
Correct Answer:
IsValid("email", Form.EmailAd)
Note: This Question is unanswered, help us to find answer for this one
Check Answer
39. What is correct syntax for accessing an item of a structure?
StructFind(item, struct)
StructFind(struct, item)
FindStruct(struct, item)
FindStruct(item, struct)
Answer
Correct Answer:
StructFind(struct, item)
Note: This Question is unanswered, help us to find answer for this one
Check Answer
40. Query of Queries cannot be performed on cfassociate.
True
False
Note: This Question is unanswered, help us to find answer for this one
Check Answer
41. Which of the following tags is not useful in handling exceptions?
cftry
cfcatch
cfrethrow
cfabort
cferror
Note: This Question is unanswered, help us to find answer for this one
Check Answer
42. A coldfusion list is defined as follows:
4, 5, 7, 7
4, 4, 7, 7
4, 4, 4, 4
4, 5, 6, 6
Answer
Correct Answer:
4, 4, 4, 4
Note: This Question is unanswered, help us to find answer for this one
Check Answer
43. Which of the following is not a valid array function?
ArrayAppend
ArrayInsertAt
ArraySize
ArrayPrepend
None of the above
Answer
Correct Answer:
ArraySize
Note: This Question is unanswered, help us to find answer for this one
Check Answer
44. What is the output of the following code:
-1=-1
b-a=c
b-a = -1
Nothing will be displayed
Answer
Correct Answer:
Nothing will be displayed
Note: This Question is unanswered, help us to find answer for this one
Check Answer
45. Which of the following statements is incorrect with regard to Coldfusion Tags?
Cold fusion has vast library of in built tags
CFX tags are written using java or C++
They must have a closing tag
The tags without body can be closed using '/>' on the same line
Answer
Correct Answer:
They must have a closing tag
Note: This Question is unanswered, help us to find answer for this one
Check Answer
46. What is the output of the following code:
strabc = abc , strxyz = xyz
strabc = 123 , strxyz = 321
strabc = abc123 , strxyz = xyz321
strabc = abc 123 , strxyz = xyz 321
strabc = abc,123 , strxyz = xyz,321
None of the above
Answer
Correct Answer:
strabc = abc123 , strxyz = xyz321
Note: This Question is unanswered, help us to find answer for this one
Check Answer
47. What is the output of the following code:
123
124
123.5
122
100
Note: This Question is unanswered, help us to find answer for this one
Check Answer
48. What is the output of the following code:
3300
0 0 33
0 33 0
33 0 0
Note: This Question is unanswered, help us to find answer for this one
Check Answer
49. What is the output of the following code:
This is day 30 in the month of November, which has 30 days
This is day 23 in the month of November, which has 30 days
This is day 30 in the month of March, which has 30 days
23rd of November, which has 30 days
Answer
Correct Answer:
This is day 23 in the month of November, which has 30 days
Note: This Question is unanswered, help us to find answer for this one
Check Answer
50. What does the cfNTauthenticate tag do?
Returns the version of Windows NT running on the web server
It verifies if the database being used by the application is running
Authenticates a user name and password against the Windows NT domain
It authenticates an original version of the ColdFusion server
Answer
Correct Answer:
Authenticates a user name and password against the Windows NT domain
Note: This Question is unanswered, help us to find answer for this one
Check Answer
51. What will be the result of placing the following code in any cfm file:
The page will be timed out after 20 seconds
The current session will time out after 20 minutes
Delete all session variables
Nothing will happen
Answer
Correct Answer:
Delete all session variables
Note: This Question is unanswered, help us to find answer for this one
Check Answer
52. What does the cfproperty tag do?
Defines properties of a ColdFusion file
Defines properties of a ColdFusion user defined function
Sets properties for the ColdFusion application
Defines properties of a ColdFusion component
Answer
Correct Answer:
Defines properties of a ColdFusion component
Note: This Question is unanswered, help us to find answer for this one
Check Answer
53. You have created an extension to Coldfusion tag named "CalcClass." It needs one integer argument named "IntValue." Which of the following enables you to call that in the Coldfusion code?
cftag class=CalcClass IntValue=20
cfx name=CalcClass IntValue=20
cfx_CalcClass IntValue=20
cfx tag=CalcClass IntValue=20
Answer
Correct Answer:
cfx_CalcClass IntValue=20
Note: This Question is unanswered, help us to find answer for this one
Check Answer
54. How will you test whether a cookie has already been set on the clients browser?
CFIF IsDefined(COOKIE("VistorId"))
CFIF IsDefined("CFCOOKIE.VistorId")
CFIF IsDefined("COOKIE.VistorId")
None of the above
Answer
Correct Answer:
CFIF IsDefined("CFCOOKIE.VistorId")
Note: This Question is unanswered, help us to find answer for this one
Check Answer
55. Which of the following tags was introduced in the ColdFusion MX series?
cfcalendar
cfapplet
cfbreak
cfdirectory
Answer
Correct Answer:
cfcalendar
Note: This Question is unanswered, help us to find answer for this one
Check Answer
56. What is the output of the following code:
I love jelly
I love jellies
I Love jelly, cookies
I love cookies
Answer
Correct Answer:
I love cookies
Note: This Question is unanswered, help us to find answer for this one
Check Answer
57. What does the Randomize function return?
A pseudo-random integer number, in the range 0-5
A pseudo-random number, in the range 0-10
A pseudo-random decimal number, in the range 0-100
A pseudo-random decimal number, in the range 0-1
Answer
Correct Answer:
A pseudo-random decimal number, in the range 0-1
Note: This Question is unanswered, help us to find answer for this one
Check Answer
58. When would you prefer to use the <cfstoredproc> tag in place of the <cfquery> tag?
When you want to execute a stored procedure instead of an in-line query
When you want to execute a stored procedure that returns multiple recordsets
When you want to execute a stored procedure that accepts parameters
Never, because <cfstoredproc> doesn't offer any advantages over cfquery
Answer
Correct Answer:
When you want to execute a stored procedure that returns multiple recordsets
Note: This Question is unanswered, help us to find answer for this one
Check Answer
59. Which ColdFusion tag is used to import a Java Server Page (JSP) tag library?
cfjimport
cfimport
cfinclude
cfinsert
cfsetting
Note: This Question is unanswered, help us to find answer for this one
Check Answer
60. What is the output of the following code:
Welcome ProjectManager
You are not a ProjectManager
Welcome
Six Sigma ProjectManager
You are not a Six Sigma
None of the above
Answer
Correct Answer:
Six Sigma ProjectManager
Note: This Question is unanswered, help us to find answer for this one
Check Answer
61. What will the xInfo variable contain:
It returns the text of the 6th tag named info
It returns the text of the 5th tag named info
It returns the attribute of the 5th tag named info
It returns the text of the 5th element named info surrounded by the info/info tags
None of the above
Answer
Correct Answer:
None of the above
Note: This Question is unanswered, help us to find answer for this one
Check Answer
62. Which of the following constitute the core components of ColdFusion MX?
ColdFusion application server
ColdFusion Markup Language
ColdFusion MX Administrator
All of the above
Answer
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
Check Answer
63. The <cfhttp> tag can have multiple <cfhttpparam> tags, subject to certain limitations. Which are these limitations?
The formField type attribute is only meaningful with the cfhttp tag POST and GET methods
The file and formField type attributes cannot be used with the cfhttp tag TRACE method
The file type attribute is only meaningful with the cfhttp tag POST and PUT methods
Both a and c
Both b and c
All the above
Answer
Correct Answer:
Both a and c
Note: This Question is unanswered, help us to find answer for this one
Check Answer
64. What is the output of the following code:
reverse(6*2) equals 12
reverse(2*6) equals 21
reverse(6*2) equals 21
reverse(2*6) equals 12
Answer
Correct Answer:
reverse(6*2) equals 21
Note: This Question is unanswered, help us to find answer for this one
Check Answer
65. Which ColdFusion tag is used to stop the processing on the current page and opens a new ColdFusion or html file?
cfredirection
cfrelocate
cflocation
cfnewpage
Answer
Correct Answer:
cflocation
Note: This Question is unanswered, help us to find answer for this one
Check Answer
66. Your website has to display the personal information of the user when he logs in. The table storing the personal details is 'TbUser' (with primary key Uid) and the data source is 'UserDSN.' The user id ('Uid') is passed by the login screen. Which of the following helps you retrieve the information from the database?
cfselect name="GetUserDetails" DSN="UserDSN" select * from TbUser where Uid = #This.Uid#/cfselect
cfquery name="GetUserDetails" datasource="UserDSN" select * from TbUser where Uid = #URL.Uid#/cfquery
cfselect name="GetUserDetails" DSN="UserDSN" select * from TbUser where Uid = #Form.Uid#/cfselect
cfquery datasource="UserDSN" select * from TbUser where Uid = #URL.Uid#/cfquery
Answer
Correct Answer:
cfquery name="GetUserDetails" datasource="UserDSN" select * from TbUser where Uid = #URL.Uid#/cfquery
Note: This Question is unanswered, help us to find answer for this one
Check Answer
67. Which of the following is not an in-built complex data type in Coldfusion?
query
array
hashtable
structure
Answer
Correct Answer:
hashtable
Note: This Question is unanswered, help us to find answer for this one
Check Answer
68. Which operator will be evaluated first in the following statement:
+
-
/
*
Note: This Question is unanswered, help us to find answer for this one
Check Answer
69. Which of the following statements is correct with regard to Coldfusion functions?
Nesting of functions is not allowed
Functions can be created using cffunction or cfscript tag
Function may return a value
In-built functions can't be used with user defined ones
Answer
Correct Answer:
Functions can be created using cffunction or cfscript tag
Note: This Question is unanswered, help us to find answer for this one
Check Answer
70. Which of the following statements with respect to the below code is correct?
This code will display the first record from the complete greatoffers table
This code will display a random record from the complete greatoffers table leaving out the first record
This code will display a random record from the complete greatoffers table
This code will display the last record from the complete greatoffers table
This code will display a random record from the complete greatoffers table leaving out the last record
Answer
Correct Answer:
This code will display the last record from the complete greatoffers table
Note: This Question is unanswered, help us to find answer for this one
Check Answer
71. Consider the following <cfquery> tag:
WHERE column1 is null
WHERE column1 = null
WHERE column1 EQUALS null
WHERE column1 NOT null
WHERE column1 CONTAINS null
Answer
Correct Answer:
WHERE column1 is null
Note: This Question is unanswered, help us to find answer for this one
Check Answer
72. Which of the following ColdFusion tags is used to get the elements, variables and values of ColdFusion objects?
cfcollect
cfcomponent
cfdump
cfdocument
Note: This Question is unanswered, help us to find answer for this one
Check Answer
73. What does the cferror tag do?
Displays a custom HTML page when an error occurs
Displays the error code when an error occurs
It identifies the error and suggests a remedy
Answer
Correct Answer:
Displays a custom HTML page when an error occurs
Note: This Question is unanswered, help us to find answer for this one
Check Answer
74. Which of the following statements are true when you upload an image file using the <cffile> tag?
You can know the size and dimensions of the image before actually uploading the image
You can give your own file name when the file is uploaded for the first time
You can set the action parameter value to "copy, rename"
Both a and b
Both b and c
Answer
Correct Answer:
Both b and c
Note: This Question is unanswered, help us to find answer for this one
Check Answer
75. Which of the following functions is not available with Coldfusion arrays?
ArrayLen
ArraySort
ArrayDelete
ArrayAppend
Answer
Correct Answer:
ArrayDelete
Note: This Question is unanswered, help us to find answer for this one
Check Answer
76. Which of the following structure assignments is correct?
cfset objStruct.value1 = "value"
cfset objStruct[0].value1 = "value"
cfset objStruct[0] = "value"
All the above
Answer
Correct Answer:
cfset objStruct.value1 = "value"
Note: This Question is unanswered, help us to find answer for this one
Check Answer
77. You have written a cfquery ("HireSalaries") to retrieve two derived columns "Year" and "AverageHike." Which of the following is the right way to plot an area type line graph with this cfquery?
cfchartseries chartWidth=380 show3D="yes" cfchart type="area" query="HireSalaries" valueColumn="AverageHike" itemColumn="Year"/cfchartseries
cfchart chartWidth=380 show3D="yes"cfchartseries type="area" query="HireSalaries" value="AverageHike" item="Year"//cfchart
cfchart chartWidth=380 show3D="yes" cfchartseries type="area" query="HireSalaries"valueColumn="AverageHike" itemColumn="Year"//cfchart
Answer
Correct Answer:
cfchart chartWidth=380 show3D="yes" cfchartseries type="area" query="HireSalaries"valueColumn="AverageHike" itemColumn="Year"//cfchart
Note: This Question is unanswered, help us to find answer for this one
Check Answer
78. Which of the following does not constitute flow control tag in Coldfusion?
cfabort
cfset
cfdefaultcase
cfloop
Note: This Question is unanswered, help us to find answer for this one
Check Answer
79. Which of the following constitute the common characteristics shared by most of the Coldfusion Tags?
They start with cf
They have a closing tag as well
They have attributes and most attributes have values
All of the above
Both a and b
Answer
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
Check Answer
80. Which of the following statements is correct with regard to user defined functions?
Function overloading is allowed in user defined functions
Function definitions can be nested in user defined functions
Function name must be different from the inbuilt function name, however it can be same as some variable
A user defined function can be recursive
Answer
Correct Answer:
A user defined function can be recursive
Note: This Question is unanswered, help us to find answer for this one
Check Answer
81. Which of the following tags do not work in ColdFusion MX 7?
cfgrid
cfform
cfchart
cfgraph
Note: This Question is unanswered, help us to find answer for this one
Check Answer
82. What does the following code do?
It executes two stored procedures called getDepartments and getEmployees
It executes a stored procedure called GetInfo
The code is erroneous because it is returning two resultsets, which is not possible
Answer
Correct Answer:
It executes a stored procedure called GetInfo
Note: This Question is unanswered, help us to find answer for this one
Check Answer
83. A company has the following departments:
The query will return "Designing, Marketing"
The query will return "Designing, Production, Packing"
The query will return "Packing"
Strings cannot be compared using operator
The query will return "Designing"
Answer
Correct Answer:
The query will return "Designing, Production, Packing"
Note: This Question is unanswered, help us to find answer for this one
Check Answer
84. Which of the following statements is correct with regard to Function?
Positional arguments must be used in Function
Named arguments must be used in Function
Either named or positional arguments can be used in Function
Both named and positional arguments can be used in Function
Answer
Correct Answer:
Either named or positional arguments can be used in Function
Note: This Question is unanswered, help us to find answer for this one
Check Answer
85. What will XResult contain:
An array containing the attributes named size that fall directly beneath the root node
An array containing the nodes named size that fall directly beneath the root node
An array containing the attributes named size that fall anywhere beneath the root node
An array containing the nodes named size that fall anywhere beneath the root node
An array containing the elements named size that fall directly beneath the root node
Answer
Correct Answer:
An array containing the attributes named size that fall anywhere beneath the root node
Note: This Question is unanswered, help us to find answer for this one
Check Answer
86. You need to set the value for 'UserName' to ''Guest'' if a user does not fill in the user name in the Coldfusion form. Which of the following ways help you implement this?
cfset Form.UserName=''Guest''
cfparam name=''Form.UserName'' default=''Guest''
cfparam name=''Form.UserName'' optional=''Guest''
cfparam name=''Form.UserName'' value=''Guest''< label="">
Answer
Correct Answer:
cfparam name=''Form.UserName'' default=''Guest''
Note: This Question is unanswered, help us to find answer for this one
Check Answer
87. You have to pass a string named "StrName" and an array named "ArrItems" to a custom tag. Which of the following ways serves the purpose?
cf_CustTag StrName,ArrItems
cf_CustTag stringval=StrName arrayval=ArrItems
cf_CustTag stringval=#StrName# arrayval=#ArrItems#
cf_CustTag #StrName# #ArrItems#
Answer
Correct Answer:
cf_CustTag stringval=#StrName# arrayval=#ArrItems#
Note: This Question is unanswered, help us to find answer for this one
Check Answer
88. Which of the following verity query types is not valid?
Natural
Search
Internet
Simple
Explicit
Note: This Question is unanswered, help us to find answer for this one
Check Answer
89. What will be the output of the given expression:
51
30
237
230
Note: This Question is unanswered, help us to find answer for this one
Check Answer
90. You created a Coldfusion form to get the guest information from your website. The name of the input elements is same as that in the database. The name of the data source is "GuestDSN" and the table name is "TbGuest." Which of the following codes helps you insert data in the table?
cfinsert DSN="GuestDSN" table="TbGuest"
cfinsert datasource="GuestDSN" tablename="TbGuest"
insert datasource="GuestDSN" tablename="TbGuest"
insert DSN="GuestDSN" table="TbGuest"
Answer
Correct Answer:
cfinsert datasource="GuestDSN" tablename="TbGuest"
Note: This Question is unanswered, help us to find answer for this one
Check Answer
91. Which of the below statements are correct regarding the following code:
The results are always the same each time the code is run
The results vary each time the code is run
This code will give an error when run
Answer
Correct Answer:
The results vary each time the code is run
Note: This Question is unanswered, help us to find answer for this one
Check Answer
92. You need to create a website using ColdFusion that spans across several servers. What will be the preferred technique for maintaining session state across the servers considering that some users might have cookies disabled on their browsers?
Use session variables
Use the CFID and CFTOKEN cookies to track sessions
Pass the CFID and CFTOKEN variables to every URL, form action and hyperlink and set the ClientManagement attribute of your CFApplication tag to "yes"
Pass the CFID and CFTOKEN variables to every URL, form action and hyperlink and set the ClientManagement attribute of your CFApplication tag to "no". Set the "ClientStorage" attribute of the CFAPPLICATION tag to your specified datasour
This cannot be accomplished
Answer
Correct Answer:
Pass the CFID and CFTOKEN variables to every URL, form action and hyperlink and set the ClientManagement attribute of your CFApplication tag to "no". Set the "ClientStorage" attribute of the CFAPPLICATION tag to your specified datasour
Note: This Question is unanswered, help us to find answer for this one
Check Answer
93. What is the output of the following code:
3 6 0
360
3 6
3 6 0 0
Note: This Question is unanswered, help us to find answer for this one
Check Answer
94. What is the output of the following code:
-215
215
-325
325
Note: This Question is unanswered, help us to find answer for this one
Check Answer
95. Which of the following allows the use of CFML tags within its body?
UDF
CFScript
UDF and CFScript
None of the above
Note: This Question is unanswered, help us to find answer for this one
Check Answer
96.
What is the output of the following code:
100
120
10
65
Note: This Question is unanswered, help us to find answer for this one
Check Answer
97. Examine the data in the EMPLOYEES table given below:
cfquery name="GetEmpInfo" datasource="myDSN"SELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department_id)/cfquery
cfquery name="GetEmpInfo" datasource="myDSN"SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id) /cfquery
cfquery name="GetEmpInfo" datasource="myDSN"SELECT distinct department_id FROM employees Where salary IN (SELECT AVG(salary) FROM employees GROUP BY department_id)/cfquery
cfquery name="GetEmpInfo" datasource="myDSN"SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY))/cfquery
Answer
Correct Answer:
cfquery name="GetEmpInfo" datasource="myDSN"SELECT distinct department_id FROM employees Where salary IN (SELECT AVG(salary) FROM employees GROUP BY department_id)/cfquery
Note: This Question is unanswered, help us to find answer for this one
Check Answer
98. What does this code do? #DateFormat(date, "dd mmm yyyy")#
Display dates from Jan 1st 2012 to Dec 31st 2012.
Error. You cannot specify such values to loop.
Answer
Correct Answer:
Display dates from Jan 1st 2012 to Dec 31st 2012.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
99. True or False? Arrays are passed by reference like Structs.
TRUE.
FALSE.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
100. I just added a record to a table with an auto-incrementing primary key. If I stored the results of my query in a variable called lastRecord, how would I find the primary key of the record I just added?
lastRecord.IDENTITYCOL
lastRecord.ROWID
lastRecord.generatedKey
lastRecord.RecordCount
lastRecord.GENERATED_KEY
Answer
Correct Answer:
lastRecord.generatedKey
Note: This Question is unanswered, help us to find answer for this one
Check Answer
101. As in JavaScript, in ColdFusion you can write a function inside another function
True
False
Note: This Question is unanswered, help us to find answer for this one
Check Answer
102. True or False? Using <cfloop> to loop over a file opens the entire file in memory.
False
True
Note: This Question is unanswered, help us to find answer for this one
Check Answer
103. What is the correct output for the following? #str2
The-quick-brown-fox-jumped-over-the-lazy-dog
Nothing. The script throws an error.
Thequickbrownfoxjumpedoverthelazydog
The quick brown fox jumped over the lazy dog
Answer
Correct Answer:
Nothing. The script throws an error.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
104. Can ColdFusion create a CAPTCHA?
No, ColdFusion cannot do that.
Yes, with the <cfimage> tag.
Yes, there is a <cfcaptcha> tag.
Answer
Correct Answer:
Yes, with the <cfimage> tag.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
105. From the below array, how do you access the value "banana"?
arrFruits["2"] and arrFruits[2]
arrFruits[2] only
arrFruits["2"] only
arrFruits.2 only
arrFruits[2] and arrFruits.2
Answer
Correct Answer:
arrFruits["2"] and arrFruits[2]
Note: This Question is unanswered, help us to find answer for this one
Check Answer
106. Given a page, customtag.cfm, called with will invoke the code twice whereas called with will invoke the code once.
Yes.
No. As with XHTML, closing the tag is good coding practice.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
107. By default, in which scope does a ColdFusion application store login information?
Session
Request
Cookie
URL
Note: This Question is unanswered, help us to find answer for this one
Check Answer
108. Which of the following are NOT valid CFML to check whether num1 is greater than or equal to num2?
= num2>
Note: This Question is unanswered, help us to find answer for this one
Check Answer
109. What is the outcome of the code? <cfset structInsert(CGI, 'newVar','CF',true)/> <cfoutput>#CGI.newVar#</cfoutput>
Error
NULL
CF
Note: This Question is unanswered, help us to find answer for this one
Check Answer
110. Which of the following IS NOT used to create a XML document object?
XMLNew function
XMLParse function
XMLFormat function
tag
Answer
Correct Answer:
XMLFormat function
Note: This Question is unanswered, help us to find answer for this one
Check Answer
111. Which of the following is NOT a valid Array function?
ArrayNew()
ArrayDelete()
ArrayAppend()
ArrayClear()
Answer
Correct Answer:
ArrayDelete()
Note: This Question is unanswered, help us to find answer for this one
Check Answer
112. Which of the following versions of ColdFusion has passed its core support deadline, but is still within its extended support period?
Adobe ColdFusion 10
Adobe ColdFusion 8
Adobe ColdFusion 9
Macromedia ColdFusion 7
Answer
Correct Answer:
Adobe ColdFusion 8
Note: This Question is unanswered, help us to find answer for this one
Check Answer
113. How many remote IP addresses can access an installation of the free developer edition of Adobe ColdFusion?
2
None. Only localhost access is possible.
Trick question - the developer edition of ColdFusion isn't free.
5
1
Note: This Question is unanswered, help us to find answer for this one
Check Answer
114. True or False? In ColdFusion 8, you can upload multiple files at once by setting CFFILE action to "uploadAll"
True
False
Note: This Question is unanswered, help us to find answer for this one
Check Answer
115. Where is considered the best place to name your application so the request is tied to the right application?
In Application.cfm.
Inside Application.cfc but outside of any methods.
Both
Note: This Question is unanswered, help us to find answer for this one
Check Answer
116. Which of the following prints out "Fail"?
Success Fail
Success Fail
Success Fail
Answer
Correct Answer:
Success Fail
Note: This Question is unanswered, help us to find answer for this one
Check Answer
117. Which of the following is NOT a required Application.cfc setting for using ORM?
this.ormenabled
this.ormsettings
this.name
this.datasource
Answer
Correct Answer:
this.ormsettings
Note: This Question is unanswered, help us to find answer for this one
Check Answer
118. True or False: For un-scoped or unspecified scope variables, Coldfusion takes into consideration the Cookie scope before the Form scope.
False
True
Note: This Question is unanswered, help us to find answer for this one
Check Answer
119. <cfset x = 123> <!-- <cfset x = 321> --> <cfoutput>#x#</cfoutput> What will be output after the above code executes?
321
123
Note: This Question is unanswered, help us to find answer for this one
Check Answer
120. Complete this analogy: In ColdFusion ORM, CFCs are to database tables, as properties are to:
Primary keys
Columns
Indexes
Stored procedures
Note: This Question is unanswered, help us to find answer for this one
Check Answer
121. In a custom tag, which of the following make variable x available on the calling page?
<cfset CALLEE.x = 123>
<cfset CALLER.x = 123>
Without mentioning the page in question is using a custom tag, all the answers are true to some extent.
<cfset THIS.x = 123>
<cfreturn x>
Answer
Correct Answer:
<cfset CALLER.x = 123>
Note: This Question is unanswered, help us to find answer for this one
Check Answer
122. What does the following code result in: Array Struct
An error
Array
Struct
Note: This Question is unanswered, help us to find answer for this one
Check Answer
123. What is the default method for ?
post
enctype
get
Note: This Question is unanswered, help us to find answer for this one
Check Answer
124. True or False: It is a good idea to enable RDS on your ColdFusion production servers.
False
True
Note: This Question is unanswered, help us to find answer for this one
Check Answer
125. What is the correct way of getting the last_name of a user from a tag below? SELECT first_name, last_name, email FROM users
qryUsers["last_name"]
qryUsers.last_name
Both
Note: This Question is unanswered, help us to find answer for this one
Check Answer
126. Hello Goodbye The above code will result in:
'Goodbye' printed.
'Hello' printed.
An error.
Answer
Correct Answer:
An error.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
127. Determine the output below: #item#
efg
nop,qrs
klm
;klm
klm;
Note: This Question is unanswered, help us to find answer for this one
Check Answer
128. Which of the following is correct format of comment within block?
# this is a comment
// this is a comment
/* This is a comment
Answer
Correct Answer:
// this is a comment
Note: This Question is unanswered, help us to find answer for this one
Check Answer
129. ColdFusion syntax supports a do-while loop
False
True
Note: This Question is unanswered, help us to find answer for this one
Check Answer
130. What happens to your session when the CF Server is restarted?
Your session remains the same
You lose the session
Your session can be activated back if you have the CFID and CFToken
Answer
Correct Answer:
You lose the session
Note: This Question is unanswered, help us to find answer for this one
Check Answer
131. What should I do if I've forgotten the CF Administrator password on a ColdFusion 10 server?
Delete the neo-security.xml configuration file, and generate a new one from within the CF Administrator.
Edit the password in your neo-security.xml file.
Use the passwordreset script inside the bin folder to create a new password.
Answer
Correct Answer:
Use the passwordreset script inside the bin folder to create a new password.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
132. True or False? In ColdFusion 10, if you don't specify strict attribute for , you should specify MIME types for the accept attribute.
True
FALSE
Note: This Question is unanswered, help us to find answer for this one
Check Answer
133. Which of the following always returns TRUE?
IsDefined("URL.urlvariable")
IsDefined("FORM.formfield")
IsDefined("CGI.cgivariable")
IsDefined("REQUEST.requestvariable")
Answer
Correct Answer:
IsDefined("CGI.cgivariable")
Note: This Question is unanswered, help us to find answer for this one
Check Answer
134. Exceptions that are handled and catched by a <cfcatch> tag are automatically logged in the Application.log file.
TRUE
FALSE
Note: This Question is unanswered, help us to find answer for this one
Check Answer
135. What does the name attribute of the <cfhttp> tag do?
Nothing. There is no name attribute for the <cfhttp> tag.
It specifies which remote server you want ColdFusion to contact.
It tells ColdFusion the name of the file you want to retrieve from the remote server.
It creates a query object from the returned HTTP response body with the name you provide.
Answer
Correct Answer:
It creates a query object from the returned HTTP response body with the name you provide.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
136. Determine the output below: #name#
Dave
TestApp
John
TestServer
No output. An error will be thrown.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
137. Which ColdFusion tag invokes a custom tag for use in ColdFusion application pages?
cfinterface
cfmodule
cfassociate
cfimport
Note: This Question is unanswered, help us to find answer for this one
Check Answer
138. Can you nest one ColdFusion comment inside of another ColdFusion comment?
No
Yes
Note: This Question is unanswered, help us to find answer for this one
Check Answer
139. True or False: code within a CFThread tag body actually executes as a function call.
True
False
Note: This Question is unanswered, help us to find answer for this one
Check Answer
140. How would you access the first element of an array called attendees?
attendees[0]
attendees[1]
Answer
Correct Answer:
attendees[1]
Note: This Question is unanswered, help us to find answer for this one
Check Answer
141. True or false: It is necessary to add a default parameter in a function whose required type is set to no.
True
False
Note: This Question is unanswered, help us to find answer for this one
Check Answer
142. What ColdFusion tag should one use to help prevent a possible race condition scenario?
Unnecessary, because ColdFusion handles this automatically.
cfapplication
cfthread
cfmodule
cflock
Note: This Question is unanswered, help us to find answer for this one
Check Answer
143. Which of these is a valid CFML tag?
cfwrite
cfsilent
cfenter
cfdraw
cfsave
Note: This Question is unanswered, help us to find answer for this one
Check Answer
144. In a ColdFusion component, an init() method is mandatory
Yes, without it, you cannot create an object for that CFC
No. Its just a convention
Answer
Correct Answer:
No. Its just a convention
Note: This Question is unanswered, help us to find answer for this one
Check Answer
145. <cfform> controls cannot be stylized using CSS like conventional HTML form controls.
True. CFML form controls are different from conventional HTML form controls, and thus require to different styling/formatting mechanisms
False. CFML form controls are rendered by the browser as conventional HTML form controls and can be formatted/stylized the same way.
Answer
Correct Answer:
False. CFML form controls are rendered by the browser as conventional HTML form controls and can be formatted/stylized the same way.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
146. Which of the following ISN'T a method you'd expect to find in Application.cfc?
OnSessionEnd
OnApplicationStart
OnApplicationEnd
OnRequest
OnServerStart
Answer
Correct Answer:
OnServerStart
Note: This Question is unanswered, help us to find answer for this one
Check Answer
147. ColdFusion is compiled to what prior to execution?
HTML
CFML
Java bytecode
Active Server Pages
Answer
Correct Answer:
Java bytecode
Note: This Question is unanswered, help us to find answer for this one
Check Answer
148. #myFunction()# What will be outputted after the above code is executed?
The string 'Default'.
An empty string.
An error because the required attribute in the cfargument tag defaults to true.
Answer
Correct Answer:
The string 'Default'.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
149. Using CFML, how does one check to see if a variable called #myVarName# exists?
<cfif IsDefined(#myVarName#)>...</cfif>
<cfif IsDefined("myVarName")>...</cfif>
<cfif IsDefined(myVarName)>...</cfif>
<cfif myVarName>...</cfif>
Answer
Correct Answer:
<cfif IsDefined("myVarName")>...</cfif>
Note: This Question is unanswered, help us to find answer for this one
Check Answer
150. <cfform> variables are stored in what?
an array called POST
a list called FORM
an array called FORM
a structure called FORM
Answer
Correct Answer:
a structure called FORM
Note: This Question is unanswered, help us to find answer for this one
Check Answer
151. I want to use a CFC function as a web service. I should set the access attribute of that function to:
package
remote
private
public
Note: This Question is unanswered, help us to find answer for this one
Check Answer
152. True or False? The tag is deprecated on UNIX platforms.
False
True
Note: This Question is unanswered, help us to find answer for this one
Check Answer
153. True or False? You cannot use multiple tags inside of a tags.
True
False
Note: This Question is unanswered, help us to find answer for this one
Check Answer
154. In ColdFusion 10, Adobe replaced their JRun application server with:
Mono
Jetty
Tomcat
Zend
Note: This Question is unanswered, help us to find answer for this one
Check Answer
155. Which of the following is not a ColdFusion application framework?
Zend
CFWheels
ColdBox
FuseBox
Framework 1 (FW/1)
Note: This Question is unanswered, help us to find answer for this one
Check Answer
156. True or False? You can run a PL/SQL or TSQL block inside a cfquery.
TRUE.
FALSE.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
157. What is the default delimiter when looping through a list with <cfloop>?
comma (,)
None of these
space ( )
period (.)
Answer
Correct Answer:
comma (,)
Note: This Question is unanswered, help us to find answer for this one
Check Answer
158. Where can I find the Code Compatibility Analyzer?
You have to download and install it from Adobe's ColdFusion page.
It comes with the FuseBox framework.
In the Debugging & Logging section of your ColdFusion Administrator interface.
Answer
Correct Answer:
In the Debugging & Logging section of your ColdFusion Administrator interface.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
159. True or False: You can manage multiple ColdFusion servers from a single view within Adobe ColdFusion Builder?
True
False
Note: This Question is unanswered, help us to find answer for this one
Check Answer
160. Which Client variables are reserved?
All of these
Client.CFToken
Client.CFID
Client.LastVisit
Answer
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
Check Answer
161. Which of these is the correct syntax for a CFML comment?
<!--- my comment --->
* my comment *
<cfcomment>my comment</cfcomment>
<!-- my comment -->
/ my comment /
Answer
Correct Answer:
<!--- my comment --->
Note: This Question is unanswered, help us to find answer for this one
Check Answer
162. The following code does what? #DateFormat(Now(), "m/d/yyyy")#
Prints the current date in MM/DD/YYYY format
Prints the current date in MM/DD/YY format
Prints the current date in M/D/YYYY format
Converts the current date to a numeric value
Answer
Correct Answer:
Prints the current date in M/D/YYYY format
Note: This Question is unanswered, help us to find answer for this one
Check Answer
163. True or False: Unlike many programming languages, the first index in an array in Coldfusion is 1, instead of 0.
True
False
Note: This Question is unanswered, help us to find answer for this one
Check Answer
164. The CGI scope is read only
True
False
Note: This Question is unanswered, help us to find answer for this one
Check Answer
165. What is the Code Compatibility Analyzer?
a tool that analyzes and optimizes your SQL queries
a tool that helps you debug JSON-related issues.
a tool that reviews older cfm pages for deprecated and unsupported cfml tags.
Answer
Correct Answer:
a tool that reviews older cfm pages for deprecated and unsupported cfml tags.
Note: This Question is unanswered, help us to find answer for this one
Check Answer
166. Which of these is NOT a valid CFML tag?
cfloop
cfquery
cfscript
cfchoice
cfsilent
Note: This Question is unanswered, help us to find answer for this one
Check Answer
167. What is the correct output in the following code: #ListGetAt(sweek, 3)#
Thursday
3
n
Wednesday
Answer
Correct Answer:
Wednesday
Note: This Question is unanswered, help us to find answer for this one
Check Answer
168. Which is a required method in Application.cfc?
OnApplicationStart
OnBeginRequest
OnRequestEnd
OnError
Answer
Correct Answer:
OnApplicationStart
Note: This Question is unanswered, help us to find answer for this one
Check Answer
169. Which is a required attribute of ?
to
subject
from
All of these
Answer
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
Check Answer
170. I want to invoke a CFC method from within a <cfscript> tag. Which function must I use to do this?
ObjectLoad
ToScript
CreateObject
Answer
Correct Answer:
CreateObject
Note: This Question is unanswered, help us to find answer for this one
Check Answer
171. Arrays in ColdFusion start at which index?
1
0
None of these.
-1
Note: This Question is unanswered, help us to find answer for this one
Check Answer
172. If I suspect my ColdFusion is encountering errors while sending email via SMTP, where should I look for clues?
ask the administrator of the email server for help
in the error.log file inside the ColdFusion log directory
in the output of a <cfcatch type="email"> tag
in the mail.log file inside the ColdFusion log directory
Answer
Correct Answer:
in the mail.log file inside the ColdFusion log directory
Note: This Question is unanswered, help us to find answer for this one
Check Answer
173. In the Directory Watcher event gateway's configuration file, which of the following property is required?
interval
recurse
directory
extensions
Answer
Correct Answer:
directory
Note: This Question is unanswered, help us to find answer for this one
Check Answer
174. I need to make multiple, related changes to a database, but all those changes must be made w/o errors before I actually commit them. Which tag should I use?
cfupdate
cfrollback
cftransaction
cftry and cfcatch
Answer
Correct Answer:
cftransaction
Note: This Question is unanswered, help us to find answer for this one
Check Answer
Adobe ColdFusion MCQs | Topic-wise