Logo F2FInterview

Coldfusion Interview Questions

Q   |   QA

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. 

To Flush cached queries <cfobjectcache action="clear">
To Flush cached pages <cfcache action="flush">

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. 

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 

movie_id 

In order to link this F2FInterview's page as Reference on your website or Blog, click on below text area and pres (CTRL-C) to copy the code in clipboard or right click then copy the following lines after that paste into your website or Blog.

Get Reference Link To This Page: (copy below code by (CTRL-C) and paste into your website or Blog)
HTML Rendering of above code: