300+ [LATEST] Adobe Coldfusion Interview Questions and Answers

Q1. What Is The Difference Between Structure And Array?

In structure one can combine variables of different datatype in to a common data type Whereas arrays are sequentially stored values of the same datatype.

Q2. What Are The Advantages Of Coldfusion 9 Over Older Versions?

ColdFusion 9.0 has many benefits over older versions and to name few they are:
Coldfusion can be used as a service with out writing lines of code, we can get results by using:  CFChart, Cfdocument, CFImage, CFmail, CFPDF and cfpop etc. And also these services can be sandboxed in order to give more security. Adobe AIR database synchronization. New AJAX controls are added. Server manager is a new feature by which from one access point we can manage several admin tasks of various servers. Also ColdFusion 9 allows you to create coldfusion component as a portlet. 

Q3. How Error Handling Is Handled In Coldfusion?

While debugging is mainly used to debug the code and to see run time values. Especially for trouble shooting. How ever, once the programs are in production server, we can not debug, but to avoide users seeing all the error messages when a program unexpectedly failed and throwing errors, we can use error handling methods. TRY and CATCH is the best among them to handle any database related errors.

Here is your actual code…of coldfusion….

Write your message to the user in case of any error.

Q4. How To Upload A File Using Coldfusion?

By using cffile tag, we can upload a file to the server.

A typical cffile syntax is:


Q5. What Is Application.cfm?

When ColdFusion receives a request for an application page, it searches the page’s directory for a file named Application.cfm. If one exists, the Application.cfm code is logically included at the beginning of that application page. If your application runs on a UNIX platform, which is casesensitive, you must spell Application.cfm with an initial capital letter.

Q6. Difference Between Cold Fusion Mx 6 And Cold Fusion Mx 7?

Windows authentication introduced thorough “cfntauthenticate” tag cfcompile utility introduced which used for Sourceless deployment 

  • Administrator API: Change ColdFusion settings programmatically, without logging into the CF Administrator.
  • Gateways: SMS, IM (based on Extensible Messaging and Presence Protocol) gateways introduced 
  • Flash forms , Skinnable XML forms introduced 
  • New report builder introduced

Q7. Difference Between Cold Fusion 5 And Cold Fusion Mx 6?

All versions of ColdFusion prior to 6.0 were written using Microsoft Visual C++. CF MX 6.0 move to the Java­ based architecture. Major things introduced in CFMX (MX ­ Matrix, Code name is NEO ­ hero of Matrix).

I pointed out some of them below:

  • Mac,Linux OS support
  • Flash Remoting ability to code and debug Flash 
  • API was released with an OOP
  • Added Verity Searches

Q8. What Is The Meaning Of Application And Session Time Out And Where Are They Used?

Application Time Out is the duration of the existence of an application, until it times out, if it is not accessed. Session Time Out is the duration of the existence protocols of a session until it times out, if it is not accessed.

Q9. How Can You Create Tab Strip?

Coldfusion introduced easy to use AJAX UI elements. cflayout and cflayoutarea tags used to create tab strips:

I am normal tab content

This tab selected at page load

you can’t see me, bcz I am in disabled tab

U can kill 🙂 (close) me

Q10. What Is Application Server?

A server that exposes business logic to client applications through various protocols including HTTP, HTTPS, IIOS/SSL.

Eg: Sun Java Application server, weblogic server It takes care of important issues like Traction Management, Security, Database Connection Pooling, Clustering, Scalability,session management,load balancing,thread management and Messaging etc. A web server cannot provide these.

Q11. What Is Query In Query?

ColdFusion allows developers to reuse existing queries by running queries against them in memory. This gives you the advantage of being able to avoid the often costly performance hit of going back to the database to manipulate data that the application server has already recently called. A standard statement can be used to call a query variable in memory as though it were simply a table of data in an available data source. Query variables can even be joined, which provides interesting possibilities for joining data from disparate information sources.

Q12. How Can You Connect With Database From Coldfusion?

Database manipulation tags (cfquery, cfstoredproc, cfinsert, cfupdate) have an attribute called datasource which used to identify/connect to a database. Data sources can be defined in CF administrator section.

Q13. How Would You Write A Simple Stored Procedure In Tsql Which Takes A Movie_id And Returns All The Directors Associated With It?

