By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,217 Members | 1,297 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,217 IT Pros & Developers. It's quick & easy.

Subqueries cannot (multiple choice)

P: 93

I have done an access test and there is one question that where currently all answers seems to incorrect for me. (only one is incorrect).

Q: Subqueries cannot:

a) use group by or group functions
b) retrieve data from a table different from the one in the outer query
c) join tables
d) appear in select, update, delete, insert statements.

I would appreciate explanations why one of this is incorrect :)

Apr 18 '09 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 15k+
P: 31,707
A, B & D are incorrect (subqueries can do all these things).
I don't even understand C. It is a meaningless statement as far as I can see (It's not right or wrong so much as senseless).

A subquery is a data source. How can a data source be said to "join tables"?
Apr 18 '09 #2

Expert Mod 2.5K+
P: 2,545
Hi. There is an art in designing multiple choice questions - and you have found one of the ambiguous ones.

The answers considered 'incorrect' are known as distractors, and when a multiple-choice question is poorly designed (like this one) the game is given away by the length of the answers - the distractors in this case are all much longer than the supposed correct answer, C.

C is, however, badly worded - as NeoPa says it does not make sense the way it is written. It suggests that a previous version of the question has been adapted for the current question set - but in doing so it has introduced ambiguity and doubt into the question in an unintended way.

The process of external invigilation/second marking of such work can prevent this kind of ambiguity and error from gaining a hold - but clearly not this time!

Apr 20 '09 #3

P: 93
Thanks for the replies I'm glad my logic is still working ;)

C was my guess after eliminating the rest however I was wondering if they don't mean using a subquery in the INNER JOIN (or others) which I think it can be used this way. Which for me it kind of mean join tables.

Apr 21 '09 #4

Expert Mod 15k+
P: 31,707
Thanks Stewart. I appreciate the explanation as much as Emil does now :)
Apr 21 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.