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 <cfobjectcache action="clear">To Flush cached pages <cfcache action="flush">
|
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 ONGO
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
|
Home 
Webmaster Said:
Thank you.
vipin Said: