علم البيانات | DS2 Quizes – Telegram
علم البيانات | DS2 Quizes
965 subscribers
96 photos
2 videos
14 files
110 links
"قناة علمية متخصصة في مجال علم البيانات، قناة خاصة بالاختبارات MCQ ."
القناة العامة: @Computer_DS_1
النقاشات: @Computer_DS1
قناة الاختبارات: @Computer_DS_2
بوت التواصل والمشاركات : @DS_Combot
Download Telegram
The integrity constraint that specifies that the Primary Key cannot have a NULL value is the:
Anonymous Quiz
7%
Domain Constraint
21%
Entity Integrity Constraint
43%
Referential Integrity Constraint
29%
Key Constraint
The constraint that ensures that a value of an attribute in one relation must exist as a value of a primary key in another relation is:
Anonymous Quiz
14%
Key Constraint
29%
Entity Integrity Constraint
57%
Referential Integrity Constraint
0%
Domain Constraint
A minimal superkey is also referred to as a:
Anonymous Quiz
29%
Alternate Key
50%
Candidate Key
14%
Foreign Key
7%
Primary Key
Which term refers to a Candidate Key that was not chosen as the Primary Key?
Anonymous Quiz
14%
Alternate Key
21%
Partial Key
64%
Superkey
0%
Foreign Key
The set of allowed values for an attribute is defined by its:
Anonymous Quiz
43%
Domain
14%
Cardinality
36%
Degree
7%
Relation
Which characteristic of a relation states that the ordering of tuples (rows) has no significance?
Anonymous Quiz
29%
The degree is fixed
21%
Tuple ordering is immaterial
29%
Domain constraints must be met
21%
Tuple values are atomic
The set of tuples of a relation at any specific point in time is called the:
Anonymous Quiz
8%
Relation Degree
31%
Relation State
31%
Relation Domain
31%
Relation Schema
Which update operation may violate the Referential Integrity constraint?
Anonymous Quiz
58%
Update or Delete
17%
Insert
17%
Create
8%
Select
The informal term for a Relation in the Relational Model is:
Anonymous Quiz
29%
Attribute
7%
Row
57%
Table
7%
Domain
Which type of key is a set of one or more attributes that, taken collectively, allow us to identify uniquely a tuple in the relation?
Anonymous Quiz
50%
Superkey
7%
Foreign Key
29%
Alternate Key
14%
Partial Key
The constraint that limits the values of an attribute based on its data type and format is the:
Anonymous Quiz
8%
Key Constraint
42%
Referential Integrity Constraint
42%
Domain Constraint
8%
Entity Integrity Constraint
The number of Tuples (rows) in a relation is referred to as its:
Anonymous Quiz
25%
Degree
50%
Cardinality
17%
Domain
8%
State
Which property states that values in a tuple are non-decomposable (atomic)?
Anonymous Quiz
17%
Domain Constraint
50%
Atomicity of values
17%
Entity Integrity
17%
Tuple Ordering
If a Primary Key consists of multiple attributes, it is known as a:
Anonymous Quiz
25%
Foreign Key
42%
Composite Key
25%
Candidate Key
8%
Simple Key
The key in the referencing relation is called the:
Anonymous Quiz
23%
Alternate Key
54%
Foreign Key
15%
Primary Key
8%
Candidate Key
Which SQL command is used to permanently remove the entire structure and all data of a relation from the database?
Anonymous Quiz
15%
TRUNCATE TABLE
23%
DROP TABLE
54%
DELETE TABLE
8%
REMOVE TABLE
Which clause in a basic SQL query is used to specify a condition for selecting tuples?
Anonymous Quiz
36%
SELECT
36%
WHERE
27%
GROUP BY
0%
FROM