41.What is the difference between CFQUERY and CFSTOREDPROC tags? When should we use them?

Both the tags have their own context to use them.

CFQUERY tag is used to pass queries or SQL statements to a data source.
It is used to create dynamic queries.
cfqueryparam tag is used to validate parameters to avoid the SQL injection attack.

CFSTOREDPROC is used to execute stored procedure and cfprocparam to validate parameters but with
Cfprocresult tag can be used to accept multiple resultset return from database.

CFSTOREPROC will give the better performance whether it noticeable will be depends on your query and
Databse.

42.What is CFINSERT and CFUPDATE?

Inserts/Updates records in data sources from data in a ColdFusion form or form Scope.

43.What is CFDBINFO tag?

This tag retrieves information about a data source, including details about the database, tables, queries, procedures, foreign keys, indexes, and version information about the database, driver, and JDBC.

44.What is query of query in coldfusion?

A query that retrieves data from a record set is called a Query of Queries.You just need to mention dbtype = “query” in cfquery tag to do QoQ.

45.What are event gateways in coldfusion?

ColdFusion event gateways are ColdFusion elements that let ColdFusion react to or generate external events or messages in an asynchronous manner.

46.What is fusebox?

Fusebox is a framework for building web applications. It is meant to make your applications easier to create and maintain
A Fusebox application is made up of Circuits. A Circuit corresponds to a directory in your application.
Within each circuit are one or more Fuseactions. A Fuseaction is a request handler.
And finally, a Fuseaction does its work by executing one or more Fuses.
Fuses are individual CFML templates such as display files.
The framework uses XML configuration files to define the application settings as well as declaring what each Circuit does and how Fuseactions within each Circuit execute.
There is a core set of XML grammar that is used to create these files.
The framework is fully extensible via plugins.
Fusebox does not force the Model-View-Controller (MVC) pattern or Object-Oriented Programming (OOP) on the developer. However, either or both of these development approaches can be used with Fusebox.

47.Which is efficient isDefined() or structKeyExists()? Why?

These days (CF8+) the difference in speed is not that great. However, structKeyExists is indeed a little faster. Here's why.
When you use isDefined, the string you pass in is searched for as a key name in several scopes. As of CF9, the list of scopes.

• Local (function local, UDFs and CFCs only)
• Arguments
• Thread local (inside threads only)
• Query (not a true scope, applies for variables within query loops)
• Thread
• Variables
• CGI
• CFFile
• URL
• Form
• Cookie
• Client

48.What are CFFILE tag actions?

Manages interactions with server files. Following are the actions of the cffile tag:

• Append
• Copy
• Delete
• Move
• Read
• Readbinary
• Rename
• Upload
• Uploadall
• Write

49.What are the different actions in CFPDF tag?