Top ColdFusion Interview Questions and Answers

Top ColdFusion Interview Questions and Answers

1. 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

2. 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 case-sensitive, you must spell Application.cfm with an initial capital letter.

3. Can we have multiple Application.cfm file in an Application?

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.

4. 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.

6. How would you format some text using css to be verdana and bold?

.myfontclass {
font-family: Verdana;
font-weight: bold;
}

7. What is the working process for Application.cfm?

If the Application.cfm page is present in the directory tree (and has the required permissions set), you cannot prevent ColdFusion from including it.

8. What is cfapplication tag?

It defines the scope of a ColdFusion application; enables and disables storage of Client variables; specifies the Client variable storage mechanism; enables Session variables; and sets Application variable time-outs.

9. 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

1. In the Application.cfc initialization code
This.clientmanagement=”True” / “false”
This.clientStorage=”[Ur_datasource_name]” / “registry” / “cookie”

2. 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.

10. How can you set the Session Management?

Same as client management description in previous question sessionmanagement variable available, we can use that variable.

11. 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.

12. How can you clear the cache?

To Flush cached queries
To Flush cached pages

13. 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.

14. How would you write a simple stored procedure in TSQL which takes a movie_id and returns all the directors associated with it?

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE procedure [dbo].getDirector (
@movie_id INT
)

SELECT name FROM directors WHERE movie_id = @movie_id

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

15. If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the LEFT JOIN query?

movie_id

16. How would you write a LEFT JOIN statement to return a result set of movie.title’s and director.name’s?

SELECT
movie.title,
director.name
FROM movie LEFT JOIN director ON movie.id = director.movie_id

18. 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

19. 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.

20. 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 Transaction Management, Security, Database Connection Pooling, Clustering, Scalability,session management,load balancing,thread management and Messaging etc. A web server cannot provide these.

21. 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.

22. 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..)

23. Compare Cold fusion with other programming languages?

For every language has its pros and cons. Q5 is answer 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

24. 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