Here are some questions that a company asked a friend of mine during an interview. I just wanted to see if he answered them correctly. Can someone say the answers. Just type like this to save time:
1. a 2. b 3. c etc. Here are the questions: 1) Which path is used in the template attribute in the <CFINCLUDE> tag? a) physical path b) calling template relative path c) web document root relative path d) any directory under Cfusion\CustomTags 2) If you have the following variable definition in the Application.cfm file, what is the scope of the variable after it is created? <CFSET x = foo> a) Variables (local) b) Application c) Session d) Request 3) What is missing from the following <CFQUERY> tag's SELECT statement if you want to return the count? <CFQUERY NAME="test" DATASOURCE="test"> SELECT Count(*) FROM TestTable </CFQUERY> a) SELECT Count(CountVar) b) SELECT Count(*) AS CountVar c) SELECT Count(*) INTO CountVar d) SELECT Count(*) <CFQUERYPARAM NAME="CountVar"> 4) Which of the following ANSI standard WHERE clauses will return all rows where City begins with the letter S? a) WHERE City LIKE "S" b) WHERE City = 'S*' c) WHERE City LIKE 'S_' d) WHERE City LIKE 'S%' 5) Which one of the following tags is used for server-side validation? (Choose one.) a) input type ="text" b) input type="hidden" c) input value="hidden d) input value=text 6) What does the following code do? <CFSET myArray=Array> <CFSET Evaluatex= & myArray & New())> a) Creates a new empty array called myArray b) Creates a new empty array called x c) Creates a new string called x with a value of ArrayNew() d) The code will produce an error 7) The <CFSELECT> tag must be nested inside which of the following tag blocks? a) <CFFORM></CFFORM> b) <FORM></FORM> c) <CFQUERY></CFQUERY> d) CFINPUT></CFINPUT> e) None of the choices, <CFSELECT is not required to be nested in a parent tag block 8) Which attribute of the <CFAPPLICATION> tag specifies where to store login information? a) COOKIESTORAGE b) SESSIONSTORAGE c) LOGIN d) LOGINSTORAGE e) No such attribute exists 9) Which aggregate function in SQL can return the largest value found in a numeric column in a table? a) Sum b) Count c) Min d) Maximum e) Max 10) Suppose you have a table called Emp, and it has one colulmn called LNAME. Which of the following SQL statement would correctly insert the value SMITH into the EMP table? a) INSERT INTO EMP (LNAME) VALUES (SMITH) b) INSERT INTO EMP (LNAME) VALUES (SMITH) c) INSERT EMP (LNAME) VALUES (SMITH) d) INSERT VALUES EMP (LNAME) INTO (SMITH) e) INSERT INTO EMP (LNAME) VALUE (SMITH) 11) True or False. The ACTION attribute value of a <FORM> tag cannot have URL query string appended to it. a) True b) False 12) Suppose you have the following CFML code, what would be displayed to the user? <CFSET aryTemp = ArrayNew(1)> <CFSET aryTemp[1] = ArrayNew(1)> <CFSET aryTemp[1][1] = First> <CFOUTPUT>#aryTemp[1]#</CFOUTPUT> a) First b) aryTemp c) Nothing would be displayed to the user d) An error would be displayed to the user 13) If you start the path to a <CFINCLUDE> template with a forward slash (/), ColdFusion will first search for the template in which of the following? a) The calling pages directory b) Other directories by using relative pathing c) The web roots main directory d) The Directory explicitly mapped in the ColdFusion administrator e) The ColdFusion installation directory 14) Which od the following is the ColdFusion operator for greated than or equal to (>=) in a <CFIF> statement? a) GREATER THAN OR EQUAL TO b) GEQUAL TO c) GE d) GTE e) GREATERTHANEQUAL 15) Assume you have a valid <CFQUERY> with the name of TEST and the SQL SELECT statement contains a valid column called EMP_ID and the query returns 2 rows. What would the following CFML code display to the user? <CFOUTPUT> <CFLOOP INDEX=i FROM=1 TO=#test.RecordCount#>#test.emp_id[i]#</CFLOOP> </CFOUTPUT> a) Nothing would be displayed to the user b) The two emp_id column values would be shown to the user c) The firstemp_id column value would be shown twice to the user d) #test.emp_id[i]##test.emp_id[i]# e) An error would be displayed to the user Regards DA --------------------------------- Start your day with Yahoo! - make it your home page ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216782 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54