Untitled
15 Questions
3 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Meaning of null

  • Unknown value
  • Unavailable value
  • Not applicable attribute
  • All of the above (correct)
  • Each individual NULL value considered to be the same from every other NULL value

  • True
  • False (correct)
  • Null = null comparison is acceptable

  • True
  • False (correct)
  • SQL allows queries that check whether an attribute value is null like?

    <p>IS NULL</p> Signup and view all the answers

    Complete select from where blocks within where clause of another query

    <p>nested query</p> Signup and view all the answers

    Compares a value with a set or multi set of values, evaluate if the value is one of the elements in the set

    <p>In</p> Signup and view all the answers

    اذا ابي اطبق شرط على اكثر من اتربيوت اخليهم بقوس ، هذا وش يسمى؟

    <p>Tuples of values</p> Signup and view all the answers

    فيه مثال بالملخص عقب التيوبلز ارجعي شوفيه

    <p>طيب</p> Signup and view all the answers

    Any sum and all are used with

    <p>Nested queiers</p> Signup and view all the answers

    Evaluated once for each tuple in the outer query

    <p>Corrlated nested query</p> Signup and view all the answers

    Queries with IN or = can be collabsed into one single block

    <p>True</p> Signup and view all the answers

    Check whether the results of a corrleated nested query is empty or not

    <p>Exists</p> Signup and view all the answers

    Natural/ outer are types of

    <p>Join</p> Signup and view all the answers

    نوع من الجوين يشترط الجوين كوندشن (تحط الاتربيوتس الي لازم يتساوون) ومايشترط تشابه اسماء الاتربيوتس

    <p>Inner join</p> Signup and view all the answers

    Natural join :

    <p>A&amp;B</p> Signup and view all the answers

    More Like This

    SQL Basics Quiz
    10 questions

    SQL Basics Quiz

    HaleRetinalite2094 avatar
    HaleRetinalite2094
    Introduction to SQL Database Model
    10 questions
    ClassicModels SQL Exercises
    26 questions
    Use Quizgecko on...
    Browser
    Browser