ColdBox Interview Questions for Freshers/ColdBox Interview Questions and Answers for Freshers & Experienced

how do you call stored procedure in coldfusion? What are the tags, subtags, how to pass parameters to stored procedure and to return the result?

<cfstoredproc> - Executes a stored procedure in a server database. It specifies database connection information and identifies the stored procedure.

<cfstoredproc procedure="" datasource="" >
<cfprocparam cfsqltype="" value="">

Posted Date:- 2021-11-29 00:17:16

can we have multiple queries in cfquery

we can have multiple queries with union or union all. with out this if we use multiple queries system will execute only first query and it will not throw any error.

Posted Date:- 2021-11-29 00:16:34

can we query multiple databases in one cfquery?

No we cannot query multiple databases in one single query. we can query multiple databases in cftransaction with multiple cfquery statements.

Posted Date:- 2021-11-29 00:15:52

Explain few coldfusion functions?

ArrayToList, ArrayAppend, ListLen, ListGetAt

Posted Date:- 2021-11-29 00:14:46

how do you clear cache?

<cfcache action="flush">

Posted Date:- 2021-11-29 00:14:05

Explain geofencing and how do you implement in coldfusion?

Geofencing is a location-based service that businesses use to engage their audience by sending relevant messages to smartphone users who enter a pre-defined location or geographic area.

Posted Date:- 2021-11-29 00:13:16

Explain cflock and usage?

Ensures the integrity of shared data. Instantiates the following kinds of locks:

Exclusive - Allows single-thread access to the CFML constructs in its body. The tag body can be executed by one request at a time. No other requests can start executing code within the tag while a request has an exclusive lock. ColdFusion issues exclusive locks on a first-come, first-served basis.

Read-only - Allows multiple requests to access CFML constructs within the tag body concurrently. Use a read-only lock only when shared data is read and not modified. If another request has an exclusive lock on shared data, the new request waits for the exclusive lock to be released.

Posted Date:- 2021-11-29 00:12:20

Differences between rest and soap webservices?

SOAP stands for Simple Object Access Protocol whereas REST stands for Representational State Transfer. ... SOAP only works with XML formats whereas REST work with plain text, XML, HTML and JSON. SOAP cannot make use of REST whereas REST can make use of SOAP.

SOAP is a protocal, any webservice comes with wsdl it is a SOAP webservice else REST webservice.

Posted Date:- 2021-11-29 00:10:25

Explain CFFILE with actions(read, write, delete, rename, update etc) ?

<cffile> tag is used to move,read,delete,copy,upload a file etc

<cffile action="upload" destination=""> - Copies a file to a directory on the server.

Posted Date:- 2021-11-29 00:09:22

Explain the purpose of CFTRANSACTION ,Multiple datasources, databases,commit, rollback, savepoint?

For enterprise database management systems that support transaction processing, instructs the database management system to treat multiple database operations as a single transaction. Provides database commit and rollback processing. We can execute multiple databases queries in one cftransaction, but after every database query execution it has to be commited.

Posted Date:- 2021-11-29 00:08:50


Application.cfm is used to define the Application Management, Session Management, Client Management, Error Handling, Logging the errors to particular Log Files.

Application.cfm is used to set the application time out, session time out, client timeout etc.

We can have multiple Application.cfm files, Application.cfm that is in root folder will give first priority.

Posted Date:- 2021-11-29 00:07:57

Differentiate and explain the usage of CUSTOM TAGS (CFMODULE/CF_XXX) VS CFINCLUDE VS CFC ?

cfinclude tag includes a part of code, cfc is set of functions which can be used as webservice.cfc has multiple entry points.

Posted Date:- 2021-11-29 00:06:53

Differentiate and explain the usage of CUSTOM TAGS CF_XXX VS CFMODULE?

cfmodule is used to call the custom tag and helps from name conflicts.

cf_xxx is used to call the custom tag.

Posted Date:- 2021-11-29 00:06:12

REDIRECTION using CFLOCATION (Addtoken values and its benefits)?

<cflocation template="/test/test.cfm">

cflocation tag stops the processing of page till the cflocation tag and redirects to the file placed in the template attribute(test.cfm).

Posted Date:- 2021-11-29 00:05:30

Explain the security features implemented in coldfusion?

1) Sql Injection - cfqueryparam
2) Cross Site scripting - encodeforhtml,encodeforjavascript etc
3) Cross Site Request Forgery - generate crpf token and use it in your code and session. if match yes else no.
4) Encode Coldfusion Code

Posted Date:- 2021-11-29 00:04:38

Explain QUERY OF QUERIES (reusable, better performance) Using DBTYPE="Query")?

A query that retrieves data from a record set is called query of queries. The typical use behind this concept is retrieve an entire table into memory with one query, and then access the record set with subsequent filtering and
sorting queries.

If we need to access the same tables multiple times, then we can reduce the access time, because the record set is already in memory. This is restricted to the memory of coldfusion host computer.

We can perform joins and unions operations on results from different data sources.

We can efficiently manipulate cached query results in different required

We can use this in report definitions to generate sub report data.

Posted Date:- 2021-11-29 00:02:40

STRUCTURE (Structure key-value functions, conflicts with index order)?

ColdFusion structures consist of key-value pairs. Structures let you build a collection of related variables that are grouped under a single name. You can define ColdFusion structures dynamically. You can use structures to reference related values as a unit, rather than individually.

Posted Date:- 2021-11-29 00:01:56

LIST Functions(Nth element in list, count, length)

Nth element - ListGetAt
count - ListLen
length - Len

For more list functions follow below reference.

Posted Date:- 2021-11-29 00:01:06


<cfoutput> tag is used to display the output. ex:- <cfouput>#query.variable#</cfoutput>

we can loop query with cfoutput. ex:- <cfoutput query="nameofthequery">#nameofthequery.variable#</cfoutput>Nested cfoutput - using cfoutput inside cfoutput is not possible, instead you can use cfloop inside cfoutput loop or you can use group attribute in the cfoutput.

Posted Date:- 2021-11-29 00:00:00

What is WDDX? Where is it applicable?

<cfwddx> tag is used to serialize and deserialize the wddx to xml and xml to wddx.

<cfwddx action="cfml2wddx" input="#MyQueryObject#" output="WddxTextVariable">

Posted Date:- 2021-11-28 23:59:24

How to show a report in PDF?

By using the tags <cfdocument>,<cfdoumentitem>,<cfdocumentsection> we can generate a report in pdf.


<cfdocument format="PDF">
Bacon ipsum dolor sit amet sirloin fatback #dateformat(now(), "short")#

Posted Date:- 2021-11-28 23:58:31

What is Flash Form?

ColdFusion can deliver forms to the client in Flash (SWF file) format. ColdFusion automatically generates the Flash binary from your CFML code and displays it on the client. Flash forms are browser-independent.

Posted Date:- 2021-11-28 23:57:20

How to create Tab strip?

We can create tab strips using cflayout and cflayout area.

Posted Date:- 2021-11-28 23:56:53

what is the difference between cfinvoke and cfobject?

cfobject create an object and call component, cfinvoke creates object and call component in same statement.

Posted Date:- 2021-11-28 23:56:24

What is CFTransaction?

For enterprise database management systems that support transaction processing, instructs the database management system to treat multiple database operations as a single transaction. It provides database commit and rollback processing. See the documentation for your database management system to determine whether it supports SQL transaction processing.

1. <cftransaction
2. action = "begin|commit|rollback|setsavepoint"
3. isolation = "read_uncommitted|read_committed|repeatable_read"
4. savepoint = "savepoint name">
5. </cftransaction>

Posted Date:- 2021-11-28 23:55:59

How to invoke CFC?

Method 1:

view plaincopy to clipboardprint?
1. <cfinvoke>
2. <cfinvoke component="user" method="Get" returnvariable="usr">
3. <cfinvokeargument name="id" value="#id#">
4. </cfinvoke>

Method 2:

view plaincopy to clipboardprint?
1. <!--- Load CFC as an object --->
2. <cfobject component="user" name="userObj">
3. <!--- Invoke method --->
4. <cfinvoke component="#userObj#" method="Get" id="#id#" returnvariable="usr">

Method 3:

