Upwork/oDesk ColdFusion MX 7
·
1. Which of the given options is
correct for the following code?
<cfupdate
datasource="MIS" tablename="user">
Answers:
• cfupdate is a
tag and datasource is a tag value
• cfupdate is an
attribute and user is attribute value
• tablename is a
tag and user is the tag value
• datasource is
the attribute name and MIS is the attribute value
2. What is the default value for the encoding
parameter of the hash function?
Answers:
• UTF-8
• It is specified
by the defaultCharset entry in the neo-runtime.xml file
• It varies
depending upon the locale settings of your computer
• ASCII
• EBCDIC
• UCS-2
• UTF-16
3. What does the Randomize function return?
Answers:
• 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
4. What is the output of the following code:
<cffunction name="thefunc"
returntype="numeric">
<cfargument name="x"
required="yes" type="numeric" default=2>
<cfreturn x*x>
</cffunction>
<cfoutput>
#thefunc()#
</cfoutput>
Answers:
• 2
• 3
• 4
• 5
5. Which ColdFusion tag is used to import a
Java Server Page (JSP) tag library?
Answers:
• cfjimport
• cfimport
• cfinclude
• cfinsert
• cfsetting
6. When would you prefer to use the
encrypt/decrypt functions instead of the hash function?
Answers:
• When you want
to encrypt blocks of text larger than 1 kb
• Hash is a
superior function, it is always preferred over encrypt/decrypt
• When you want
the ability to decrypt the encrypted string
• When you want
to use Blowfish algorithm for encryption
• When you want to
use MD5 algorithm for encryption
7. Which of the following is a correct way of
commenting in Coldfusion?
Answers:
• //
• <!-- -->
• /* */
• <!---
--->
8. What will XResult contain:
<cfset XResult = xmlSearch(XMLObject,
"//@size")>
Answers:
• 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
9. The <cfhttp> tag can have multiple
<cfhttpparam> tags, subject to certain limitations. Which are these
limitations?
Answers:
• 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
10. What does the cfNTauthenticate tag do?
Answers:
• 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
11. The emp_data table has following values
for its department field:
marketing, production, production, sales,
NULL, NULL, Marketing, Null
What will the following query return:
<cfquery name="GetDeptData"
datasource="myDSN">
select distinct(department) as department_name
from emp_data
</cfquery>
Answers:
• marketing, production,
sales
• marketing,
production, sales, NULL
• marketing,
production, sales, NULL, NULL
• marketing,
production, sales, NULL, Marketing
• marketing,
production, sales, NULL, NULL, Marketing
• Impossible to
say, because it depends upon the underlying database
12. Which of the following tags is not useful
in handling exceptions?
Answers:
• cftry
• cfcatch
• cfrethrow
• cfabort
• cferror
13. which ColdFusion tag is used to define the
application scope like, enabling sessions, setting timeouts and specifying
client variable storage?
Answers:
• cfsession
• cfcookie
• cfapplication
• cfindex
14. Which of the statements with respect to
the following code is correct?
<cffunction name="daysmonths"
returntype="date">
<cfreturn
dateadd("d",1,Now())>
</cffunction>
<cfoutput>
#daysmonths()#
</cfoutput>
Answers:
• daysmonths() is
a user defined function
• date() is a
user defined function
• The output will
display tomorrows date
• The output will
display today's date
• The cffunction
tags are optional in this code
15. Which operator will be evaluated first in
the following statement:
<cfquery name="GetEmpData"
datasource="myDSN">
select (age + 3 * 4 / 2 - 8) from emp
</cfquery>
Answers:
• +
• -
• /
• *
16. When would you prefer to use the
<cfstoredproc> tag in place of the <cfquery> tag?
Answers:
• 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>
17. Which of the following techniques allow
the Coldfusion code to be used at many places with in an application?
Answers:
• cfinclude tag
• User Defined
functions
• CFML tags and
CFX
• Both a and c
• a, b, and c
18. The following structure stores the address
of one of the employees:
<cfset AddrStr= StructNew()>
<cfset
AddrStr.Address1="23/16">
<cfset AddrStr.Address2="Lismore Street">
<cfset AddrStr.City="Manly">
<cfset AddrStr.Pincode="2065">
And the other Structure stores
"AddStr" as its one of the keys:
<cfset EmpStr = StructNew()>
<cfset EmpStr.Key=AddrStr>
What would you put inside
<cfoutput></cfoutput> tags to print the value of "City"
on the page?
Answers:
•
#EmpStr.key.City#
•
#EmpStr["key"].City#
•
#EmpStr.key["City"]#
•
#EmpStr["key"]["City"]#
• Any of the
above
• Both a and c
• EmpStr.key.City
19. What happens when the following code is
included in a cfm file:
<cflog file="myAppLog"
text="User Kim logged on.">
Answers:
• "User Kim
logged on" will be displayed in the browser
• A new log file
by the name of Kim will be created
• "User Kim
logged on" will replace the last record in the ColdFusion log file
• "User Kim
logged on" will be appended to the ColdFusion log file
20. Query of Queries cannot be performed on
cfassociate.
Answers:
• True
• False
21. What does the cfproperty tag do?
Answers:
• 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
22. What will XResult contain:
<cfset XResult = xmlSearch(XMLObject,
"//info")>
Answers:
• An array
containing the info nodes that fall directly beneath the root node
• An array
containing the info nodes that fall anywhere beneath the root node
• All info nodes
will be returned along with their child and sub-child nodes
• This XPath
expression is erroneous
• An array
containing the attributes of all the info nodes that fall anywhere beneath the
root node
23. There are 5 info nodes in an XML document.
How will you obtain the value of the 3rd info node?
Answers:
• <cfset
XResult = xmlSearch(XMLObject, "/info[2]")>
• <cfset
XResult = xmlSearch(XMLObject, "/info[3]")>
• <cfset
XResult = xmlSearch(XMLObject, "/info[4]")>
• <cfset
XResult = xmlSearch(XMLObject, "/info(1)")>
• <cfset
XResult = xmlSearch(XMLObject, "/info[first()+2]")>
• <cfset
XResult = xmlSearch(XMLObject, "/info[last()-2]")>
24. Which of the following verity query types
is not valid?
Answers:
• Natural
• Search
• Internet
• Simple
• Explicit
25. Which of the following tags was introduced
in the ColdFusion MX series?
Answers:
• cfcalendar
• cfapplet
• cfbreak
• cfdirectory
26. What is correct syntax for accessing an
item of a structure?
Answers:
•
StructFind(item, struct)
•
StructFind(struct, item)
•
FindStruct(struct, item)
•
FindStruct(item, struct)
27. Consider the following <cfquery>
tag:
<cfquery name="GetTableData"
datasource="myDSN">
SELECT * FROM myTable
</cfquery>
Which condition should the WHERE clause
contain so that only those rows are returned that contain null in column
column1?
Answers:
• WHERE column1
is null
• WHERE column1 =
null
• WHERE column1
EQUALS null
• WHERE column1
NOT null
• WHERE column1
CONTAINS null
28. Which of the following makes CFMX7 better
than the previous MX version?
Answers:
• It has added
support for dot notation within a recordset name
• It has added result
attribute
• Deprecated
connectString, dbName, dbServer, provider, and providerDSN attributes
• It has added
cfquery.ExecutionTime
29. Evaluate the following SQL statement:
<cfquery name="GetEmpData"
datasource="myDSN">
SELECT e.employee_id, (.15* e.salary) + (.5 *
e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM
employees e, sales s WHERE e.employee_id = s.emp_id;
</cfquery>
What will happen if all the parentheses are
removed from the calculation in the SQL query?
Answers:
• The value
displayed in the CALC_VALUE column will be lower
• The value
displayed in the CALC_VALUE column will be higher
• There will be
no difference in the value displayed in the CALC_VALUE column
• An error will
be reported
30. Which of the following statements is
correct with regard to Coldfusion Comments?
Answers:
• Nesting of
coldfusion comments is not allowed
• The comments
can be embedded in a function or tag name
• The comments
are allowed in the body of the document only
• The comments
are cleared by coldfusion engine before presenting output to the browser
31. Which of the following can be used to
convert real number into integers?
Answers:
• Ceiling
• Int
• Round
• Fix
• All of the
above
• a, c, and d
32. A code has to be generated by using 'PageCode'
and 'ProductCode,' whose numeric values are derived from a database:
<cfset ArPage=ArrayNew(1)>
<cfset ProductCode = #PCode#>
<cfset ClassCode = #CCode#>
You have to assign value "superherb"
to ArPage where index is concatenation of ProductCode and ClassCode. Which of
the following ways would you use?
Answers:
• <cfset
ArPage[#ProductCode##ClassCode#] = "Superherb">
• <cfset
ArPage[#ProductCode# #ClassCode#] = "Superherb">
• <cfset
#ArPage[ProductCode & ClassCode]# = "Superherb">
• <cfset ArPage[#ProductCode#
& #ClassCode#] = "Superherb">
33. Which of the following constitute the core
components of ColdFusion MX?
Answers:
• ColdFusion
application server
• ColdFusion
Markup Language
• ColdFusion MX
Administrator
• All of the
above
34. Which of the following is not a valid
array function?
Answers:
• ArrayAppend
• ArrayInsertAt
• ArraySize
• ArrayPrepend
• None of the
above
35. 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?
Answers:
• <cfset
Form.UserName=''Guest''>
• <cfparam
name=''Form.UserName'' default=''Guest''>
• <cfparam
name=''Form.UserName'' optional=''Guest''>
• <cfparam
name=''Form.UserName'' value=''Guest''>
36. What will be the result of placing the
following code in any cfm file:
<!---
<cflock timeout=20
scope="Session" type="Exclusive">
<cfset StructDelete(Session,
"ShoppingCartItems")>
</cflock>
--->
Answers:
• 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
37. Which of the following allows the use of
CFML tags within its body?
Answers:
• UDF
• CFScript
• UDF and
CFScript
• None of the
above
38. Which of the following structure
assignments is correct?
Answers:
• <cfset
objStruct.value1 = "value">
• <cfset
objStruct[0].value1 = "value">
• <cfset
objStruct[0] = "value">
• All the above
39. Which of the following statements is
correct with regard to Coldfusion functions?
Answers:
• 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
40. Which encryption engine is used by the
ColdFusion MX encrypt and hash functions?
Answers:
• PGP 8.0
• Java
Cryptography Extension (JCE)
• CryptoText
Encryption Library
• Microsoft High
Encryption Pack
41. Which of the following is an invalid
variable scope?
Answers:
• Super
• This
• Caller
• Server
42. What is the result of the following code:
<cfset mystring = "'Newton's Law',
'Fermat's Theorem'">
<cfoutput>
#PreserveSingleQuotes(mystring)#
</cfoutput>
Answers:
• 'Newton's Law',
'Fermat's Theorem'
• Newton's Law,
Fermat's Theorem
• "Newton's
Law", "Fermat's Theorem"
• 'Newtons Law',
'Fermats Theorem'
43. What will XResult contain:
<cfset XResult = xmlFind(XMLObject,
"//info@size='3'")>
Answers:
• All the info
elements that have an attribute called size with a value of 3
• The size
attribute of the third info node
• The info
attribute of the third size node
• The statement
contains an error
44. Which of the following statements are true
when you upload an image file using the <cffile> tag?
Answers:
• 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
45. You want create PDF files of your XHTML
documents using ColdFusion MX. How can you do this?
Answers:
• It cannot be
done
• You will have
to write your own highly complex code for doing this
• You can use
XSLT and XSL-FO to render the XHTML as a PDF
• There is a
function available in ColdFusion for creating PDFs
46. If the following code is inserted into
your website, when will the cookies expire?
<CFCOOKIE NAME="CFID"
VALUE="#Session.CFID#">
<CFCOOKIE NAME="CFTOKEN"
VALUE="#Session.CFTOKEN#">
Answers:
• when the
session ends
• When the
application ends
• This code has
no effect on the expiration of the cookies
47. Which of the following ColdFusion tags is
used to get the elements, variables and values of ColdFusion objects?
Answers:
• cfcollect
• cfcomponent
• cfdump
• cfdocument
48. Which of the below statements are correct
regarding the following code:
<cfset a = GetTickCount()>
<cfloop from="1"
to="10000" index="i">
</cfloop>
<cfset b = GetTickCount()>
<cfscript>
c = GetTickCount();
for (i = 1; i LTE 10000; i = i+1) ;
d = GetTickCount();
</cfscript>
<cfoutput>#b-a# vs.
#d-c#</cfoutput>
Answers:
• 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
49. Which of the following statement is
correct?
Answers:
• The coldfusion
script is contrary to Java script
• The coldfusion
script runs on client system
• The coldfusion
script is used for creating user defined functions
• The coldfusion
script provides access to some of the in-built coldfusion functions
50. You want to display the titles of books
that meet the following criteria:
1. Purchased before November 11, 2002
2. Price is less than $500 or greater than
$900
You want to sort the result by the date of
purchase, starting with the most recently bought book.
Which of the following queries will you use in
the <cfquery> tag?
Answers:
• SELECT
book_title FROM books WHERE price between 500 and 900 AND purchase_date <
'11/11/2002' ORDER BY purchase_date;
• SELECT
book_title FROM books WHERE price IN (500, 900) AND purchase_date <
'11/11/2002' ORDER BY purchase date ASC;
• SELECT
book_title FROM books WHERE price < 500 OR>900 AND purchase_date DESC;
• SELECT
Book_title FROM books WHERE price < 500 OR price > 900 AND purchase_date
< '11/11/2002' ORDER BY purchase date DESC;
51. A company has the following departments:
Marketing, Designing, Production, Packing
What will the following query return?
<cfquery name="GetDeptData"
datasource="myDSN">
select * from departments where department
< 'Marketing'
</cfquery>
Answers:
• 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"
52. What is the output of the following code:
<CFPARAM DEFAULT="ProjectManager"
NAME="Status">
<CFPARAM DEFAULT="Six Sigma"
NAME="ProjectType">
<CFIF
IsDefined("FORM.Status")>
Welcome <CFOUTPUT>#FORM.Status#</CFOUTPUT>
<CFELSEIF IsDefined("Status")>
You are not a
<CFOUTPUT>#Status#</CFOUTPUT>
<CFELSE>
Welcome
</CFIF>
Answers:
• Welcome
ProjectManager
• You are not a
ProjectManager
• Welcome
• Six Sigma
ProjectManager
• You are not a
Six Sigma
• None of the
above
53. Which of the following constitute the
common characteristics shared by most of the Coldfusion Tags?
Answers:
• 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
54. Which of the following characters need
escaping?
Answers:
• #
• "
• '
• @
• All of the
above
• a, b, and c
55. What is the output of the following code:
<cfscript>
function autoLeadIn(string,count) {
output = '';
if(Trim(string) NEQ '') {
textarray = ListToArray(string, "
");
if(ArrayLen(textarray) LTE count) {
count = ArrayLen(textarray);
}
for(i=1; i LTE count; i=i+1)
{
output = output & textarray[i];
if(i neq count) {
output = output & " ";
}
}
}
return output;
}
</cfscript>
<cfoutput>#autoleadin("qwerty
asdfg, poiuy, zxcvb",3)#</cfoutput>
Answers:
• qwerty asdfg,
poiuy,
• qwerty asdfg,
poiuy
• qwerty asdfg
• qwerty asdfg,
poiuy, zxcvb
56. 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?
Answers:
• <cftag
class=CalcClass IntValue=20>
• <cfx
name=CalcClass IntValue=20>
•
<cfx_CalcClass IntValue=20>
• <cfx
tag=CalcClass IntValue=20>
57. 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?
Answers:
• <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>
58. What is the output of the following code:
<cfscript>
function calculateresult()
{
var a=55;
var b=5;
b=b-a*b+a;
return b;
}
</cfscript>
<cfoutput>#calculateresult()#</cfoutput>
Answers:
• -215
• 215
• -325
• 325
59. What is the output of the following code:
<cfoutput>reverse(6*2) equals
#reverse(6*2)#</cfoutput>
Answers:
• reverse(6*2)
equals 12
• reverse(2*6)
equals 21
• reverse(6*2)
equals 21
• reverse(2*6)
equals 12
60. Which of the following tags do not work in
the ColdFusion MX series?
Answers:
• cfauthenticate
• cfapplication
• cfloginuser
• cfmodule
61. What is the output of the following code:
<cfscript>
function calculateresult()
{
var a=55;
var b=5;
b=a+b;
b=b+b;
return b;
}
</cfscript>
<cfoutput>#calculateresult()#</cfoutput>
Answers:
• 100
• 120
• 10
• 65
62. What is the output of the following code:
<cfoutput>
<cfset stringToSearch =
"The quick brown fox jumped over the lazy dog.">
#find("the",stringToSearch)#
#find("the",stringToSearch,35)#
#find("no such
substring",stringToSearch)#
</cfoutput>
Answers:
• 3300
• 0 0 33
• 0 33 0
• 33 0 0
63. 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?
Answers:
• 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
datasource
• This cannot be
accomplished
64. What is the output of the following code:
<cfoutput>#IncrementValue(123.35)#</cfoutput>
Answers:
• 123
• 124
• 123.5
• 122
• 100
65. What is the output of the following code:
<cfset myArray = ArrayNew(1)>
<cfset myArray[1] = "Test
Value">
<cfset temp =
ArrayAppend(myArray, "Akash")>
<cfset temp =
ArrayAppend(myArray, "Peterson")>
<cfset temp
= ArrayAppend(myArray, "Dave Heartsdale")>
<cfset temp = ArrayAppend(myArray, "Aaron Smith")>
<cfoutput>
<p>This
array has #ArrayLen(MyArray)# elements.
</cfoutput>
Answers:
• This array has
1 elements
• This array has
5 elements
• Test Value,
Akash, Peterson, Dave Heartsdale, Aaron Smith
• This array has
Test Value, Akash, Peterson, Dave Heartsdale, Aaron Smith
66. Examine the data in the EMPLOYEES table
given below:
LAST_NAME
DEPTARTMENT_ID
SALARY
ALLEN
10
3000
MILLER
20
1500
King
20
2200
Davis
30
5000
Which of the following queries will execute
without error?
Answers:
• <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>
67. A coldfusion list is defined as follows:
<cfset list1="24,25,26,27,">
<cfset list2="24,,25,26,27">
<cfset
list3="24,,,,25,26,27,">
<cfset
list4="24,25,,26,,27,,">
What will you get on printing
"listlen" for all the above lists?
Answers:
• 4, 5, 7, 7
• 4, 4, 7, 7
• 4, 4, 4, 4
• 4, 5, 6, 6
68. 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?
Answers:
•
<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>
69. Which of the following statements with
respect to the below code is correct?
<cfset RandomItem = RandRange(1,
greatoffers.recordcount)>
<CFOUTPUT QUERY="greatoffers"
MAXROWS=1 STARTROW=#RandomItem#>
<B>#ProductTitle#</B> - #DollarFormat(greatoffers.Special_Price)#<BR>
</CFOUTPUT>
Answers:
• 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
70. Which of the following statements is
incorrect with regard to Coldfusion Tags?
Answers:
• 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
71. Which of the following is not an in-built
complex data type in Coldfusion?
Answers:
• query
• array
• hashtable
• structure
72. Which function has been used to generated
the following output?
pro%20discount
Answers:
• URLEncode
• HtmlEditFormat
• UrlDecode
•
URLEncodedFormat
73. What is the output of the following code:
<cfset yourDate = CreateDate(2002, 11,
23)>
<cfoutput>
This is day #Day(YourDate)# in the month of
#MonthAsString(Month(yourDate))#, which has
#DaysInMonth(yourDate)#
days.
</cfoutput>
Answers:
• 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
74. An admin(role-type) function(ChkBalance)
has to be created for printing the account balance of all the users. Which of
the following ways helps one do this?
Answers:
• <cffunction
name="ChkBalance" returnType="numeric"
roles="admin" access="remote" output="yes">
• <function
name="ChkBalance" return="numeric" roles="admin"
access="local" output="no">
• <cffunction
name="ChkBalance" return="String" role="admin"
accessMode="remote" return=yes">
• <cffunction
id="ChkBalance" returnType="numeric" role="admin"
accessMode="local" return="no">
75. Which of the following is an incorrect
floop syntax:
Answers:
• <cfloop
index . . .
• <cfloop
counter . . .
• <cfloop
condition. . .
• <cfloop
query . . . <cfloop list . . .
76. What will the following code do when
included in a ColdFusion application?
<cfloop collection="#session#"
item="j">
<cfoutput>#j# has value of :
#session[j]#<br></cfoutput>
</cfloop>
Answers:
• It will list
out all the application variables
• It will list
out all the cookies
• It will list
out all the session variables
• It will list
out the Html header
77. What is the output of the following code:
<cfoutput>#REReplace("I love
jelly","jell(y|ies)","cookies")#</cfoutput>
Answers:
• I love jelly
• I love jellies
• I Love jelly, cookies
• I love cookies
78. What is the output of the following code:
<cfset stringToSearch = "The quick
brown fox jumped over the lazy dog.">
<cfoutput>
#findoneof("aeiou",stringToSearch)#
#findoneof("aeiou",stringToSearch,4)#
#findoneof("@%^*()",stringToSearch)#
</cfoutput>
Answers:
• 3 6 0
• 360
• 3 6
• 3 6 0 0
79. What will the xInfo variable contain:
<cfset xInfo =
objXML.xmlRoot.xmlChildren[6]["info"].xmltext>
Answers:
• 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
80. Which of the following is not passed as
reference to the object?
Answers:
• structure
• array
• cfobject
• query
81. Which of the following statements is
correct with regard to Function?
Answers:
• 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
82. Which of the following has the highest
operator precedence?
Answers:
• MOD
• *
• NOT
• +
83. Which of the following ColdFusion tags
aborts the processing of the current ColdFusion page?
Answers:
• cfabort
• cfabandon
• cfkill
• cfswitch
84. What is the output of the following code:
<cfoutput>
#dateformat(CreateDate(2001,08,10),"dd,mmm,yyyy")#
</cfoutput>
Answers:
• 8,OCT,2001
• 10,08,2001
• Aug,10,2001
• 10,Aug,2001
85. How will you test whether a cookie has
already been set on the clients browser?
Answers:
• <CFIF
IsDefined(COOKIE("VistorId"))>
• <CFIF
IsDefined("CFCOOKIE.VistorId")>
• <CFIF
IsDefined("COOKIE.VistorId")>
• None of the
above
86. Examine the code given below:
<cfquery name="GetEmpData"
datasource="myDSN">
SELECT employee_id FROM employees WHERE
commission_pct=.5 OR salary > 23000
</cfquery>
Which of the following statements is correct
with regard to this code?
Answers:
• It returns
employees whose salary is 50% more than $23,000
• It returns
employees who have 50% commission rate or salary greater than $23,000
• It returns
employees whose salary is 50% less than $23,000
• None of the
above
87. What will be the output of the given
expression:
evaluate("23" & 2 + 5)
Answers:
• 51
• 30
• 237
• 230
88. 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?
Answers:
•
IsValid("email", Form.EmailAd)
•
IsEmail(Form.EmailAd)
•
IsEmail(#Form.EmailAd#)
•
IsValidType("email", Form.EmailAd)
89. You wrote the following code to set the
prices of the items in an array:
<cfset numArray = ArrayNew(1)>
<cfset ArraySet(numArray, 1, 8 ,25)>
<cfset numArray[3] = "225">
<cfset PriceFound = False>
<cfset ElementNo = 0>
Storing the special price 225, you wrote the
following code to find the array number:
<cfloop condition = "(NOT PriceFound)
AND (ElementNo LT ArrayLen(numArray))">
<cfset ElementNo = ElementNo + 1>
<cfif
numArray[ElementNo] IS "225">
<cfoutput> PriceFound at ElementNo #ElementNo#<br></cfoutput>
<cfset PriceFound = true>
</cfif>
<cfoutput> Searching element . . . #ElementNo#<br></cfoutput>
</cfloop>
What will be the output?
Answers:
• Three lines for
'Searching element . . . ' and one line indicating the 'PriceFound at ElementNo
3'
• Two lines for
'Searching element . . . ' and one line indicating the 'PriceFound at ElementNo
2'
• Eight lines for
'Searching element . . . ' and one line indicating the 'PriceFound at ElementNo
3'
• A syntax error
90. Which of the following constitute the four
categories of the Coldfusion data types?
Answers:
• application,
binary, variant, and local
• simple,
complex, aggregate, and binary
• primary,
secondary, complex, and object
• simple,
complex, binary, and object
91. 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?
Answers:
• <cf_CustTag
StrName,ArrItems>
• <cf_CustTag
stringval=StrName arrayval=ArrItems>
• <cf_CustTag
stringval=#StrName# arrayval=#ArrItems#>
• <cf_CustTag
#StrName# #ArrItems#>
92. Which encryption algorithms are supported
by the encrypt/decrypt functions?
Answers:
• MD5
• SHA
• DES
• AES
• Blowfish
93. Which of the following functions are
specially used with regular expressions?
Answers:
• REFind
• REFindNoCase
• REReplace
• REReplaceNoCase
• All of the
above
94. Which encryption algorithms does the hash
function support?
Answers:
• CFMX_COMPAT
• MD5
• SHA
• SHA-256
• SHA-384
• SHA-512
• CBC
• Blowfish
95. Which of the following does not constitute
flow control tag in Coldfusion?
Answers:
• cfabort
• cfset
• cfdefaultcase
• cfloop
96. You have retrieved the list of all the
customers and the products bought for the day, using a cfquery. The structure
"CNameStr" stores the value of a customer's first, middle, and the
last name in the keys "First", "Middle", and
"Last." While printing the report, you want to create the following
label, only if the middle name exists:
<cfoutput>Middle Name:
#CNameStr.Middle#</cfoutput><br>
Which of the following code blocks serves this
purpose with <cfif></cfif> tags?
Answers:
• <cfif
StructKeyExists(CNameStr,Middle)>
• <cfif
StructKeyExists(CNameStr,"Middle")>
• <cfif
StructKeyExists("CNameStr","Middle")>
• <cfif
KeyExists("CNameStr",Middle)>
• <cfif
KeyExists(CNameStr,Middle)>
97. Which of the following is useful in
Dynamic Evaluation?
Answers:
• DEval
• Dynamic
• Evaluate
• Eval
98. With respect to the following code, which
option is correct?
<cfoutput>
#GetHttpTimeString(now())#
</cfoutput>
Answers:
• It will get the
current GMT time
• It will get the
current time of the users computer
• It converts the
current time into a string and stores it in a variable
• It will get the
current web server time
99. What is the output of the following code:
<cfsilent>
<cfset a = 100>
<cfset b = 99>
<cfset c = b-a>
<cfoutput>Inside cfsilent
block<br>
b-a = #c#</cfoutput><br>
</cfsilent>
<cfoutput>
b-a = #c#
</cfoutput>
Answers:
• -1=-1
• b-a=c
• b-a = -1
• Nothing will be
displayed
100. How do you decrypt text that has been
encrypted using the hash function?
Answers:
• By using the
unhash function
• By hashing the
encrypted text again
• It cannot be
done
• By using the
decrypt function
101. What is the output of the following code:
<cfset strabc=setVariable("abc","abc123")>
<cfset
strxyz=setVariable("xyz","xyz321")>
<cfoutput>
strabc = #strabc# , strxyz =
#strxyz#
</cfoutput>
Answers:
• 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
102. Which ColdFusion tag is used to stop the
processing on the current page and opens a new ColdFusion or html file?
Answers:
• cfredirection
• cfrelocate
• cflocation
• cfnewpage
103. Which of the following statement(s) are
correct?
Answers:
• <cfdirectory
directory="//12.12.54.65/c/" name="dirQuery"
action="LIST">
• <cfdirectory
directory="c:\inetpub\wwwroot" name="dirQuery"
action="LIST">
• <cfdirectory
directory="http://12.12.54.65/c/" name="dirQuery"
action="LIST">
• Both a and b
• Both b and c
104. Which of the following statements about
User defined functions (UDFs) are correct.
Answers:
•
<cfscript> code can call functions but not tags
• User defined
functions written in <cfscript> can call CFML tags
•
<cffunction> is one of the tags in ColdFusion MX used for creating UDFs
•
<cfreturn> is one of the tags in ColdFusion MX used for creating UDFs
105. Which of the following functions is not
available with Coldfusion arrays?
Answers:
• ArrayLen
• ArraySort
• ArrayDelete
• ArrayAppend
106. Which of the following constitutes CFML?
Answers:
• Functions and
expressions
• Variables and
constants
• Flow control
structures
• All of the
above
• both a and b
107. Which of the following statements is
correct with regard to user defined functions?
Answers:
• 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
108. Which of the following attributes of the
cfquery tag was introduced in ColdFusion MX 7?
Answers:
• username
• debug
• result
• timeout
109. 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?
Answers:
• <cfinsert
DSN="GuestDSN" table="TbGuest">
• <cfinsert
datasource="GuestDSN" tablename="TbGuest">
• <insert
datasource="GuestDSN" tablename="TbGuest">
• <insert
DSN="GuestDSN" table="TbGuest">
110. Which of the following statements
regarding placing meta tags at the location *********** in the following code
are correct?
<cfset
browsers="MSIE,Mozilla">
<cfif 1. Which of the given options is
correct for the following code?
<cfupdate datasource="MIS"
tablename="user">
Answers:
• cfupdate is a
tag and datasource is a tag value
• cfupdate is an
attribute and user is attribute value
• tablename is a
tag and user is the tag value
• datasource is
the attribute name and MIS is the attribute value
2. What is the default value for the encoding
parameter of the hash function?
Answers:
• UTF-8
• It is specified
by the defaultCharset entry in the neo-runtime.xml file
• It varies
depending upon the locale settings of your computer
• ASCII
• EBCDIC
• UCS-2
• UTF-16
3. What does the Randomize function return?
Answers:
• 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
4. What is the output of the following code:
<cffunction name="thefunc"
returntype="numeric">
<cfargument name="x"
required="yes" type="numeric" default=2>
<cfreturn x*x>
</cffunction>
<cfoutput>
#thefunc()#
</cfoutput>
Answers:
• 2
• 3
• 4
• 5
5. Which ColdFusion tag is used to import a
Java Server Page (JSP) tag library?
Answers:
• cfjimport
• cfimport
• cfinclude
• cfinsert
• cfsetting
6. When would you prefer to use the
encrypt/decrypt functions instead of the hash function?
Answers:
• When you want
to encrypt blocks of text larger than 1 kb
• Hash is a
superior function, it is always preferred over encrypt/decrypt
• When you want
the ability to decrypt the encrypted string
• When you want
to use Blowfish algorithm for encryption
• When you want
to use MD5 algorithm for encryption
7. Which of the following is a correct way of
commenting in Coldfusion?
Answers:
• //
• <!-- -->
• /* */
• <!---
--->
8. What will XResult contain:
<cfset XResult = xmlSearch(XMLObject,
"//@size")>
Answers:
• 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
9. The <cfhttp> tag can have multiple
<cfhttpparam> tags, subject to certain limitations. Which are these
limitations?
Answers:
• 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
10. What does the cfNTauthenticate tag do?
Answers:
• 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
11. The emp_data table has following values
for its department field:
marketing, production, production, sales,
NULL, NULL, Marketing, Null
What will the following query return:
<cfquery name="GetDeptData"
datasource="myDSN">
select distinct(department) as department_name
from emp_data
</cfquery>
Answers:
• marketing, production,
sales
• marketing,
production, sales, NULL
• marketing,
production, sales, NULL, NULL
• marketing,
production, sales, NULL, Marketing
• marketing,
production, sales, NULL, NULL, Marketing
• Impossible to
say, because it depends upon the underlying database
12. Which of the following tags is not useful
in handling exceptions?
Answers:
• cftry
• cfcatch
• cfrethrow
• cfabort
• cferror
13. which ColdFusion tag is used to define the
application scope like, enabling sessions, setting timeouts and specifying
client variable storage?
Answers:
• cfsession
• cfcookie
• cfapplication
• cfindex
14. Which of the statements with respect to
the following code is correct?
<cffunction name="daysmonths"
returntype="date">
<cfreturn
dateadd("d",1,Now())>
</cffunction>
<cfoutput>
#daysmonths()#
</cfoutput>
Answers:
• daysmonths() is
a user defined function
• date() is a
user defined function
• The output will
display tomorrows date
• The output will
display today's date
• The cffunction
tags are optional in this code
15. Which operator will be evaluated first in
the following statement:
<cfquery name="GetEmpData"
datasource="myDSN">
select (age + 3 * 4 / 2 - 8) from emp
</cfquery>
Answers:
• +
• -
• /
• *
16. When would you prefer to use the
<cfstoredproc> tag in place of the <cfquery> tag?
Answers:
• 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>
17. Which of the following techniques allow
the Coldfusion code to be used at many places with in an application?
Answers:
• cfinclude tag
• User Defined
functions
• CFML tags and
CFX
• Both a and c
• a, b, and c
18. The following structure stores the address
of one of the employees:
<cfset AddrStr= StructNew()>
<cfset
AddrStr.Address1="23/16">
<cfset AddrStr.Address2="Lismore
Street">
<cfset AddrStr.City="Manly">
<cfset AddrStr.Pincode="2065">
And the other Structure stores
"AddStr" as its one of the keys:
<cfset EmpStr = StructNew()>
<cfset EmpStr.Key=AddrStr>
What would you put inside
<cfoutput></cfoutput> tags to print the value of "City"
on the page?
Answers:
•
#EmpStr.key.City#
•
#EmpStr["key"].City#
•
#EmpStr.key["City"]#
•
#EmpStr["key"]["City"]#
• Any of the
above
• Both a and c
• EmpStr.key.City
19. What happens when the following code is
included in a cfm file:
<cflog file="myAppLog"
text="User Kim logged on.">
Answers:
• "User Kim
logged on" will be displayed in the browser
• A new log file
by the name of Kim will be created
• "User Kim
logged on" will replace the last record in the ColdFusion log file
• "User Kim
logged on" will be appended to the ColdFusion log file
20. Query of Queries cannot be performed on
cfassociate.
Answers:
• True
• False
21. What does the cfproperty tag do?
Answers:
• 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
22. What will XResult contain:
<cfset XResult = xmlSearch(XMLObject,
"//info")>
Answers:
• An array
containing the info nodes that fall directly beneath the root node
• An array
containing the info nodes that fall anywhere beneath the root node
• All info nodes
will be returned along with their child and sub-child nodes
• This XPath
expression is erroneous
• An array
containing the attributes of all the info nodes that fall anywhere beneath the
root node
23. There are 5 info nodes in an XML document.
How will you obtain the value of the 3rd info node?
Answers:
• <cfset
XResult = xmlSearch(XMLObject, "/info[2]")>
• <cfset
XResult = xmlSearch(XMLObject, "/info[3]")>
• <cfset
XResult = xmlSearch(XMLObject, "/info[4]")>
• <cfset
XResult = xmlSearch(XMLObject, "/info(1)")>
• <cfset
XResult = xmlSearch(XMLObject, "/info[first()+2]")>
• <cfset
XResult = xmlSearch(XMLObject, "/info[last()-2]")>
24. Which of the following verity query types
is not valid?
Answers:
• Natural
• Search
• Internet
• Simple
• Explicit
25. Which of the following tags was introduced
in the ColdFusion MX series?
Answers:
• cfcalendar
• cfapplet
• cfbreak
• cfdirectory
26. What is correct syntax for accessing an
item of a structure?
Answers:
•
StructFind(item, struct)
•
StructFind(struct, item)
•
FindStruct(struct, item)
•
FindStruct(item, struct)
27. Consider the following <cfquery>
tag:
<cfquery name="GetTableData"
datasource="myDSN">
SELECT * FROM myTable
</cfquery>
Which condition should the WHERE clause
contain so that only those rows are returned that contain null in column
column1?
Answers:
• WHERE column1
is null
• WHERE column1 =
null
• WHERE column1
EQUALS null
• WHERE column1
NOT null
• WHERE column1
CONTAINS null
28. Which of the following makes CFMX7 better
than the previous MX version?
Answers:
• It has added
support for dot notation within a recordset name
• It has added
result attribute
• Deprecated
connectString, dbName, dbServer, provider, and providerDSN attributes
• It has added
cfquery.ExecutionTime
29. Evaluate the following SQL statement:
<cfquery name="GetEmpData"
datasource="myDSN">
SELECT e.employee_id, (.15* e.salary) + (.5 *
e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM
employees e, sales s WHERE e.employee_id = s.emp_id;
</cfquery>
What will happen if all the parentheses are
removed from the calculation in the SQL query?
Answers:
• The value
displayed in the CALC_VALUE column will be lower
• The value
displayed in the CALC_VALUE column will be higher
• There will be
no difference in the value displayed in the CALC_VALUE column
• An error will
be reported
30. Which of the following statements is
correct with regard to Coldfusion Comments?
Answers:
• Nesting of
coldfusion comments is not allowed
• The comments
can be embedded in a function or tag name
• The comments
are allowed in the body of the document only
• The comments
are cleared by coldfusion engine before presenting output to the browser
31. Which of the following can be used to
convert real number into integers?
Answers:
• Ceiling
• Int
• Round
• Fix
• All of the
above
• a, c, and d
32. A code has to be generated by using
'PageCode' and 'ProductCode,' whose numeric values are derived from a database:
<cfset ArPage=ArrayNew(1)>
<cfset ProductCode = #PCode#>
<cfset ClassCode = #CCode#>
You have to assign value "superherb"
to ArPage where index is concatenation of ProductCode and ClassCode. Which of
the following ways would you use?
Answers:
• <cfset
ArPage[#ProductCode##ClassCode#] = "Superherb">
• <cfset ArPage[#ProductCode#
#ClassCode#] = "Superherb">
• <cfset
#ArPage[ProductCode & ClassCode]# = "Superherb">
• <cfset
ArPage[#ProductCode# & #ClassCode#] = "Superherb">
33. Which of the following constitute the core
components of ColdFusion MX?
Answers:
• ColdFusion
application server
• ColdFusion
Markup Language
• ColdFusion MX
Administrator
• All of the
above
34. Which of the following is not a valid
array function?
Answers:
• ArrayAppend
• ArrayInsertAt
• ArraySize
• ArrayPrepend
• None of the
above
35. 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?
Answers:
• <cfset
Form.UserName=''Guest''>
• <cfparam
name=''Form.UserName'' default=''Guest''>
• <cfparam
name=''Form.UserName'' optional=''Guest''>
• <cfparam
name=''Form.UserName'' value=''Guest''>
36. What will be the result of placing the
following code in any cfm file:
<!---
<cflock timeout=20
scope="Session" type="Exclusive">
<cfset StructDelete(Session,
"ShoppingCartItems")>
</cflock>
--->
Answers:
• 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
37. Which of the following allows the use of
CFML tags within its body?
Answers:
• UDF
• CFScript
• UDF and
CFScript
• None of the
above
38. Which of the following structure
assignments is correct?
Answers:
• <cfset
objStruct.value1 = "value">
• <cfset
objStruct[0].value1 = "value">
• <cfset
objStruct[0] = "value">
• All the above
39. Which of the following statements is
correct with regard to Coldfusion functions?
Answers:
• 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
40. Which encryption engine is used by the
ColdFusion MX encrypt and hash functions?
Answers:
• PGP 8.0
• Java
Cryptography Extension (JCE)
• CryptoText
Encryption Library
• Microsoft High
Encryption Pack
41. Which of the following is an invalid
variable scope?
Answers:
• Super
• This
• Caller
• Server
42. What is the result of the following code:
<cfset mystring = "'Newton's Law',
'Fermat's Theorem'">
<cfoutput>
#PreserveSingleQuotes(mystring)#
</cfoutput>
Answers:
• 'Newton's Law',
'Fermat's Theorem'
• Newton's Law,
Fermat's Theorem
• "Newton's
Law", "Fermat's Theorem"
• 'Newtons Law',
'Fermats Theorem'
43. What will XResult contain:
<cfset XResult = xmlFind(XMLObject, "//info@size='3'")>
Answers:
• All the info
elements that have an attribute called size with a value of 3
• The size
attribute of the third info node
• The info
attribute of the third size node
• The statement
contains an error
44. Which of the following statements are true
when you upload an image file using the <cffile> tag?
Answers:
• 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
45. You want create PDF files of your XHTML
documents using ColdFusion MX. How can you do this?
Answers:
• It cannot be
done
• You will have
to write your own highly complex code for doing this
• You can use
XSLT and XSL-FO to render the XHTML as a PDF
• There is a
function available in ColdFusion for creating PDFs
46. If the following code is inserted into
your website, when will the cookies expire?
<CFCOOKIE NAME="CFID"
VALUE="#Session.CFID#">
<CFCOOKIE NAME="CFTOKEN"
VALUE="#Session.CFTOKEN#">
Answers:
• when the
session ends
• When the
application ends
• This code has
no effect on the expiration of the cookies
47. Which of the following ColdFusion tags is
used to get the elements, variables and values of ColdFusion objects?
Answers:
• cfcollect
• cfcomponent
• cfdump
• cfdocument
48. Which of the below statements are correct
regarding the following code:
<cfset a = GetTickCount()>
<cfloop from="1"
to="10000" index="i">
</cfloop>
<cfset b = GetTickCount()>
<cfscript>
c = GetTickCount();
for (i = 1; i LTE 10000; i = i+1) ;
d = GetTickCount();
</cfscript>
<cfoutput>#b-a# vs.
#d-c#</cfoutput>
Answers:
• 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
49. Which of the following statement is
correct?
Answers:
• The coldfusion
script is contrary to Java script
• The coldfusion
script runs on client system
• The coldfusion
script is used for creating user defined functions
• The coldfusion
script provides access to some of the in-built coldfusion functions
50. You want to display the titles of books
that meet the following criteria:
1. Purchased before November 11, 2002
2. Price is less than $500 or greater than
$900
You want to sort the result by the date of
purchase, starting with the most recently bought book.
Which of the following queries will you use in
the <cfquery> tag?
Answers:
• SELECT
book_title FROM books WHERE price between 500 and 900 AND purchase_date <
'11/11/2002' ORDER BY purchase_date;
• SELECT
book_title FROM books WHERE price IN (500, 900) AND purchase_date <
'11/11/2002' ORDER BY purchase date ASC;
• SELECT book_title
FROM books WHERE price < 500 OR>900 AND purchase_date DESC;
• SELECT
Book_title FROM books WHERE price < 500 OR price > 900 AND purchase_date
< '11/11/2002' ORDER BY purchase date DESC;
51. A company has the following departments:
Marketing, Designing, Production, Packing
What will the following query return?
<cfquery name="GetDeptData"
datasource="myDSN">
select * from departments where department
< 'Marketing'
</cfquery>
Answers:
• 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"
52. What is the output of the following code:
<CFPARAM DEFAULT="ProjectManager"
NAME="Status">
<CFPARAM DEFAULT="Six Sigma"
NAME="ProjectType">
<CFIF
IsDefined("FORM.Status")>
Welcome
<CFOUTPUT>#FORM.Status#</CFOUTPUT>
<CFELSEIF IsDefined("Status")>
You are not a
<CFOUTPUT>#Status#</CFOUTPUT>
<CFELSE>
Welcome
</CFIF>
Answers:
• Welcome
ProjectManager
• You are not a
ProjectManager
• Welcome
• Six Sigma
ProjectManager
• You are not a
Six Sigma
• None of the
above
53. Which of the following constitute the
common characteristics shared by most of the Coldfusion Tags?
Answers:
• 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
54. Which of the following characters need
escaping?
Answers:
• #
• "
• '
• @
• All of the
above
• a, b, and c
55. What is the output of the following code:
<cfscript>
function autoLeadIn(string,count) {
output = '';
if(Trim(string) NEQ '') {
textarray = ListToArray(string, "
");
if(ArrayLen(textarray) LTE count) {
count = ArrayLen(textarray);
}
for(i=1; i LTE count; i=i+1)
{
output = output & textarray[i];
if(i neq count) {
output = output & " ";
}
}
}
return output;
}
</cfscript>
<cfoutput>#autoleadin("qwerty
asdfg, poiuy, zxcvb",3)#</cfoutput>
Answers:
• qwerty asdfg,
poiuy,
• qwerty asdfg,
poiuy
• qwerty asdfg
• qwerty asdfg,
poiuy, zxcvb
56. 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?
Answers:
• <cftag
class=CalcClass IntValue=20>
• <cfx
name=CalcClass IntValue=20>
•
<cfx_CalcClass IntValue=20>
• <cfx
tag=CalcClass IntValue=20>
57. 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?
Answers:
• <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>
58. What is the output of the following code:
<cfscript>
function calculateresult()
{
var a=55;
var b=5;
b=b-a*b+a;
return b;
}
</cfscript>
<cfoutput>#calculateresult()#</cfoutput>
Answers:
• -215
• 215
• -325
• 325
59. What is the output of the following code:
<cfoutput>reverse(6*2) equals
#reverse(6*2)#</cfoutput>
Answers:
• reverse(6*2)
equals 12
• reverse(2*6)
equals 21
• reverse(6*2)
equals 21
• reverse(2*6)
equals 12
60. Which of the following tags do not work in
the ColdFusion MX series?
Answers:
• cfauthenticate
• cfapplication
• cfloginuser
• cfmodule
61. What is the output of the following code:
<cfscript>
function calculateresult()
{
var a=55;
var b=5;
b=a+b;
b=b+b;
return b;
}
</cfscript>
<cfoutput>#calculateresult()#</cfoutput>
Answers:
• 100
• 120
• 10
• 65
62. What is the output of the following code:
<cfoutput>
<cfset stringToSearch =
"The quick brown fox jumped over the lazy dog.">
#find("the",stringToSearch)#
#find("the",stringToSearch,35)#
#find("no such
substring",stringToSearch)#
</cfoutput>
Answers:
• 3300
• 0 0 33
• 0 33 0
• 33 0 0
63. 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?
Answers:
• 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
datasource
• This cannot be
accomplished
64. What is the output of the following code:
<cfoutput>#IncrementValue(123.35)#</cfoutput>
Answers:
• 123
• 124
• 123.5
• 122
• 100
65. What is the output of the following code:
<cfset myArray = ArrayNew(1)>
<cfset myArray[1] = "Test
Value">
<cfset temp =
ArrayAppend(myArray, "Akash")>
<cfset temp =
ArrayAppend(myArray, "Peterson")>
<cfset temp
= ArrayAppend(myArray, "Dave Heartsdale")>
<cfset temp = ArrayAppend(myArray, "Aaron Smith")>
<cfoutput>
<p>This
array has #ArrayLen(MyArray)# elements.
</cfoutput>
Answers:
• This array has
1 elements
• This array has
5 elements
• Test Value,
Akash, Peterson, Dave Heartsdale, Aaron Smith
• This array has
Test Value, Akash, Peterson, Dave Heartsdale, Aaron Smith
66. Examine the data in the EMPLOYEES table
given below:
LAST_NAME
DEPTARTMENT_ID
SALARY
ALLEN
10
3000
MILLER
20
1500
King
20
2200
Davis
30
5000
Which of the following queries will execute without
error?
Answers:
• <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>
67. A coldfusion list is defined as follows:
<cfset list1="24,25,26,27,">
<cfset list2="24,,25,26,27">
<cfset
list3="24,,,,25,26,27,">
<cfset
list4="24,25,,26,,27,,">
What will you get on printing
"listlen" for all the above lists?
Answers:
• 4, 5, 7, 7
• 4, 4, 7, 7
• 4, 4, 4, 4
• 4, 5, 6, 6
68. 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?
Answers:
•
<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>
69. Which of the following statements with
respect to the below code is correct?
<cfset RandomItem = RandRange(1,
greatoffers.recordcount)>
<CFOUTPUT QUERY="greatoffers"
MAXROWS=1 STARTROW=#RandomItem#>
<B>#ProductTitle#</B> -
#DollarFormat(greatoffers.Special_Price)#<BR>
</CFOUTPUT>
Answers:
• 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
70. Which of the following statements is
incorrect with regard to Coldfusion Tags?
Answers:
• 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
71. Which of the following is not an in-built
complex data type in Coldfusion?
Answers:
• query
• array
• hashtable
• structure
72. Which function has been used to generated the
following output?
pro%20discount
Answers:
• URLEncode
• HtmlEditFormat
• UrlDecode
•
URLEncodedFormat
73. What is the output of the following code:
<cfset yourDate = CreateDate(2002, 11,
23)>
<cfoutput>
This is day #Day(YourDate)# in the month of
#MonthAsString(Month(yourDate))#, which has
#DaysInMonth(yourDate)#
days.
</cfoutput>
Answers:
• 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
74. An admin(role-type) function(ChkBalance)
has to be created for printing the account balance of all the users. Which of
the following ways helps one do this?
Answers:
• <cffunction
name="ChkBalance" returnType="numeric"
roles="admin" access="remote" output="yes">
• <function
name="ChkBalance" return="numeric" roles="admin"
access="local" output="no">
• <cffunction
name="ChkBalance" return="String" role="admin"
accessMode="remote" return=yes">
• <cffunction
id="ChkBalance" returnType="numeric" role="admin"
accessMode="local" return="no">
75. Which of the following is an incorrect
floop syntax:
Answers:
• <cfloop
index . . .
• <cfloop
counter . . .
• <cfloop
condition. . .
• <cfloop
query . . . <cfloop list . . .
76. What will the following code do when
included in a ColdFusion application?
<cfloop collection="#session#"
item="j">
<cfoutput>#j# has value of :
#session[j]#<br></cfoutput>
</cfloop>
Answers:
• It will list
out all the application variables
• It will list
out all the cookies
• It will list
out all the session variables
• It will list
out the Html header
77. What is the output of the following code:
<cfoutput>#REReplace("I love
jelly","jell(y|ies)","cookies")#</cfoutput>
Answers:
• I love jelly
• I love jellies
• I Love jelly,
cookies
• I love cookies
78. What is the output of the following code:
<cfset stringToSearch = "The quick
brown fox jumped over the lazy dog.">
<cfoutput>
#findoneof("aeiou",stringToSearch)#
#findoneof("aeiou",stringToSearch,4)#
#findoneof("@%^*()",stringToSearch)#
</cfoutput>
Answers:
• 3 6 0
• 360
• 3 6
• 3 6 0 0
79. What will the xInfo variable contain:
<cfset xInfo =
objXML.xmlRoot.xmlChildren[6]["info"].xmltext>
Answers:
• 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
80. Which of the following is not passed as
reference to the object?
Answers:
• structure
• array
• cfobject
• query
81. Which of the following statements is
correct with regard to Function?
Answers:
• 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
82. Which of the following has the highest
operator precedence?
Answers:
• MOD
• *
• NOT
• +
83. Which of the following ColdFusion tags
aborts the processing of the current ColdFusion page?
Answers:
• cfabort
• cfabandon
• cfkill
• cfswitch
84. What is the output of the following code:
<cfoutput>
#dateformat(CreateDate(2001,08,10),"dd,mmm,yyyy")#
</cfoutput>
Answers:
• 8,OCT,2001
• 10,08,2001
• Aug,10,2001
• 10,Aug,2001
85. How will you test whether a cookie has
already been set on the clients browser?
Answers:
• <CFIF
IsDefined(COOKIE("VistorId"))>
• <CFIF
IsDefined("CFCOOKIE.VistorId")>
• <CFIF
IsDefined("COOKIE.VistorId")>
• None of the
above
86. Examine the code given below:
<cfquery name="GetEmpData"
datasource="myDSN">
SELECT employee_id FROM employees WHERE
commission_pct=.5 OR salary > 23000
</cfquery>
Which of the following statements is correct
with regard to this code?
Answers:
• It returns
employees whose salary is 50% more than $23,000
• It returns
employees who have 50% commission rate or salary greater than $23,000
• It returns
employees whose salary is 50% less than $23,000
• None of the
above
87. What will be the output of the given
expression:
evaluate("23" & 2 + 5)
Answers:
• 51
• 30
• 237
• 230
88. 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?
Answers:
•
IsValid("email", Form.EmailAd)
•
IsEmail(Form.EmailAd)
•
IsEmail(#Form.EmailAd#)
•
IsValidType("email", Form.EmailAd)
89. You wrote the following code to set the
prices of the items in an array:
<cfset numArray = ArrayNew(1)>
<cfset ArraySet(numArray, 1, 8 ,25)>
<cfset numArray[3] = "225">
<cfset PriceFound = False>
<cfset ElementNo = 0>
Storing the special price 225, you wrote the
following code to find the array number:
<cfloop condition = "(NOT PriceFound)
AND (ElementNo LT ArrayLen(numArray))">
<cfset ElementNo = ElementNo + 1>
<cfif
numArray[ElementNo] IS "225">
<cfoutput> PriceFound at ElementNo #ElementNo#<br></cfoutput>
<cfset PriceFound = true>
</cfif>
<cfoutput> Searching element . . . #ElementNo#<br></cfoutput>
</cfloop>
What will be the output?
Answers:
• Three lines for
'Searching element . . . ' and one line indicating the 'PriceFound at ElementNo
3'
• Two lines for
'Searching element . . . ' and one line indicating the 'PriceFound at ElementNo
2'
• Eight lines for
'Searching element . . . ' and one line indicating the 'PriceFound at ElementNo
3'
• A syntax error
90. Which of the following constitute the four
categories of the Coldfusion data types?
Answers:
• application,
binary, variant, and local
• simple,
complex, aggregate, and binary
• primary,
secondary, complex, and object
• simple,
complex, binary, and object
91. 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?
Answers:
• <cf_CustTag
StrName,ArrItems>
• <cf_CustTag
stringval=StrName arrayval=ArrItems>
• <cf_CustTag
stringval=#StrName# arrayval=#ArrItems#>
• <cf_CustTag
#StrName# #ArrItems#>
92. Which encryption algorithms are supported
by the encrypt/decrypt functions?
Answers:
• MD5
• SHA
• DES
• AES
• Blowfish
93. Which of the following functions are
specially used with regular expressions?
Answers:
• REFind
• REFindNoCase
• REReplace
• REReplaceNoCase
• All of the
above
94. Which encryption algorithms does the hash
function support?
Answers:
• CFMX_COMPAT
• MD5
• SHA
• SHA-256
• SHA-384
• SHA-512
• CBC
• Blowfish
95. Which of the following does not constitute
flow control tag in Coldfusion?
Answers:
• cfabort
• cfset
• cfdefaultcase
• cfloop
96. You have retrieved the list of all the customers
and the products bought for the day, using a cfquery. The structure
"CNameStr" stores the value of a customer's first, middle, and the
last name in the keys "First", "Middle", and
"Last." While printing the report, you want to create the following
label, only if the middle name exists:
<cfoutput>Middle Name:
#CNameStr.Middle#</cfoutput><br>
Which of the following code blocks serves this
purpose with <cfif></cfif> tags?
Answers:
• <cfif
StructKeyExists(CNameStr,Middle)>
• <cfif
StructKeyExists(CNameStr,"Middle")>
• <cfif
StructKeyExists("CNameStr","Middle")>
• <cfif
KeyExists("CNameStr",Middle)>
• <cfif
KeyExists(CNameStr,Middle)>
97. Which of the following is useful in
Dynamic Evaluation?
Answers:
• DEval
• Dynamic
• Evaluate
• Eval
98. With respect to the following code, which
option is correct?
<cfoutput>
#GetHttpTimeString(now())#
</cfoutput>
Answers:
• It will get the
current GMT time
• It will get the
current time of the users computer
• It converts the
current time into a string and stores it in a variable
• It will get the
current web server time
99. What is the output of the following code:
<cfsilent>
<cfset a = 100>
<cfset b = 99>
<cfset c = b-a>
<cfoutput>Inside cfsilent
block<br>
b-a = #c#</cfoutput><br>
</cfsilent>
<cfoutput>
b-a = #c#
</cfoutput>
Answers:
• -1=-1
• b-a=c
• b-a = -1
• Nothing will be
displayed
100. How do you decrypt text that has been
encrypted using the hash function?
Answers:
• By using the
unhash function
• By hashing the
encrypted text again
• It cannot be
done
• By using the
decrypt function
101. What is the output of the following code:
<cfset
strabc=setVariable("abc","abc123")>
<cfset
strxyz=setVariable("xyz","xyz321")>
<cfoutput>
strabc = #strabc# , strxyz =
#strxyz#
</cfoutput>
Answers:
• 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
102. Which ColdFusion tag is used to stop the
processing on the current page and opens a new ColdFusion or html file?
Answers:
• cfredirection
• cfrelocate
• cflocation
• cfnewpage
103. Which of the following statement(s) are
correct?
Answers:
• <cfdirectory
directory="//12.12.54.65/c/" name="dirQuery" action="LIST">
• <cfdirectory
directory="c:\inetpub\wwwroot" name="dirQuery"
action="LIST">
• <cfdirectory
directory="http://12.12.54.65/c/" name="dirQuery"
action="LIST">
• Both a and b
• Both b and c
104. Which of the following statements about
User defined functions (UDFs) are correct.
Answers:
•
<cfscript> code can call functions but not tags
• User defined
functions written in <cfscript> can call CFML tags
•
<cffunction> is one of the tags in ColdFusion MX used for creating UDFs
•
<cfreturn> is one of the tags in ColdFusion MX used for creating UDFs
105. Which of the following functions is not
available with Coldfusion arrays?
Answers:
• ArrayLen
• ArraySort
• ArrayDelete
• ArrayAppend
106. Which of the following constitutes CFML?
Answers:
• Functions and expressions
• Variables and
constants
• Flow control
structures
• All of the
above
• both a and b
107. Which of the following statements is
correct with regard to user defined functions?
Answers:
• 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
108. Which of the following attributes of the
cfquery tag was introduced in ColdFusion MX 7?
Answers:
• username
• debug
• result
• timeout
109. 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?
Answers:
• <cfinsert
DSN="GuestDSN" table="TbGuest">
• <cfinsert
datasource="GuestDSN" tablename="TbGuest">
• <insert
datasource="GuestDSN" tablename="TbGuest">
• <insert
DSN="GuestDSN" table="TbGuest">
110. Which of the following statements
regarding placing meta tags at the location *********** in the following code
are correct?
<cfset
browsers="MSIE,Mozilla">
<cfif
FindNoCase(browsers,#CGI.HTTP_USER_AGENT#)>
<**************>
</cfif>
Answers:
• The meta tags
will be hidden from all browser users
• The meta tags
will be hidden from Opera users
• The meta tags
will be hidden from unknown spiders
• The meta tags
will be hidden from MSIE and Mozilla users
• None of the
above
FindNoCase(browsers,#CGI.HTTP_USER_AGENT#)>
<**************>
</cfif>
Answers:
• The meta tags
will be hidden from all browser users
• The meta tags
will be hidden from Opera users
• The meta tags
will be hidden from unknown spiders
• The meta tags
will be hidden from MSIE and Mozilla users
• None of the
above
