Adobe ColdFusion Quiz # 4

Which of the following verity query types is not valid?

Natural

Search

Internet

Simple

Explicit

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#

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="">

What will XResult contain:

<cfset XResult = xmlSearch(XMLObject, "//@size")>

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

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

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>

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"

What does the following code do?

<cfstoredproc procedure="GetInfo" datasource="MyDSN">
        <cfprocparam value="#variables.ID#" cfsqltype="cf_sql_integer">
        <cfprocresult name="getDepartments" resultSet="1">
        <cfprocresult name="getEmployees" resultSet="2">
</cfstoredproc>

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

Which of the following tags do not work in ColdFusion MX 7?

cfgrid

cfform

cfchart

cfgraph

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

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

Which of the following does not constitute flow control tag in Coldfusion?

cfabort

cfset

cfdefaultcase

cfloop

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

Which of the following structure assignments is correct?

cfset objStruct.value1 = "value"

cfset objStruct[0].value1 = "value"

cfset objStruct[0] = "value"

All the above

Which of the following functions is not available with Coldfusion arrays?

ArrayLen

ArraySort

ArrayDelete

ArrayAppend

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

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

Which of the following ColdFusion tags is used to get the elements, variables and values of ColdFusion objects?

cfcollect

cfcomponent

cfdump

cfdocument

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?

WHERE column1 is null

WHERE column1 = null

WHERE column1 EQUALS null

WHERE column1 NOT null

WHERE column1 CONTAINS null

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>

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

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

Which operator will be evaluated first in the following statement:

<cfquery name="GetEmpData" datasource="myDSN">
select (age + 3 * 4 / 2 - 8) from emp
</cfquery>

+

-

/

*

Which of the following is not an in-built complex data type in Coldfusion?

query

array

hashtable

structure

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

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

What is the output of the following code:

<cfoutput>reverse(6*2) equals #reverse(6*2)#</cfoutput>

reverse(6*2) equals 12

reverse(2*6) equals 21

reverse(6*2) equals 21

reverse(2*6) equals 12

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

Which of the following constitute the core components of ColdFusion MX?

ColdFusion application server

ColdFusion Markup Language

ColdFusion MX Administrator

All of the above

What will the xInfo variable contain:

<cfset xInfo = objXML.xmlRoot.xmlChildren[6]["info"].xmltext>

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

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>

Welcome ProjectManager

You are not a ProjectManager

Welcome

Six Sigma ProjectManager

You are not a Six Sigma

None of the above

Which ColdFusion tag is used to import a Java Server Page (JSP) tag library?

cfjimport

cfimport

cfinclude

cfinsert

cfsetting