view plaincopy to clipboardprint?
1. <cfscript>
2. // Load CFC as an object
3. userObj=CreateObject("component", "user");
4. // Invoke method
5. user_id=userObj.Get(id);
6. </cfscript>

Posted Date:- 2021-11-28 23:53:58

What are ColdFusion components? What is CFobject?

A ColdFusion component (CFC) file contains data and functions that you define in related, multiple methods. You use CFC pages to organize related actions in one file, which provide can simplify your programming.

Posted Date:- 2021-11-28 23:52:29

What is CFX tag? What is the use?

ColdFusion Extension (CFX) tags are custom tags that you write in Java or C+. Generally, you create a CFX tag to do something that is not possible in CFML. CFX tags also let you use existing Java or C+ code in your ColdFusion application. Unlike CFML custom tags, CFX tags cannot have bodies or ending tags.

Posted Date:- 2021-11-28 23:51:31

How to implement method overloading and overriding in coldfusion?

In coldfusion we dont support method overloading(with different parameters). We support only Overriding.

Posted Date:- 2021-11-28 23:51:00

How do you call a custom tag?

Create the .cfm which you want to convert to custom tag and call the file with cf_xxx(name of the .cfm file). Suppose you created the .cfm file with name test.cfm. you can call it as custom tag like <cf_test>.

Create a ColdFusion page(.cfm) which you want to convert to custom tag that shows the current date:
Save the file as date.cfm.
Create a ColdFusion page, the calling page, with the following content:

<title>Date Custom Tag</title>
<!--- Call the custom tag defined in date.cfm --->

Save the file as callingdate.cfm.

View callingdate.cfm in your browser. This custom tag returns the current date in the format DD-MMM-YY.

Posted Date:- 2021-11-28 23:50:22

What is the difference between Custom tag and Coldfusion Component?

The differences are

Custom Tags:

-A single entry point is available for custom tags

-Custom tags does not support formalized parameter passing and validation mechanism

-Persistence is not possible for custom tags

-Custom tags are accessible locally and only by ColdFusion

ColdFusion Component:

-Multiple entry points are available for CFC

-CFC does support formalized parameter passing and validation mechanism

-Persistence is possible for CFC

-CFCs can be accessed as web services

Posted Date:- 2021-11-28 23:49:49

What are the different types of resources through which ColdFusion can communicate?

Following support Coldfusion to communicate

Mobile phones with support of SMS
XMPP or Lotus IM Clients
CMS and File systems
Java Socket Components

Posted Date:- 2021-11-28 23:48:41

Explain cfimport and its usage?

We can use the cfimport tag to import either of the following:

All ColdFusion pages in a directory, as a tag custom tag library.
A Java Server Page (JSP) tag library. A JSP tag library is a packaged set of tag handlers that conform to the JSP 1.1 tag extension API.
<cfimport path = "the CFC namespace to import" prefix = "custom" taglib = "tag library location">

Posted Date:- 2021-11-28 23:48:19

Discuss advantages and disadvantages of using stored procedures versus calling SQL inline in Cold Fusion?

Advantages :-

Query and Stored Procedure do the same thing but the difference is that a query should be compiled everytime the query is executed,while the stored procedure is in compiled form when executed first time.

Stored Procedure Results can be returned as a result set, or as an OUT parameter cursor.

Stored procedures can have parameters for both passing values into the procedure and returning values from the call.

Disadvantages :-

Only one dataset is allowed in a stored procedure

Can contain several statements, loops, IF ELSE, etc.

Posted Date:- 2021-11-28 23:47:37

how to send bulk emails?

One approach would be to generate the emails in timed batches to spread the load evenly. The batch size and delay between batches can be adjusted to suit your environment.

Posted Date:- 2021-11-28 23:45:08

explain the email tags and subtags to send an email?

cfmail - Sends email
cfmailparam - used for attachments

<cfmail from="" cc="" to="">

<cfoutput>we are sending this to test the mail communication</cfoutput>


Posted Date:- 2021-11-28 23:44:35

Explain different types of loops in coldfusion?

