Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2013
    Posts
    8

    Unanswered: What is this term called

    In database, locking level is also known as:

    A) Granularity
    B) S lock
    C) X lock
    D) Dead lock

    According to me its D, but I am confused, can any one clarify this

    Thank a lot in advance

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    F) none of the above
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2013
    Posts
    8
    Quote Originally Posted by anacedent View Post
    F) none of the above
    Dear friend , it has to be one out of the options given

  4. #4
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by shyjuu View Post
    Dear friend , it has to be one out of the options given
    If you are so sure, then the question is wrong.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  5. #5
    Join Date
    Mar 2007
    Posts
    623
    It seems that the meaning of this exam question was lost in translation to English; anyway, for Oracle term definition (as each database may - and sometimes does - use different ones for the same/similar thing) you may benefit from consulting Oracle documentation, which is available e.g. online on http://tahiti.oracle.com/

    Relevant chapter about locking is placed in Database Concepts books.
    For 11gR2, it is available here: http://docs.oracle.com/cd/E11882_01/...sist.htm#i5704
    It will surely clear your confusion.

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Actually, this appears to be a question about SQL Server. If it is, then the answer is indeed in the options listed. Why did you pick "D"?

  7. #7
    Join Date
    Mar 2013
    Posts
    8
    Quote Originally Posted by MCrowley View Post
    Actually, this appears to be a question about SQL Server. If it is, then the answer is indeed in the options listed. Why did you pick "D"?
    Becuase option A has no relation with lock

    Option B and C are types of lock

    so I selected D

  8. #8
    Join Date
    Mar 2007
    Posts
    623
    In which context does your studying material mention the term "level" with connection to locking?

    If your question is really concerning Oracle (why did you not answer MCrowley about your database vendor???), did you bother to open the link I posted and search for "level" there?

    In my opinion, this question is only useless nitpicking on terms, without any real knowledge about database behaviour behind.

  9. #9
    Join Date
    Mar 2013
    Posts
    8
    Quote Originally Posted by flyboy View Post
    In which context does your studying material mention the term "level" with connection to locking?

    If your question is really concerning Oracle (why did you not answer MCrowley about your database vendor???), did you bother to open the link I posted and search for "level" there?

    In my opinion, this question is only useless nitpicking on terms, without any real knowledge about database behaviour behind.
    Yes I did opened the link , but unable to find the answer, and there is no need to mention about database vendor, its just the MCQ question I came accross and got stuck

  10. #10
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Keep in mind, Shyjuu, You are asking (apparently) SQL Server questions in an Oracle forum. This is generally bad forum etiquette.

    As to the question, "granularity" does have a relation to the concept of locks. You may want to review your class notes, or the textbook to see.

    I am just having trouble figuring out how the movie McQ has anything to do with locks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •