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
Which SQL command is used to remove tuples from a relation based on a specified condition?
Anonymous Quiz
20%
TRUNCATE TABLE
40%
DELETE
30%
REMOVE TABLE
10%
DROP TABLE
The wildcard character that matches any single character in the LIKE operator is:
Anonymous Quiz
36%
% (Percent sign)
0%
? (Question mark)
45%
\_ (Underscore)
18%
@ (At sign)
The CHECK clause in CREATE TABLE is used to:
Anonymous Quiz
9%
Validate a Foreign Key
9%
Specify the Primary Key
82%
Specify a condition that must hold for every tuple
0%
Enforce referential integrity
A common mistake is using an aggregate function directly in the:
Anonymous Quiz
40%
HAVING clause
40%
WHERE clause
20%
FROM clause
0%
SELECT clause
Which operation in ALTER TABLE is used to remove an attribute (column)?
Anonymous Quiz
10%
REMOVE
50%
DROP
20%
DELETE
20%
MODIFY
The clause used to filter the result after grouping is the:
Anonymous Quiz
30%
WHERE clause
40%
HAVING clause
20%
SELECT clause
10%
ORDER BY clause