This tag supports the following types of loops:
cfloop: index loop.
cfloop: conditional loop.
cfloop: looping over a date or time range.
cfloop: looping over a query.
cfloop: looping over a list, a file, or an array.
cfloop: looping over a COM collection or structure.

Posted Date:- 2021-11-28 23:44:13


CFSET is used to set the value of a variable whether the variable is already defined or not. If the variable already has a value in it, CFSET will step on that value.

<cfset reportName = "QM Audits Summary Report">
CFPARAM should be used when you want to set the value of a variable only if it isn't already defined. It will assign a default value. It will initialize and/or define the datatype of a variable.
<cfparam name="reportName" default="" type="string">

Posted Date:- 2021-11-28 23:43:55

What is used to create connections between ColdFusion Web sites and databases?

In the ColdFusion Administrator, select Data & Services > Data Sources.Under Add New Data Source, enter a data source name,Select a driver from the drop-down list; for example, Microsoft SQL Server.Click Add.
A form for additional DSN information appears. In the Database field, enter the name of the database.In the Server field, enter the network name or IP address of the server that hosts the database, and enter any required Port value and click Submit.

Posted Date:- 2021-11-28 23:43:28

Explain about application, session, client variables and their usage and storage of the variables?

Application Variables :-

Application Variables are used across the application as Global Variables. These are stored in server memory.
1. <!--- To delete all application variables--->
2. <cfset StructClear(Application)>
3. <!--- To delete a particular variable in session --->
4. <cfset StructDelete(Application, "varName")>

Session Variables :-

Session Variables are used across application as Global Variables. These are stored in server Memory. Session variables can store complex variables like structures and arrays. Client variables cannot store complex variables.
1. <!--- To delete all session variables --->
2. <cfset StructClear(Session)>
3. <!--- To delete a particular variable in session --->
4. <cfset StructDelete(Session, "varName")>

Posted Date:- 2021-11-28 23:43:04

Explain the scopes in coldfusion?

The scope of a variable determines a number of properties about the variable, such as its life span, timeout, storage location and where it can be used. ColdFusion variables can be global or local, so accordingly the scopes are either persistent or non-persistent.

Posted Date:- 2021-11-28 23:42:12

Explain the differences between Coldfusion versions and features in the latest version? What is the latest version?

Before CF6 MX coldfusion was implemented in Microsoft Visual C++.

Coldfusion was rebuild by using JAVA EE platform.

- Addition of the Coldfusion Gateways
- Support for the MAC OS

Coldfusion 8
- Few tags have been added and enhanced

Coldfusion 9
- ORM like hibernate in JAVA
- Server.CFC file with onServerStart () and onServerEnd() methods

Coldfusion 10 (Zeus)
- Enhencements in Scheduler, webservices ,Security,HTML5,ORM features

Coldfusion 11 (Splendor)
- Mobile development and chart engine changes using Zing Chart previously it was using webChart engine for chart generation

ColdFusion 2016 (Raijin)

* Command Line Interface (CLI)
* PDF generation enhancements
* Security enhancements
* External session storage (Redis)
* Swagger document generation
* NTLM support
* API Manager

ColdFusion 2018 (Aether)

* Asynchronous programming, using Futures
* Command line REPL
* Auto lockdown capability
* Distributed cache support (Redis, memcached, JCS)
* REST playground capability
* Modernized Admin UI
* Performance Monitoring Toolset

Posted Date:- 2021-11-28 23:41:54

When we have Application.cfm in root and child folders. Which one will be given preference?

When we have Application.cfm in root and child folders, root folder one will be given priority.

Posted Date:- 2021-11-28 23:39:54

What is Application.cfc?

Application.cfc and .cfc files are first introduced in CF MX 7.

Application.cfc is similar to Application.cfm which is used to set application management, session management,client management.

Application.cfm loads on top of every page, where as Application.cfc is executed function wise like


So Performance wise Application.cfc is better than Application.cfm.

When there is Application.cfm and Application.cfc then Application.cfc is given preference.

Posted Date:- 2021-11-28 23:38:10

What is Application.cfm?

Application.cfm is used to define the Application Management, Session Management, Client Management, Error Handling, Logging the errors to particular Log Files.

Application.cfm is used to set the application time out, session time out, client timeout etc.

