Adobe ColdFusion Quiz # 3

Which of the following is NOT a required Application.cfc setting for using ORM?

this.ormenabled

this.ormsettings

this.name

this.datasource

Which of the following prints out "Fail"?

Success Fail

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

True or False? In ColdFusion 8, you can upload multiple files at once by setting CFFILE action to "uploadAll"

True

False

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

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

Which of the following is NOT a valid Array function?

ArrayNew()

ArrayDelete()

ArrayAppend()

ArrayClear()

Which of the following IS NOT used to create a XML document object?

XMLNew function

XMLParse function

XMLFormat function

tag

Which of the following will result in an error?

What is the outcome of the code? <cfset structInsert(CGI, 'newVar','CF',true)/> <cfoutput>#CGI.newVar#</cfoutput>

Error

NULL

CF

Which of the following are NOT valid CFML to check whether num1 is greater than or equal to num2?

= num2>

By default, in which scope does a ColdFusion application store login information?

Session

Request

Cookie

URL

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.

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

Can ColdFusion create a CAPTCHA?

No, ColdFusion cannot do that.

Yes, with the <cfimage> tag.

Yes, there is a <cfcaptcha> tag.

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

True or False? Using <cfloop> to loop over a file opens the entire file in memory.

False

True

As in JavaScript, in ColdFusion you can write a function inside another function

True

False

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

True or False? Arrays are passed by reference like Structs.

TRUE.

FALSE.

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.

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?

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

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>

100

120

10

65

Which of the following allows the use of CFML tags within its body?

UDF

CFScript

UDF and CFScript

None of the above

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>

-215

215

-325

325

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>

3 6 0

360

3 6

3 6 0 0

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

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>

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

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"

What will be the output of the given expression:

evaluate("23" & 2 + 5)

51

30

237

230

Quiz:	Adobe ColdFusion Quiz # 3
Subject:	Basic Adobe Coldfusion
Total Questions:	30 MCQs
Time:	30 Minutes

Adobe ColdFusion Quiz # 3

Which of the following is NOT a required Application.cfc setting for using ORM?

Which of the following prints out "Fail"?

Where is considered the best place to name your application so the request is tied to the right application?

True or False? In ColdFusion 8, you can upload multiple files at once by setting CFFILE action to "uploadAll"

How many remote IP addresses can access an installation of the free developer edition of Adobe ColdFusion?

Which of the following versions of ColdFusion has passed its core support deadline, but is still within its extended support period?

Which of the following is NOT a valid Array function?

Which of the following IS NOT used to create a XML document object?

Which of the following will result in an error?

What is the outcome of the code? <cfset structInsert(CGI, 'newVar','CF',true)/> <cfoutput>#CGI.newVar#</cfoutput>

Which of the following are NOT valid CFML to check whether num1 is greater than or equal to num2?

By default, in which scope does a ColdFusion application store login information?

Given a page, customtag.cfm, called with will invoke the code twice whereas called with will invoke the code once.

From the below array, how do you access the value "banana"?

Can ColdFusion create a CAPTCHA?

What is the correct output for the following? #str2

True or False? Using <cfloop> to loop over a file opens the entire file in memory.

As in JavaScript, in ColdFusion you can write a function inside another function

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?

True or False? Arrays are passed by reference like Structs.

What does this code do? #DateFormat(date, "dd mmm yyyy")#

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?

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>

Which of the following allows the use of CFML tags within its body?

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>

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>

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?

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?

What will be the output of the given expression:evaluate("23" & 2 + 5)

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?

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>

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>

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>

What will be the output of the given expression:

evaluate("23" & 2 + 5)