Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
 Posted - 2012-01-06 : 12:43:18
|
quote:
Question: The SELECT statement must include which of the following clause: Select Answer: 1) SELECT clause2) FROM clause3) Both 1 and 2.4) None of the above.
I chose 1 (SELECT clause) and it told me I was *wrong* Both SELECT and FROM are apparently required....Ahem:SELECT 'foo' AS [bar] Where is the FROM in that statement? Does it work, absolutely.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2012-01-06 : 13:46:46
|
| This is why my professors used to hate me in collage.It’s a b&*^$ when you know more than the person that wrote the test. JimUsers <> Logic |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-06 : 13:54:20
|
| If you're talking about one of the practice tests in the books, they're a load of garbage in most cases. A result of the book publishers paying peanuts for the books and the sample exams, so they get the bottom of the barrel.The real exams are far better in terms of being correct In all the 2005 and 2008 exams I wrote (2 as beta) I only say two questions that had no logical answer--Gail ShawSQL Server MVP |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-01-07 : 17:12:43
|
quote:
Originally posted by X002548
The SELECT Statement MUST include...??? TEQUILA!!!SELECT '1' AS Tequila UNION ALLSELECT '2' AS Tequila UNION ALLSELECT '3' AS Tequila UNION ALLSELECT 'Floor' AS Tequila
Your query doesn't have a deterministic order.......... Unless you often drink tequila from the floor?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2012-01-08 : 17:47:32
|
| The order is deterministic, when I reach the floor is when I stop drinking tequila.JimEveryday I learn something that somebody else already knew |
|
|
|
|
|
|
Examp 70-433 TS: Database Development WRONG