We can have multiple Application.cfm files, Application.cfm that is in root folder will give first priority.

Posted Date:- 2021-11-28 23:36:54

Explain how to do mail settings, debugging settings and schedulers?

Mail Settings :-

In the ColdFusion Administrator, select Server Settings > Mail. In the Mail Server box, enter the name or IP address of your SMTP mail server. (Optional) Change the Server Port and Connection Timeout default settings. Select the Verify Mail Server Connection option to make sure ColdFusion can access your mail server.

Reference Link :-

Debugging Settings :-

Before you can use the Debugger, enable debugging in the ColdFusion Administrator.

. In the ColdFusion Administrator, select Debugging & Logging > Debugger Settings.
. Enable the Allow Line Debugging option.
. Specify the port to use for debugging if different from the default that appears.
. Specify the maximum number of simultaneous debug session if different from the default.
. Click Submit Changes.

Reference Link :-

Schedulers :-

We can Schedule a task from server settings -> Schedulers.

Reference Link :-

Posted Date:- 2021-11-28 23:36:30

Explain about ColdFusion administrator?

ColdFusion administrator is a web based application just like the Cpanel this has many sub options through which you can control many functions such as data sources, global server settings, debugging settings, Mail Settings, Sanabox Secuirty, Database Settings, Schedulers and application security settings. If you are having multiple administrator services then password must be provided for all those services. Also multiple user instances are provided where by a server can be split into cluster of Coldfusion administrators where a specific work can be provided to a specific individual who cannot alter changes.

Posted Date:- 2021-11-28 23:35:30

Explain coldfusion Architecture?

When a request comes to browser contacts webserver through HTTP, Webserver checks whether it is a normal html request or any other extension.

If it is normal html it will reply directly to web browser and display output,
If it is cfm extension webserver requests Application Server to check through TCP/IP.

Application Server Contacts Database through JDBC or FileSystem or Mail Server based on the requirement and pulls the data and send back to webserver.

Webserver Displays the Data on the Browser to user.

Posted Date:- 2021-11-28 23:35:14

What are the advantages of ColdFusion?

ColdFusion is RAD(Rapid Application Development) Environment to develop the applications in faster phase than other technologies.

ColdFusion in PlatForm Independent. It runs on all operating systems

ColdFusion is Database Independent. It supports to all databases.

ColdFusion is Easy to learn and develop as it is a tag based language.

Posted Date:- 2021-11-28 23:34:51

What is ColdFusion and Explain the history of ColdFusion?

ColdFusion is a platform like other technologies java and .net. It has multiple components like CFML(ColdFusion Markup Language) Programming Language, ColdFusion Administrator, CF Chart Engine, ColdFusion Application Server etc.

ColdFusion is a commercial rapid web-application development computing platform created by J. J. Allaire in 1995. (The programming language used with that platform is also commonly called ColdFusion, though is more accurately known as CFML.) ColdFusion was originally designed to make it easier to connect simple HTML pages to a database. By version 2 (1996), it became a full platform that included an IDE in addition to a full scripting language. Latest Version is Coldfusion 2018.

Posted Date:- 2021-11-28 23:34:27

R4R Team
R4R provides ColdBox Freshers questions and answers (ColdBox Interview Questions and Answers) .The questions on website is done by expert team! Mock Tests and Practice Papers for prepare yourself.. Mock Tests, Practice Papers,ColdBox Interview Questions for Freshers,ColdBox Freshers & Experienced Interview Questions and Answers,ColdBox Objetive choice questions and answers,ColdBox Multiple choice questions and answers,ColdBox objective, ColdBox questions , ColdBox answers,ColdBox MCQs questions and answers R4r provides Python,General knowledge(GK),Computer,PHP,SQL,Java,JSP,Android,CSS,Hibernate,Servlets,Spring etc Interview tips for Freshers and Experienced for ColdBox fresher interview questions ,ColdBox Experienced interview questions,ColdBox fresher interview questions and answers ,ColdBox Experienced interview questions and answers,tricky ColdBox queries for interview pdf,complex ColdBox for practice with answers,ColdBox for practice with answers You can search job and get offer latters by studing .learn in easy ways .