Unfortunately, I would not be able to disclose the company name. My apologies.
Brian Simmons [EMAIL PROTECTED] wrote:Discover Antartica wrote:
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.
Jochem wrote:
So
1. b
2. b
3. b (This is a pointless query... you can just use test.RecordCount.)
4. d
5. a
6. b
7. a
8. b
9. e
10. a (a b e would all work with MySQL... b e are the same...)
11. false
12. b (This is phrased wrong. It should be the 'site root'.)
13. d
14. b
I could be wrong... and I'm
I take issue with this question:
-
11) True or False. The ACTION attribute value of a FORM tag cannot
have URL query string appended to it.
a) True
b) False
-
The answer is it depends on
1) b first and then mapped drives (not listed as a answer)
2) a
3) e - None of the above. (b) would allow you to alias the resulting column to
a simpler name, but it is not required.
4) d
5) e - None of the above as listed. It is possible to use (b) for a form of
server side validation but
Kevin,
This is not a pointless query
CFQUERY NAME=test DATASOURCE=test
SELECT Count(*) AS total
FROM TestTable
/CFQUERY
You would NOT want to select all the records in a table if all you wanted
was the total. Otherwise you are bringing in the whole kit and
I took issue with several of the questions, including this one.
But if we want to be logical about it, the answer is true. You may not get
the results you expected, but the action can take a query string.
I wonder how the test givers would take having their questions corrected.
Would they
Discover Antartica wrote:
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.
So give us the his answers and I will tell you how he did without
spoiling the test results of future applicants :)
Jochem
30, 2005 10:38 AM
To: CF-Talk
Subject: RE: CF Test
Kevin,
This is not a pointless query
CFQUERY NAME=test DATASOURCE=test
SELECT Count(*) AS total
FROM TestTable
/CFQUERY
You would NOT want to select all the records in a table if all you wanted
was the total
Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: August 30, 2005 10:38 AM
To: CF-Talk
Subject: RE: CF Test
Kevin,
This is not a pointless query
CFQUERY NAME=test DATASOURCE=test
SELECT Count(*) AS total
FROM TestTable
/CFQUERY
You would
it to myself.
Cheers,
Kevin
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: August 30, 2005 11:20 AM
To: CF-Talk
Subject: Re: CF Test
On 8/30/05, Kevin Aebig [EMAIL PROTECTED] wrote:
Using a count makes that query completely useless. It can't be reused, nor
does
I took issue with several of the questions, including this
one.
But if we want to be logical about it, the answer is
true. You may not get the results you expected, but the
action can take a query string.
I wonder how the test givers would take having their
questions corrected. Would
I'm not saying SELECT * is a better query, but I do believe it's
smarter to
roll multiple uses into a single result set.
If you DO need all records in the same process anyway, you are right,
but if not, a SELECT *
means much more overhead on the server. Most database system keep the
number of
If I just need a count, why would i want to return a recordset?
A good example of this is when you want to display n records among
total nb of records.
Some databases allow you to set limits on the records to be returned.
For example in MySQL, in
SELECT ... LIMIT 9, 20 will return only rows 10
table makes a big
difference when you have thousands of records, if all you need is a
record count.
-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 10:07 AM
To: CF-Talk
Subject: RE: CF Test
Using a count makes that query completely useless
On 8/30/05, Claude Schneegans [EMAIL PROTECTED] wrote:
If I just need a count, why would i want to return a recordset?
A good example of this is when you want to display n records among
total nb of records.
Some databases allow you to set limits on the records to be returned.
For example
Using a count makes that query completely useless. It
can't be reused,
nor does it return anything of relevance. Which means its
sole purpose
is to bring back a single number...
What?! A dba will laugh his or her ass off if he/she
heard this.
Select count(*) from table versus select *
One... I'm not laughing.
Two... Exactly my point. I can't remember the last time I *only* needed a
count.
Cheers,
Kevin
-Original Message-
From: Nick Han [mailto:[EMAIL PROTECTED]
Sent: August 30, 2005 12:45 PM
To: CF-Talk
Subject: RE: CF Test
Using a count makes that query
Select lastname, firstname, phone, address, blah blah
from users where lastname like 'smith%'
/cfquery
/cfif
-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 11:59 AM
To: CF-Talk
Subject: RE: CF Test
One... I'm not laughing.
Two
Select lastname, firstname, phone, address, blah blah
from users where lastname like 'smith%'
/cfquery
/cfif
-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 11:59 AM
To: CF-Talk
Subject: RE: CF Test
One... I'm not laughing.
Two
:59 AM
To: CF-Talk
Subject: RE: CF Test
One... I'm not laughing.
Two... Exactly my point. I can't remember the last time I *only* needed
a
count.
Cheers,
Kevin
~|
Logware (www.logware.us): a new and convenient
yes, situations exists where you need the whole shebang. but
situations exist as well where you need just the count and nothing
more. See the part of my response that you quoted above. If I need
-just- a count... (emphasis on -just- added)
I completely agree with you, and I just gave such an
-Original Message-
From: Nick Han [mailto:[EMAIL PROTECTED]
Sent: August 30, 2005 1:09 PM
To: CF-Talk
Subject: RE: CF Test
Kevin, how about this scenario?
cfquery name=query1
Select count(*) from users where lastname like 'smith%'
/cfquery
cfif query1.count gt 500
Notify users
I work with *large* amounts of queried financial
data, both hosted locally and remotely and by implementing these idea's
we've dropped our DB query times by 60%.
IMHO, look at all your SELECT * queries, replace a couple of them with
SELECT count() and
another one with limits for the rows, and
So how about those CF test questions... :)
What was the question? ;-))
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
On 8/30/05, Claude Schneegans [EMAIL PROTECTED] wrote:
yes, situations exists where you need the whole shebang. but
situations exist as well where you need just the count and nothing
more. See the part of my response that you quoted above. If I need
-just- a count... (emphasis on -just-
Discover Antartica wrote:
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.
Jochem wrote:
So give us the his answers and I will tell you how he did without
spoiling the test results of future applicants :)
I'd swear they are as they look very familiar and probably have been on
other tests I have seen.
On 8/30/05, Brian Simmons [EMAIL PROTECTED] wrote:
If you download the demo of CFMX Exam Buster 7.0 (which allows you to take
1
full test), you'll see:
- question #36 is the EXACT
you might mean this:
http://cfusion.coreactive.com/cf_test/
I haven't updated it in a long while.
Some one has a cf test to take on line and I can't remeber where it is at
..
Do any of you guy's or gal's know where it is.
Jim Taylor
Web Centric Central
http://130.13.69.228
[EMAIL
www.brainbench.com
- Original Message -
From: "Jim Taylor" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, September 21, 2000 5:41 PM
Subject: CF TEST
Some one has a cf test to take on line and I can't remeber where it is at
..
Do any of you guy's or gal's know
ames Smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 21, 2000 12:31 PM
To: CF-Talk
Subject: Re: CF TEST
www.brainbench.com
- Original Message -
From: "Jim Taylor" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, September 21, 2000 5:41 PM
Su
30 matches
Mail list logo