ColdFusion MX 7
A code has to be generated by using 'PageCode' and 'ProductCode,' whose numeric values are derived from a database: <cfset ArPage=ArrayNew(1)> <cfset ProductCode = #PCode#> <cfset ClassCode = #CCo...
A coldfusion list is defined as follows: <cfset list1="24,25,26,27,"> <cfset list2="24,,25,26,27"> <cfset list3="24,,,,25,26,27,"> <cfset list4="24,25,,26,,27,,"> What will you get on printing "l...
A company has the following departments: Marketing, Designing, Production, Packing What will the following query return? <cfquery name="GetDeptData" datasource="myDSN"> select * from departments...
An admin(role-type) function(ChkBalance) has to be created for printing the account balance of all the users. Which of the following ways helps one do this?
Consider the following <cfquery> tag: <cfquery name="GetTableData" datasource="myDSN"> SELECT * FROM myTable </cfquery> Which condition should the WHERE clause contain so that only those rows ar...
Evaluate the following SQL statement: <cfquery name="GetEmpData" datasource="myDSN"> SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VA...
Examine the code given below: <cfquery name="GetEmpData" datasource="myDSN"> SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 </cfquery> Which of the following statemen...
Examine the data in the EMPLOYEES table given below: LAST_NAME DEPTARTMENT_ID SALARY ALLEN 10 3000 MILLER 20 1500 King 20...
How do you decrypt text that has been encrypted using the hash function?
How will you test whether a cookie has already been set on the clients browser?
If the following code is inserted into your website, when will the cookies expire? <CFCOOKIE NAME="CFID" VALUE="#Session.CFID#"> <CFCOOKIE NAME="CFTOKEN" VALUE="#Session.CFTOKEN#">
Query of Queries cannot be performed on cfassociate.
The <cfhttp> tag can have multiple <cfhttpparam> tags, subject to certain limitations. Which are these limitations?
The emp_data table has following values for its department field: marketing, production, production, sales, NULL, NULL, Marketing, Null What will the following query return: <cfquery name="GetDe...
The following structure stores the address of one of the employees: <cfset AddrStr= StructNew()> <cfset AddrStr.Address1="23/16"> <cfset AddrStr.Address2="Lismore Street"> <cfset AddrStr.City="Man...
There are 5 info nodes in an XML document. How will you obtain the value of the 3rd info node?
What does the cfNTauthenticate tag do?
What does the cfproperty tag do?
What does the Randomize function return?
What happens when the following code is included in a cfm file: <cflog file="myAppLog" text="User Kim logged on.">
What is correct syntax for accessing an item of a structure?
What is the default value for the encoding parameter of the hash function?
What is the output of the following code: <cffunction name="thefunc" returntype="numeric"> <cfargument name="x" required="yes" type="numeric" default=2> <cfreturn x*x> </cffunction> <cfoutput> ...
What is the output of the following code: <cfoutput> #dateformat(CreateDate(2001,08,10),"dd,mmm,yyyy")# </cfoutput>
What is the output of the following code: <cfoutput> <cfset stringToSearch = "The quick brown fox jumped over the lazy dog."> #find("the",stringToSearch)# #find("the",stringToSearch,35)# ...
What is the output of the following code: <cfoutput>#IncrementValue(123.35)#</cfoutput>
What is the output of the following code: <cfoutput>reverse(6*2) equals #reverse(6*2)#</cfoutput>
What is the output of the following code: <CFPARAM DEFAULT="ProjectManager" NAME="Status"> <CFPARAM DEFAULT="Six Sigma" NAME="ProjectType"> <CFIF IsDefined("FORM.Status")> Welcome <CFOUTPUT>#FORM....
What is the output of the following code: <cfscript> function autoLeadIn(string,count) { output = ''; if(Trim(string) NEQ '') { textarray = ListToArray(string, " "); if(ArrayLen(textarray) LTE c...
What is the output of the following code: <cfscript> function calculateresult() { var a=55; var b=5; b=a+b; b=b+b; return b; } </cfscript> <cfoutput>#calculateresult()#</cfoutput>
What is the output of the following code: <cfset myArray = ArrayNew(1)> <cfset myArray[1] = "Test Value"> <cfset temp = ArrayAppend(myArray, "Akash")> <cfset temp = ArrayAppend(myArray, "P...
What is the output of the following code: <cfsilent> <cfset a = 100> <cfset b = 99> <cfset c = b-a> <cfoutput>Inside cfsilent block<br> b-a = #c#</cfoutput><br> </cfsilent> <cfoutput> ...
What is the output of the following code: <cfoutput>#REReplace("I love jelly","jell(y|ies)","cookies")#</cfoutput>
What is the output of the following code: <cfscript> function calculateresult() { var a=55; var b=5; b=b-a*b+a; return b; } </cfscript> <cfoutput>#calculateresult()#</cfoutput>
What is the output of the following code: <cfset strabc=setVariable("abc","abc123")> <cfset strxyz=setVariable("xyz","xyz321")> <cfoutput> strabc = #strabc# , strxyz = #strxyz# </cfoutput>
What is the output of the following code: <cfset stringToSearch = "The quick brown fox jumped over the lazy dog."> <cfoutput> #findoneof("aeiou",stringToSearch)# #findoneof("aeiou",stringToSearch,4...
What is the output of the following code: <cfset yourDate = CreateDate(2002, 11, 23)> <cfoutput> This is day #Day(YourDate)# in the month of #MonthAsString(Month(yourDate))#, which has #...
What is the result of the following code: <cfset mystring = "'Newton's Law', 'Fermat's Theorem'"> <cfoutput> #PreserveSingleQuotes(mystring)# </cfoutput>
What will be the output of the given expression: evaluate("23" & 2 + 5)
What will be the result of placing the following code in any cfm file: <!--- <cflock timeout=20 scope="Session" type="Exclusive"> <cfset StructDelete(Session, "ShoppingCartItems")> </cflock> --->
What will the following code do when included in a ColdFusion application? <cfloop collection="#session#" item="j"> <cfoutput>#j# has value of : #session[j]#<br></cfoutput> </cfloop>
What will the xInfo variable contain: <cfset xInfo = objXML.xmlRoot.xmlChildren[6]["info"].xmltext>
What will XResult contain: <cfset XResult = xmlFind(XMLObject, "//info@size='3'")>
What will XResult contain: <cfset XResult = xmlSearch(XMLObject, "//@size")>
What will XResult contain: <cfset XResult = xmlSearch(XMLObject, "//info")>
When would you prefer to use the <cfstoredproc> tag in place of the <cfquery> tag?
When would you prefer to use the encrypt/decrypt functions instead of the hash function?
which ColdFusion tag is used to define the application scope like, enabling sessions, setting timeouts and specifying client variable storage?
Which ColdFusion tag is used to import a Java Server Page (JSP) tag library?
Which ColdFusion tag is used to stop the processing on the current page and opens a new ColdFusion or html file?
Which encryption algorithms are supported by the encrypt/decrypt functions?
Which encryption algorithms does the hash function support?
Which encryption engine is used by the ColdFusion MX encrypt and hash functions?
Which function has been used to generated the following output? pro%20discount
Which of the below statements are correct regarding the following code: <cfset a = GetTickCount()> <cfloop from="1" to="10000" index="i"> </cfloop> <cfset b = GetTickCount()> <cfscript> c = GetTic...
Which of the following allows the use of CFML tags within its body?
Which of the following attributes of the cfquery tag was introduced in ColdFusion MX 7?
Which of the following can be used to convert real number into integers?
Which of the following characters need escaping?
Which of the following ColdFusion tags aborts the processing of the current ColdFusion page?
Which of the following ColdFusion tags is used to get the elements, variables and values of ColdFusion objects?
Which of the following constitute the common characteristics shared by most of the Coldfusion Tags?
Which of the following constitute the core components of ColdFusion MX?
Which of the following constitute the four categories of the Coldfusion data types?
Which of the following constitutes CFML?
Which of the following does not constitute flow control tag in Coldfusion?
Which of the following functions are specially used with regular expressions?
Which of the following functions is not available with Coldfusion arrays?
Which of the following has the highest operator precedence?
Which of the following is a correct way of commenting in Coldfusion?
Which of the following is an incorrect floop syntax:
Which of the following is an invalid variable scope?
Which of the following is not a valid array function?
Which of the following is not an in-built complex data type in Coldfusion?
Which of the following is not passed as reference to the object?
Which of the following is useful in Dynamic Evaluation?
Which of the following makes CFMX7 better than the previous MX version?
Which of the following statement is correct?
Which of the following statement(s) are correct?
Which of the following statements about User defined functions (UDFs) are correct.
Which of the following statements are true when you upload an image file using the <cffile> tag?
Which of the following statements is correct with regard to Coldfusion Comments?
Which of the following statements is correct with regard to Coldfusion functions?
Which of the following statements is correct with regard to Function?
Which of the following statements is correct with regard to user defined functions?
Which of the following statements is incorrect with regard to Coldfusion Tags?
Which of the following statements regarding placing meta tags at the location *********** in the following code are correct? <cfset browsers="MSIE,Mozilla"> <cfif FindNoCase(browsers,#CGI.HTTP_USE...
Which of the following statements with respect to the below code is correct? <cfset RandomItem = RandRange(1, greatoffers.recordcount)> <CFOUTPUT QUERY="greatoffers" MAXROWS=1 STARTROW=#RandomItem...
Which of the following structure assignments is correct?
Which of the following tags do not work in the ColdFusion MX series?
Which of the following tags is not useful in handling exceptions?
Which of the following tags was introduced in the ColdFusion MX series?
Which of the following techniques allow the Coldfusion code to be used at many places with in an application?
Which of the following verity query types is not valid?
Which of the given options is correct for the following code? <cfupdate datasource="MIS" tablename="user">
Which of the statements with respect to the following code is correct? <cffunction name="daysmonths" returntype="date"> <cfreturn dateadd("d",1,Now())> </cffunction> <cfoutput> #daysmonths()# </cf...
Which operator will be evaluated first in the following statement: <cfquery name="GetEmpData" datasource="myDSN"> select (age + 3 * 4 / 2 - 8) from emp </cfquery>
With respect to the following code, which option is correct? <cfoutput> #GetHttpTimeString(now())# </cfoutput>
You created a Coldfusion form to get the guest information from your website. The name of the input elements is same as that in the database. The name of the data source is "GuestDSN" and the table...
You have created an extension to Coldfusion tag named "CalcClass." It needs one integer argument named "IntValue." Which of the following enables you to call that in the Coldfusion code?
You have defined a field (EmailAd) on your user registration form to get the user email. Which of the following helps you validate the data before passing it to the database?
You have retrieved the list of all the customers and the products bought for the day, using a cfquery. The structure "CNameStr" stores the value of a customer's first, middle, and the last name in ...
You have to pass a string named "StrName" and an array named "ArrItems" to a custom tag. Which of the following ways serves the purpose?
You have written a cfquery ("HireSalaries") to retrieve two derived columns "Year" and "AverageHike." Which of the following is the right way to plot an area type line graph with this cfquery?
You need to create a website using ColdFusion that spans across several servers. What will be the preferred technique for maintaining session state across the servers considering that some users mi...
You need to set the value for 'UserName' to ''Guest'' if a user does not fill in the user name in the Coldfusion form.��Which of the following ways help you implement this?
You want create PDF files of your XHTML documents using ColdFusion MX. How can you do this?
You want to display the titles of books that meet the following criteria: 1. Purchased before November 11, 2002 2. Price is less than $500 or greater than $900 You want to sort the result by the ...
You wrote the following code to set the prices of the items in an array: <cfset numArray = ArrayNew(1)> <cfset ArraySet(numArray, 1, 8 ,25)> <cfset numArray[3] = "225"> <cfset PriceFound = False> ...
Your website has to display the personal information of the user when he logs in. The table storing the personal details is 'TbUser' (with primary key Uid) and the data source is 'UserDSN.' The use...