Showing posts with label database. Show all posts
Showing posts with label database. Show all posts

Friday, March 25, 2011

ColdFusion Interview Question Part 3

1. What is cold fusion component roles implementation?
Cold fusion component roles implementation allows users to log into their role based administrator support function and not any other function. If a user tries to enter into other functions an error is thrown. These roles and components are taken by the Cold fusion. These roles and functions are transmitted through action script which allows the users to work on their components.
 
2. How can you create dynamic query?
  • Dynamic SQL is a SQL code that your program generates using variables before the SQL is executed.
  • In coldfusion, CFQUERY give full provision to write all conditional logic & looping to derive the dynamic sql statement to execute.
  • You can use dynamic SQL to accomplish tasks such as adding WHERE clauses to a search based on the fields that the user filled out on a search criteria page.
3. State and explain about integrating Coldfusion applications with JSP.
A cold fusion page can contain JSP or a servlet and a JSP page can contain Coldfusion applications. This facilitates easy access to build hybrid functions and applications which can combine coldfusion components and servlets.

4. Explain about enterprise manager?
Enterprise manager helps you in admin functions. This will help you to create multiple cf server instances, through which you can experience advanced security, performance, and savings.

5. What are the different types of resources through which cold fusion can communicate?
  • Mobile phones that support SMS
  • XMPP or Lotus IM clients
  • Java sockets
  • Java messaging service
  • Content management systems and file systems
6. 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.
 
7. What is the benefit of extensible gateway architecture?
Developers can benefit from extensible gateways by limitless variety of emerging protocols. Developers can benefit by the creation of event gateways.
 

ColdFusion Interview Question Part 2

1. 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, 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.
 
2. What is CFAbort?
  • Stops the processing of a ColdFusion page at the tag location.
  • ColdFusion returns to the user or calling tag everything that was processed before the cfabort tag.
  • You can optionally specify an error message to display using showError attribute. 
  • The tag is often used with conditional logic to stop processing a page when a condition occurs.
3. What is SaveContent?
  • Used to save the generated content to a variable, including the results of evaluating expressions and executing custom tags.
  •  This tag requires an end tag.
  • Main usage of savcontent is cache partial pages.
4. 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.
5. 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
6. Describe about string encryption?
CFML language provides a 32 bit encryption which is symmetric key based. This function is called as Encrypt. Cold fusion at present uses 32 bit encryption but if your application requires 1024 bit encryption you can happily use that function because cold fusion integrates with third party libraries. Cold fusion also uses Hash function which is very important in safeguarding passwords. They use MD5 and XOR based algorithm.
 
7. Is it possible to write cold fusion in cold fusion?
No it is not possible to write ColdFusion in ColdFusion. Actually ColdFusion was written in Java and to write programs we need to implement other kinds of programs such as Java, .NET etc. These programs are required because ColdFusion alone cannot survive.