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
The Primary Key of a relation must satisfy which two properties simultaneously?
Anonymous Quiz
23%
Uniqueness and Minimality
62%
Referential Integrity and Domain Constraint
15%
Minimality and high degree
0%
Uniqueness and high cardinality
Which update operation may violate the Referential Integrity constraint?
Anonymous Quiz
58%
Update or Delete
17%
Insert
17%
Create
8%
Select
A violation of the Entity Integrity constraint occurs if a user attempts to:
Anonymous Quiz
57%
Insert a NULL value in a Primary Key column
21%
Insert a NULL value in a Foreign Key column
7%
Delete a referenced Primary Key
14%
Update a non-key attribute
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
The three main types of Explicit schema-based constraints in the Relational Model are:
Anonymous Quiz
18%
Key, Entity Integrity, and NULL
18%
Domain, Entity Integrity, and Atomicity
64%
Key, Entity Integrity, and Referential Integrity
0%
Key, Domain, and Foreign Key
Section 5: #chapter6
And
Section 6: #chapter7
#أساسيات_قواعد_البيانات
#databases_fundamentals
#علم_البيانات الدفـعـ(1)ــة
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
Which wildcard character is used in the LIKE operator to match any sequence of zero or more characters?
Anonymous Quiz
9%
@ (At sign)
55%
% (Percent sign)
27%
\_ (Underscore)
9%
? (Question mark)
❤1
The HAVING clause in SQL is used to specify conditions on:
Anonymous Quiz
10%
Individual tuples
20%
JOIN operations
50%
Groups of tuples
20%
WHERE clause results
❤1
Which aggregate function counts the number of tuples in a group or the number of non-NULL values of an attribute?
Anonymous Quiz
27%
SUM
73%
COUNT
0%
MAX
0%
AVG
Which SQL command is used to permanently change the values of attributes in one or more tuples in a relation?
Anonymous Quiz
0%
CREATE
70%
UPDATE
20%
INSERT
10%
ALTER
The DISTINCT keyword in the SELECT clause is used to:
Anonymous Quiz
22%
Filter rows based on a condition
67%
Eliminate duplicate rows in the result
11%
Display column names
0%
Limit the number of rows returned
Which command is part of the Data Definition Language (DDL)?
Anonymous Quiz
11%
INSERT
67%
CREATE TABLE
0%
UPDATE
22%
SELECT