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
The effect of specifying ON DELETE CASCADE for a Foreign Key constraint is:
Anonymous Quiz
56%
Deleting the referencing tuples in the child table
33%
Setting the Foreign Key value to its default
11%
Blocking the deletion of the referenced Primary Key
0%
Setting the Foreign Key value to NULL
Which keyword allows for the temporary renaming of a column or table within a single query?
Anonymous Quiz
22%
MODIFY
33%
AS
22%
ALTER
22%
RENAME
Which constraint is used to ensure that all values in a column are unique, but allows NULL values?
Anonymous Quiz
33%
CHECK
44%
UNIQUE
11%
PRIMARY KEY
11%
NOT NULL
The ORDER BY clause sorts the result set based on the values of specified attributes in:
Anonymous Quiz
22%
The GROUP BY clause
56%
Ascending or descending order
22%
The WHERE clause
0%
Only ascending order
The SQL statement used to add new tuples to a relation is:
Anonymous Quiz
11%
ADD
67%
INSERT
22%
UPDATE
0%
CREATE