Post reply

Altering Included Indexes

  • December 30, 2015 at 6:34 am

    #1848727

    I have to agree with others. orderstatus not part of the table so option 4 fails as well. Only 1 valid option.

    Do we all get a bonus point then? 😉

  • December 30, 2015 at 6:49 am

    #1848731

    Sorry, *YOU* were wrong. There is no column orderstatus!

  • December 30, 2015 at 8:17 am

    #1848764

    Wow - what's happened to the season of goodwill?

  • December 30, 2015 at 9:02 am

    #1848770

    Glad I'm not the only one that was puzzled by #4. Oh, well. Mistakes happen.

  • December 30, 2015 at 9:18 am

    #1848774

    Like the others have already mentioned. You can't alter a column that doesn't exist.

  • December 30, 2015 at 10:31 am

    #1848800

    There is no existing column orderstatus so that last option is not possible.

  • December 30, 2015 at 11:26 am

    #1848808

    #4 will result in an error since the orderstatus column does not exist...not sure how that is part of the correct answer.

    Joshua Perry
    http://www.greenarrow.net

  • December 30, 2015 at 12:30 pm

    #1848819

    Soemthing is wrong here in the question. I guess the choice should be "only 1".

    orderstatus can not be changed to "OrdeNotes" as summarynote is dependent on OrderNotes!!

    Thanks.

  • December 30, 2015 at 1:49 pm

    #1848836

    SQL-DBA-01 (12/30/2015)

    Soemthing is wrong here in the question. I guess the choice should be "only 1".

    orderstatus can not be changed to "OrdeNotes" as summarynote is dependent on OrderNotes!!

    +1

    I avoided this answer just for that reason

    ----------------------------------------------------

  • December 30, 2015 at 1:55 pm

    #1848838

    I hate to "me too" this, but I can't +1 -- I jumped on this for easy points, and the "right" answer is wrong...

  • December 30, 2015 at 2:58 pm

    #1848854

    yep sure is

  • December 31, 2015 at 12:48 am

    #1848890

    Interesting, you can alter a column that doesn't exist 🙂

  • December 31, 2015 at 6:05 am

    #1848914

    So we are all left guessing as to which incorrect answer is a typing error.

    I guessed that it was the 3rd option because it is eminently sensible to require that saledate not be null if saleid isn't, and saleid is the primary key, so maybe shipdate in that option was an mistake for saledate, especially as a shipdate might well be null for some time after a slae has been made and an entry created in this table. But the error was in a different option and involved both altering a nonexistent column and a syntactically invalid GO.

    So the last two days of the year both have questions where it's impossible to get the answer except by pure guesswork. Not a good end to the year, or to the week.

    Anyway, happy new year, Steve.

    Tom

  • December 31, 2015 at 6:39 am

    #1848924

    Thanks for the index question.

  • January 4, 2016 at 3:56 am

    #1849155

    I'm astonished that nobody has mentioned this yet, but option 4 will fail as there is no such column.

    Perhaps everyone is using the discussion to learn and share information, rather than moaning about a minor typo and saying the same thing that has already been said a dozen times or more...

Viewing 15 posts - 16 through 30 (of 32 total)

You must be logged in to reply to this topic. Login to reply