Top 50 Adobe Coldfusion Interview Questions
Q1. What Is The Difference Between Structure And Array?
In structure one can combine variables of various datatype in to a not unusual facts kind Whereas arrays are sequentially stored values of the identical datatype.
Q2. What Are The Advantages Of Coldfusion 9 Over Older Versions?
ColdFusion 9.0 has many blessings over older variations and to name few they're:
Coldfusion can be used as a provider with out writing strains of code, we will get results via using: CFChart, Cfdocument, CFImage, CFmail, CFPDF and cfpop and many others. And also these services can be sandboxed if you want to give extra protection. Adobe AIR database synchronization. New AJAX controls are delivered. Server manager is a brand new function by which from one get admission to factor we will control numerous admin responsibilities of diverse servers. Also ColdFusion nine allows you to create coldfusion component as a portlet.
Q3. How Error Handling Is Handled In Coldfusion?
While debugging is specifically used to debug the code and to peer run time values. Especially for trouble shooting. How ever, as soon as the applications are in production server, we cannot debug, however to avoide customers seeing all the mistake messages whilst a application all at once failed and throwing mistakes, we will use errors handling methods. TRY and CATCH is the first-rate amongst them to deal with any database associated mistakes.
<cftry>
Here is your actual code…of coldfusion….
</cfcatch>
Write your message to the consumer in case of any errors.
</cfcatch>
</cftry>
Q4. How To Upload A File Using Coldfusion?
By the use of cffile tag, we are able to upload a file to the server.
A typical cffile syntax is:
<cffile action="upload"
fileField="fileUpload"
destination="C:docs">
Q5. What Is Application.Cfm?
When ColdFusion gets a request for an software web page, it searches the web page's directory for a document named Application.Cfm. If one exists, the Application.Cfm code is logically covered at the start of that utility page. If your utility runs on a UNIX platform, that's casesensitive, you should spell Application.Cfm with an initial capital letter.
Q6. Difference Between Cold Fusion Mx 6 And Cold Fusion Mx 7?
Windows authentication added thorough "cfntauthenticate" tag cfcompile application introduced which used for Sourceless deployment
Administrator API: Change ColdFusion settings programmatically, with out logging into the CF Administrator.
Gateways: SMS, IM (based totally on Extensible Messaging and Presence Protocol) gateways delivered
Flash bureaucracy , Skinnable XML paperwork delivered
New report builder introduced
Q7. Difference Between Cold Fusion 5 And Cold Fusion Mx 6?
All versions of ColdFusion prior to six.0 were written the use of Microsoft Visual C++. CF MX 6.0 circulate to the Java based structure. Major matters brought in CFMX (MX Matrix, Code call is NEO hero of Matrix).
I mentioned a number of them underneath:
Mac,Linux OS guide
Flash Remoting potential to code and debug Flash
API changed into launched 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 length of the lifestyles of an software, until it instances out, if it isn't accessed. Session Time Out is the period of the lifestyles protocols of a consultation till it instances out, if it isn't always accessed.
Q9. How Can You Create Tab Strip?
Coldfusion brought clean to use AJAX UI elements. Cflayout and cflayoutarea tags used to create tab strips:
<cflayout type="tab">
<cflayoutarea title="Tab 1">
I am regular tab content material
</cflayoutarea>
<cflayoutarea title="Tab 2" selected="true">
This tab decided on at page load
</cflayoutarea>
<cflayoutarea title="Tab 3" disabled="true">
you can not see me, bcz I am in disabled tab
</cflayoutarea>
<cflayoutarea title="Tab 4" closable="true">
U can kill :) (near) me
</cflayoutarea>
</cflayout>
Q10. What Is Application Server?
A server that exposes commercial enterprise logic to patron programs via numerous protocols such as HTTP, HTTPS, IIOS/SSL.
Eg: Sun Java Application server, weblogic server It looks after critical troubles like Traction Management, Security, Database Connection Pooling, Clustering, Scalability,consultation control,load balancing,thread management and Messaging and so forth. A net server can't offer these.
Q11. What Is Query In Query?
ColdFusion permits builders to reuse existing queries by strolling queries in opposition to them in reminiscence. This gives you the benefit of being capable of avoid the regularly steeply-priced overall performance hit of going back to the database to govern information that the utility server has already recently called. A wellknown <cfquery> statement may be used to name a query variable in memory as though it have been genuinely a table of data in an available information source. Query variables can even be joined, which provides interesting possibilities for joining records from disparate data sources.
Q12. How Can You Connect With Database From Coldfusion?
Database manipulation tags (cfquery, cfstoredproc, cfinsert, cfupdate) have an characteristic referred to as datasource which used to pick out/connect with a database. Data sources may be defined in CF administrator segment.
Q13. 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 system [dbo].GetDirector (
@movie_id INT
)
SELECT call FROM directors WHERE movie_id = @movie_id
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Q14. What Is The Difference Between Absolute And Relative Div Positioning?
Absolute is from absolutely the zero,0 function inside the top left corner of the browser window. Relative is relative from the site of where the div is declared in the html frame.
Q15. What Is Wddx? Where All Are Applicable?
For XML to paintings, both sender and recipient must agree on an XML language, and all information must be nicely fashioned according to that language. WDDX is Macromedia's contribution to the XML community. It is an opensource XML DTD (Document Type Definition) that defines established statistics kinds such as strings, arrays, structures, and recordsets. WDDX is an XML language that defines records no longer any unique implementation, but raw facts itself. This could make records sharing through 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() may be used to instantiate CFCs similar to can, but there's one fantastic difference:
As a function, CreateObject() can be used in a block (whereas can't).
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 can be used to outline software stage variables, as an instance as opposed to affirming dsn variable in every query you use, you may define the variable in software.Cfm page once and can use that variable in every ColdFusion web page you operate queries to retrieve information from database. We can clearly use more than one application.Cfm pages, but, handiest the primary application.Cfm web 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 unload complicated data structures like arrays and structures.But client variable are used most effective in case of easy variables.
Q19. What Meaning Has A Coldfusion Component?
Coldfusion element is a simple construction block for making established, teared or scalable applications, it's miles made to procedure black packing containers, for tractions and againcease integration.
Q20. What Is Cfobject?
CFC can be instantiated as an object, the use of the <cfobject> tag.
Q21. What Is Coldfusion?
In computing, ColdFusion is the call of a business fast application development platform invented by using Jeremy and JJ Allaire in 199@(The programming language used with that platform is likewise generally referred to as ColdFusion, even though is greater appropriately called CFML.) ColdFusion was initially designed to make it simpler to connect easy HTML pages to a database, through model 2 (1996) it had grow to be a complete platform that included an IDE further to a "complete" scripting language.
As of 2010, versions of ColdFusion (purchased by way of Adobe Systems in 2005) encompass superior features for company integration and development of rich Internet applications.
Q22. How Can You Set The Client Management?
We can permit & disable purchaser control as well as we can configure How & Where consumer variables need to be shop
In the Application.Cfc initialization code This.Clientmanagement="True" / "fake"
This.ClientStorage="[Ur_datasource_name]" / "registry" / "cookie"
In appliation.Cfm the usage of tag attributes clientManagement="yes" / "no"
clientStorage="[Ur_datasource_name]" / "registry" / "cookie"
[Ur_datasource_name] Stored in ODBC or local statistics source. You ought to create storage repository inside the Administrator. Registry Stored inside the device registry. Cookie Stored on purchaser computer in a cookie. Scalable. If customer disables cookies within the browser, client variables do no longer paintings.
Q23. Explain The Structure Of Cold Fusion?
ColdFusion is carried out at the J2EE. J2EE is a widespread, it isn't always a programming language. J2EE is an implementation of the Java programming language, however 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 utilized by coldfusion for a lot of its base offerings and other runtime offerings.
ColdFusion consists of following additives:
cf script
CFML
ColdFusion Administrator
Verity Search Server
Q24. What Advantages Has Coldfusion?
The advantages are a great deal less difficult Installation and Migration, it is like minded with every working gadget and database, it has less complicated gaining knowledge of technique and extended improvement, has permissions to every J2EE library and this a part of Adobe circle of relatives being like minded with Flash, Flex, PDF, and many others.
Q25. What Is Structure? What Are The Different Functions In Structure?
ColdFusion structures include keyfee pairs. Structures permit you to construct a collection of related variables which can be grouped below a unmarried name. A shape's key have to be a string. The values associated with the key may be any legitimate ColdFusion cost or item. It can be a string or integer, or a complex item which include an array or another structure. Because structures can include any sort of information they offer a totally effective and bendy mechanism for representing complicated facts. Check Structure capabilities here.
Q26. How Can You Communicate With Web Server (apache Or Iis) From Coldfusion?
Cold Fusion is an example of a Common Gateway Interface utility. The Common Gateway Interface is a mechanism to allow Web servers, that are designed to serve static documents, to obtain dynamic output from applications and serve it as though it have been static information.
When a browser sends a request for a Cold Fusion template to a Web server, numerous matters must show up. First, the Web server acknowledges the data from the browser as a request for CGI output.
If the request turned into initiated from a form, the server has to put in writing the shape area facts to some place in storage that is on hand to other packages at the machine. Usually, this is carried out by using the use of STDOUT records streams. The WinCGI interface, which can be used by WebSite and different servers, writes the form information to INIstyle documents on disk, which can be then opened and study via the CGI software.
The CGI software requests information from the statistics source, which is again in step
The CGI software codecs the information as HTML output, returning this output to the server in step
The server receives this output, plays any similarly serverfacet processing necessary, after which sends it to the browser.
Cold Fusion defaults to using server API modules as opposed to CGI to communicate between the Web Server and ColdFusion Application Server.
Q27. What Are The Main Features Of Coldfusion?
ColdFusion has many blessings over other net languages. The first actual issue we need to discuss is, ColdFusion is the first internet languages that has been advanced to build internet utility (dynamic). After ColdFusion, PHP, and Microsoft’s asp .Net had been within the market. PHP is loose and so many small businesses and person entrepreneurs use it. So personal home page is broadly used in comparison to others because it's miles unfastened. Microsoft’s asp .Net is subsequent to it for mid to massive length companies because it give properly aid and of course the brand call also does the magic. ColdFusion although it is the first language from the rest, because of loss of exposure and value, it is nevertheless no longer broadly used. But below are the principle advantages of ColdFusion over others. It could be very clean to install and really smooth to migrate from older version to new edition. It does aid all working structures. It may be very easy to examine due to its self explanatory code/tags.
Easy integration to other adobe products such as flex, adobe pdf, flash and so on.. Good database assist 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 hassle of CFTRANSACTION with one of a kind information source, Use identical datasource in CFQUERY however within the cfquery prefix the table with preferred database in the query.
<CFTRANSACTION>
<cfquery datasource=same>
SELECT * FROM TableName
</cfquery>
<cfquery datasource=same>
SELECT * FROM different.Dbo.TableName
</cfquery>
</CFTRANSACTION>
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 permits dynamic output to be acquired by way of internet servers. Usually internet servers use static information and now the dynamic statistics can be seen as static.
Whilst a request is trmitted through the browser to a web server for the reason of getting a Coldfusion template the server will see the records sent by the browser as a CGI output request.
Within the case in which forms are used to provoke requests the data from the shape can be saved by using the server in an area wherein other packages may discover it.To do this we often use STDOUT records streams. The shape facts might be written to the INI type of files by the WinCGI interface, it turns into to be had for the CGI software for analyzing.
The statistics is requested by way of the CGI software and back in step.
The facts is formatted by way of the CGI program and return in step.
The output is obtained through the server which makes the next server facet processing that is required and then it's far despatched 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 each page inside the application, within the equal way like Application.Cfm acting previous to the software page code. OnRequestEnd.Cfm and Application.Cfm pages should exist inside the equal listing that is used by Coldfusion for the present web page. Only that listing isbeing searched.
Q31. What Are The Advantages Of Cold Fusion?
Simplified Installation and Migration
All Operating System (OS) Support All Database guide
Faster Development & Easy to Learn
Improved & assist for all Protocols
get admission to to all of the J2EE libraries
Integration with Other adobe Products (Flex, Flash, PDF..)
Q32. What Is Flash Form?
Flash form is a form like normal HTML form, with flash format which run on flash participant enabled browsers. Using cfform tag CF routinely generates the swf format form's Flash binary out of your CFML code. Flash Forms can be used to create a higher forms enjoy to your users. These capabilities include accordionstyle and a couple oftab form panes and automated detail positioning. You also can show cftree, cfgrid, and cfcalendar form elements as Flash
Q33. What Is Cookie Variables?
Cookies are server specific honestly saved variables saved in files inside the browser's file machine. It used to song nation
Q34. Compare Cold Fusion With Other Programming Languages?
For every language has its pros and cons. Q5 is wer for this additionally, But I will factor out one or 2 benefits of CF over other languages.
Vs PHP : Ajax capabilities, Integration with adobe products, community guide, J2EE
vs Java : Easy to study, Code developmet & maintence fee
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 fundamental components:
ColdFusion admin
CFML (ColdFusion markup language)
CF script
Variety seek
Q37. What Is Query Of Queries? What Is The Use Of Query Of Queries?
Coldfusion has a lovely function referred to as Query of Queries which is specially used for enhancing overall performance of the software. Query of Queries is the end result of an present database query end result.This will be carried out via the usage of coldfusion “cfquery” tag and need to
specify dbtype = ‘query’.
Eg:
pick out *
from NameOfAnotherQuery
where ColumnName = 'SomeValue'
Q38. Can You Explain Get File & Put File ?
(coldfusion FTP <cfftp>) : By using coldfusion <cfftp> tag, we can send records from nearby pc to the server and also retrieve the records from server to the local computer. By the usage of Get document, we are able to retrieve records from server:
<cfftp
action="getFile"
server="127.0.0.1"
username="user1"
password="pass1"
remotefile="/abcd.Jpeg"
localfile="C:examples/efgh.Jpg"
failIfExists="no">
By usingPut report, we can ship information to the server:
<cfftp action="putFile"
server="127.0.0.1"
username="user1"
password="pass1"
localfile="C:examples/efgh.Jpg"
remotefile="/abcd.Jpeg"
failIfExists="no">
Q39. How To You Debug A Coldfusion Program?
Coldfusion affords us many debugging alternatives with the intention to trouble shoot a coldfusion software.
The critical are:
CFDUMP, eg: <cfdump var="#abcd#">
CFABORT, eg: <cfabort>
On the debugging settings in coldfusion administrator. (you will see the prolonged debugging information at the lowest of the coldfusion result).
Q40. What Is The Working Process For Application.Cfm?
Yes. If the application web page listing does no longer have an Application.Cfm page, ColdFusion searches up the directory tree until it finds an Application.Cfm page. If several directories inside the listing tree have an Application.Cfm page, ColdFusion makes use of the primary web page it unearths. If the Application.Cfm web page is gift within the directory tree (and has the desired permissions set), you can't save you ColdFusion from together with it.
ColdFusion methods most effective one Application.Cfm page for each request. If a ColdFusion page has a cfinclude tag pointing to an extra ColdFusion web page, ColdFusion does no longer search for an Application.Cfm page when it includes the additional web page.
Q41. How Are Stored Procedures And Calling Sql Inline Different In Coldfusion Regarding Advantages And Disadvantages?
Stored procedures provide the quality overall performance when it comes to setting utility logic to the database side. They have the drawback of slowing down the performance and the improvement if their code is vulnerable.
Q42. What Is Cfscheduler?
It presents a programmatic interface to the ColdFusion scheduling engine. It can run a CFML web page at scheduled intervals, with the option to write the page output to a static HTML page. This characteristic enables you to time table pages that put up facts, along with reviews, without ready at the same time as a database traction is performed to populate the web page.
Q43. What Are The Advantages And Disadvantages Of Using Stored Procedures Versus Calling Sql Inline In Cold Fusion?
Stored techniques summary database good judgment from server side code. They additionally provide performance advantages in pushing utility common sense to the database aspect. The disadvantage is that if they're poorly written then they could avoid database overall performance and make development a bit extra obfuscated.
Q44. What Are Session Timeout And Application Timeout? Where We Have To Do This Process?
ApplicationTimeout : The time span an utility will exist before it instances out (if the utility isn't always accessed in any manner). This defaults to the fee set within the ColdFusion administrator.
SessionTimeout : The time span a consultation will exist before it times out (if the application is not access in any way with the aid of that consultation's consumer). This defaults to the price set inside the ColdFusion administrator.
Q45. How Can You Call The External Exe Files?
The usage of cfexecute tag, we will name the external exe files.Below instance executes the Windows NT version of the netstat network tracking program, and locations its output in a report.
<cfexecute name = "C:WinNTSystem32netstat.Exe"
arguments = "e"
outputFile = "C:Tempoutput.Txt"
timeout = "1">
</cfexecute>
Q46. How Can You Clear The Cache?
To Flush cached queries <cfobjectcache action="clear">
To Flush cached pages <cfcache action="flush">
Q47. What Is Web Server?
A pc that grants (serves up) Web pages. Every Web server has an IP address and in all likelihood a website name. For example, in case you enter the URL http://www.Domainname.Com/index.Html to 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 for your browser. Any computer may be turned into a Web server via putting in server software program and connecting the gadget to the Internet. There are many Web server software program applications, including public domain software program from NCSA and Apache, and business packages from Microsoft, Netscape and others.
Q48. What Is Cftraction?
For business enterprise database management systems that help traction processing, instructs the database control device to deal with more than one database operations as a unmarried traction. It presents database commit and rollback processing. See the documentation in your database management machine to determine whether it supportsrepeatable_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 net box this is the base of ColdFusion surroundings. And a ColdFusion runtime surroundings in order to translates the ColdFusion requests, and a database server.
Q50. Why Is Coldfusion Mx6 Different Than Coldfusion five?
The versions of Coldfusion older than 6 in which developed with Microsoft Visual C++, version 6 is based totally on a Java kind of construction. MX me Matrix, on this model the maximum important matters applied are: support for Linux and Mac, OOP, Verity Searches.
