15 Questions
Meaning of null
All of the above
Each individual NULL value considered to be the same from every other NULL value
False
Null = null comparison is acceptable
False
SQL allows queries that check whether an attribute value is null like?
IS NULL
Complete select from where blocks within where clause of another query
nested query
Compares a value with a set or multi set of values, evaluate if the value is one of the elements in the set
In
اذا ابي اطبق شرط على اكثر من اتربيوت اخليهم بقوس ، هذا وش يسمى؟
Tuples of values
فيه مثال بالملخص عقب التيوبلز ارجعي شوفيه
طيب
Any sum and all are used with
Nested queiers
Evaluated once for each tuple in the outer query
Corrlated nested query
Queries with IN or = can be collabsed into one single block
True
Check whether the results of a corrleated nested query is empty or not
Exists
Natural/ outer are types of
Join
نوع من الجوين يشترط الجوين كوندشن (تحط الاتربيوتس الي لازم يتساوون) ومايشترط تشابه اسماء الاتربيوتس
Inner join
Natural join :
A&B
This quiz tests your knowledge of NULL values in SQL, including their meaning, comparison, and usage in queries. It covers topics such as comparing NULL values, querying for NULL values using SELECT-FROM-WHERE blocks, and evaluating values within a set or multiset.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free