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