CREATE procedure [dbo].getDirector (
@movie_id INT
SELECT name FROM directors WHERE movie_id = @movie_id

Q14. What Is The Difference Between Absolute And Relative Div Positioning?

Absolute is from the absolute 0,0 position in the top left corner of the browser window. Relative is relative from the positioning of where the div is declared within the html body.

Q15. What Is Wddx? Where All Are Applicable?

For XML to work, both sender and recipient must agree on an XML language, and all data must be well formed according to that language. WDDX is Macromedia’s contribution to the XML community. It is an open­source XML DTD (Document Type Definition) that defines generic data types such as strings, arrays, structures, and recordsets. WDDX is an XML language that defines data not any specific implementation, but raw data itself. This can make data sharing via XML quick and painless (it doesn’t require that an XML language be agreed upon).

Q16. What Is Createobject?

  • CreateObject() is a functional equivalent of the tag.
  • CreateObject() can be used to instantiate CFCs just like  can, but there is one notable difference: 
  • As a function,  CreateObject() can be used in a block (whereas  cannot).

Q17. What Is An Application.cfm Page And Why It Is Used? Is It Mandatory? How Many Application.cfm Pages We Can Use In A Coldfusion Application?

Application.cfm page will be used to define application level variables, for example instead of declaring dsn variable in every query you use, you can define the variable in application.cfm page once and can use that variable in every ColdFusion page you use queries to retrieve data from database. We can definitely use more than one application.cfm pages, however, only the first application.cfm page that the ColdFusion server finds, will be used. Application.cfm page is not mandatory.

Q18. What Is The Difference Between Client And Session Variables?

Session variables can be used to dump complex data structures like arrays and structures.But client variable are used only in case of simple variables.

Q19. What Meaning Has A Coldfusion Component?

Coldfusion component is a basic construction block for making structured, teared or scalable applications, it is made to process black boxes, for tractions and back­end integration.

Q20. What Is Cfobject?

CFC can be instantiated as an object, using the tag.

Q21. What Is Coldfusion?

In computing, ColdFusion is the name of a commercial rapid application development platform invented by Jeremy and JJ Allaire in 199@(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 had become a full platform that included an IDE in addition to a “full” scripting language.

As of 2010, versions of ColdFusion (purchased by Adobe Systems in 2005) include advanced features for enterprise integration and development of rich Internet applications.

Q22. How Can You Set The Client Management?

We can enable & disable client management as well as we can configure How & Where client variables need to be store

  • In the Application.cfc initialization code This.clientmanagement=”True” / “false”

This.clientStorage=”[Ur_datasource_name]” / “registry” / “cookie” 

  • In appliation.cfm using tag attributes clientManagement=”yes” / “no”

clientStorage=”[Ur_datasource_name]” / “registry” / “cookie”

[Ur_datasource_name] ­ Stored in ODBC or native data source. You must create storage repository in the Administrator. registry ­ Stored in the system registry. cookie ­ Stored on client computer in a cookie. Scalable. If client disables cookies in the browser, client variables do not work.

Q23. Explain The Structure Of Cold Fusion?

ColdFusion is implemented on the J2EE. J2EE is a standard, it is not a programming language. J2EE is an implementation of the Java programming language, but includes a number of Application Programming Interfaces (APIs) for connecting to databases, queuing messages, connecting to registries and naming and directory services. All of these APIs are used by coldfusion for many of its base services and other runtime services. 

ColdFusion consists of following components:

  • cf script
  • CFML
  • ColdFusion Administrator
  • Verity Search Server

Q24. What Advantages Has Coldfusion?

The advantages are much easier Installation and Migration, it is compatible with each operating system and database, it has simpler learning process and accelerated development, has permissions to each J2EE library and this part of Adobe family being compatible with Flash, Flex, PDF, etc. 

Q25. What Is Structure? What Are The Different Functions In Structure?

ColdFusion structures consist of key­value pairs. Structures let you build a collection of related variables that are grouped under a single name. A structure’s key must be a string. The values associated with the key can be any valid ColdFusion value or object. It can be a string or integer, or a complex object such as an array or another structure. Because structures can contain any kind of data they provide a very powerful and flexible mechanism for representing complex data. check Structure functions here.

Q26. How Can You Communicate With Web Server (apache Or Iis) From Coldfusion?

Cold Fusion is an example of a Common Gateway Interface application. The Common Gateway Interface is a mechanism to allow Web servers, which are designed to serve static documents, to receive dynamic output from programs and serve it as if it were static data.

  1. When a browser sends a request for a Cold Fusion template to a Web server, several things must happen. First, the Web server recognizes the information from the browser as a request for CGI output. 
  2. If the request was initiated from a form, the server has to write the form field information to some area in storage that is accessible to other programs on the machine. Usually, this is done by using STDOUT data streams. The WinCGI interface, which can be used by WebSite and other servers, writes the form data to INI­style files on disk, which are then opened and read by the CGI application.
  3. The CGI program requests data from the data source, which is returned in step
  4. The CGI program formats the data as HTML output, returning this output to the server in step 
  5. The server receives this output, performs any further server­side processing necessary, and then sends it to the browser.

Cold Fusion defaults to using server API modules instead of CGI to communicate between the Web Server and ColdFusion Application Server.

Q27. What Are The Main Features Of Coldfusion?

ColdFusion has many benefits over other web languages. The very first thing we need to discuss is, ColdFusion is the first web languages that has been developed to build web application (dynamic). After ColdFusion, PHP, and Microsoft’s asp .net were in the market. PHP is free and so many small companies and individual entrepreneurs use it. So php is widely used compared to others because it is free. Microsoft’s asp .net is next to it for mid to big size organizations as it give good support and of course the brand name also does the magic. ColdFusion though it is the first language from the rest, because of lack of publicity and cost, it is still not widely used. But below are the main benefits of ColdFusion over others. It is very easy to install and very easy to migrate from older version to new version. It does support all operating systems. It is very easy to learn because of its self explanatory code/tags.

Easy integration to other adobe products such as flex, adobe pdf, flash etc.. Good database support and works for all protocols.

Q28. Can We Have More Than Data Source Within Cftraction?

No.Datasource Names For All The Database Tags Within CFTRANSACTION Must Be The Same. The workaround for the problem of CFTRANSACTION with different data source, Use same datasource in CFQUERY but inside the cfquery prefix the table with desired database in the query.


SELECT * FROM other.dbo.TableName

Q29. Are We Able To Communicate From Coldfusion To An Apache Or Iis Server?

Coldfusion is like a Common Gateway Interface Application. This me it works like a mechanism that enables dynamic output to be received by web servers. Usually web servers use static data and now the dynamic data will be seen as static.

  • when a request is trmitted by the browser to a web server for the purpose of getting a Coldfusion template the server will see the data sent by the browser as a CGI output request.
  • in the case in which forms are used to initiate requests the data from the form will be stored by the server in a place where other programs may find it.To do this we often use STDOUT data streams. The form information will be written to the INI type of files by the WinCGI interface, it will become available for the CGI application for reading.
  • the data is requested by the CGI program and returned in step.
  • the data is formatted by the CGI program and return in step.
  • the output is received by the server which makes the next server side processing that is required and then it is sent to the browser. Normally Coldfusion uses server API modules for server to server communication.

Q30. What Is The Meaning Of Onrequestend.cfm And When Is The Execution Made?

The OnRequestEnd.cfm page is processed after every page in the application, in the same way like Application.cfm performing prior to the application page code. OnRequestEnd.cfm and Application.cfm pages have to exist in the same directory that is used by Coldfusion for the present page. Only that directory isbeing searched.

Q31. What Are The Advantages Of Cold Fusion?

  • Simplified Installation and Migration
  • All Operating System (OS) Support All Database support
  • Faster Development & Easy to Learn
  • Improved & support for all Protocols
  • access to all the J2EE libraries
  • Integration with Other adobe Products (Flex, Flash, PDF..)

Q32. What Is Flash Form?

Flash form is a form like ordinary HTML form, with flash format which run on flash player enabled browsers. Using cfform tag CF automatically generates the swf format form’s Flash binary from your CFML code. Flash Forms can be used to create a better forms experience for your users. These features include accordion­style and multiple­tab form panes and automatic element positioning. You can also display cftree, cfgrid, and cfcalendar form elements as Flash

Q33. What Is Cookie Variables?

Cookies are server specific simply stored variables stored in files in the browser’s file system. It used to track state

Q34. Compare Cold Fusion With Other Programming Languages?

For every language has its pros and cons. Q5 is wer for this also, But I will point out one or 2 advantages of CF over other languages.

  • vs PHP : Ajax features, Integration with adobe products, community support, J2EE
  • vs Java : Easy to learn, Code developmet & maintence cost
  • vs .NET : All OS, Most of webserver Support

Q35. What Are The Important Components Of Application.cfm Page?

Name, clientStorage, LoginStorage, ClientManagement, ApplicationTimeout, SetclientCcookies, SessionTimeout etc.. 

Q36. What Are The Main Components Of Coldfusion?

ColdFusion have the following main components:

  • ColdFusion admin
  • CFML (ColdFusion markup language)
  • CF script
  • Variety search

Q37. What Is Query Of Queries? What Is The Use Of Query Of Queries?

Coldfusion has a beautiful feature called Query of Queries which is mainly used for improving performance of the application. Query of Queries is the result of an existing database query result.This will be done by using coldfusion “cfquery” tag and need to
specify dbtype = ‘query’.

select *
from NameOfAnotherQuery
where ColumnName = ‘SomeValue’

Q38. Can You Explain Get File & Put File ?

(coldfusion FTP ­ ) : By using coldfusion tag, we can send data from local computer to the server and also retrieve the data from server to the local computer. By using Get file, we can retrieve data from server:

By usingPut file, we can send data to the server:


Q39. How To You Debug A Coldfusion Program?

Coldfusion provides us many debugging options in order to trouble shoot a coldfusion program.

The important are:

On the debugging settings in coldfusion administrator. (you will see the lengthy debugging information at the bottom of the coldfusion result).

Q40. What Is The Working Process For Application.cfm?

Yes. If the application page directory does not have an Application.cfm page, ColdFusion searches up the directory tree until it finds an Application.cfm page. If several directories in the directory tree have an Application.cfm page, ColdFusion uses the first page it finds. If the Application.cfm page is present in the directory tree (and has the required permissions set), you cannot prevent ColdFusion from including it.

ColdFusion processes only one Application.cfm page for each request. If a ColdFusion page has a cfinclude tag pointing to an additional ColdFusion page, ColdFusion does not search for an Application.cfm page when it includes the additional page.

Q41. How Are Stored Procedures And Calling Sql Inline Different In Coldfusion Regarding Advantages And Disadvantages?

Stored procedures give the best performance when it comes to putting application logic to the database side. They have the disadvantage of slowing down the performance and the development if their code is weak.

Q42. What Is Cfscheduler?

It provides a programmatic interface to the ColdFusion scheduling engine. It can run a CFML page at scheduled intervals, with the option to write the page output to a static HTML page. This feature enables you to schedule pages that publish data, such as reports, without waiting while a database traction is performed to populate the page.

Q43. What Are The Advantages And Disadvantages Of Using Stored Procedures Versus Calling Sql Inline In Cold Fusion?

Stored procedures abstract database logic from server side code. They also offer performance benefits in pushing application logic to the database side. The disadvantage is that if they are poorly written then they can hinder database performance and make development a little more obfuscated.

Q44. What Are Session Timeout And Application Timeout? Where We Have To Do This Process?

ApplicationTimeout : The time span an application will exist before it times out (if the application is not accessed in any way). This defaults to the value set in the ColdFusion administrator.
SessionTimeout : The time span a session will exist before it times out (if the application is not access in any way by that session’s user). This defaults to the value set in the ColdFusion administrator.

Q45. How Can You Call The External Exe Files?

using cfexecute tag, we can call the external exe files.Below example executes the Windows NT version of the netstat network monitoring program, and places its output in a file.

arguments = “­e”
outputFile = “C:Tempoutput.txt”
timeout = “1”>

Q46. How Can You Clear The Cache?

To Flush cached queries
To Flush cached pages

Q47. What Is Web Server?

A computer that delivers (serves up) Web pages. Every Web server has an IP address and possibly a domain name. For example, if you enter the URL http://www.domainname.com/index.html in your browser, this sends a request to the server whose domain name is domainname.com. The server then fetches the page named index.html and sends it to your browser. Any computer can be turned into a Web server by installing server software and connecting the machine to the Internet. There are many Web server software applications, including public domain software from NCSA and Apache, and commercial packages from Microsoft, Netscape and others.

Q48. What Is Cftraction?

For enterprise database management systems that support traction processing, instructs the database management system to treat multiple database operations as a single traction. It provides database commit and rollback processing. See the documentation for your database management system to determine whether it supports SQL traction processing.
isolation = “read_uncommitted|read_committed|repeatable_read”
savepoint = “savepoint name”>

Q49. What Is The Architecture Of Coldfusion?

Presentation server (presentation layer), Application server, Web server and a database server. It has a J2ee web container that is the base of ColdFusion environment. And a ColdFusion runtime environment that will interprets the ColdFusion requests, and a database server.

Q50. Why Is Coldfusion Mx6 Different Than Coldfusion 5?

The versions of Coldfusion older than 6 where developed with Microsoft Visual C++, version 6 is based on a Java type of construction. MX me Matrix, in this version the most important things implemented are: support for Linux and Mac, OOP, Verity Searches.