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
The SQL statement used to grant a privilege (like SELECT or UPDATE) to a user is:
Anonymous Quiz
30%
REVOKE
40%
GRANT
20%
DROP
10%
DELETE
Section 5: #chapter6
And
Section 6: #chapter7
#أساسيات_قواعد_البيانات
#databases_fundamentals
#علم_البيانات الدفـعـ(1)ــة
The DDL command is used to add a new column to an existing table:
Anonymous Quiz
20%
UPDATE TABLE
20%
CREATE TABLE
40%
ALTER TABLE
20%
ADD COLUMN
The purpose of the SET clause in an UPDATE statement is to:
Anonymous Quiz
10%
To specify the condition for the update
30%
To list the table(s) to be updated
60%
To define the new value for the attribute(s)
0%
To restrict the number of rows
Which comparison operator is used to test if a value is within a specified range (inclusive)?
Anonymous Quiz
0%
EXISTS
70%
BETWEEN
20%
LIKE
10%
IN
Which clause is used to group rows that have the same values on one أو more attributes?
Anonymous Quiz
20%
WHERE
40%
HAVING
20%
ORDER BY
20%
GROUP BY
What is the primary function of the AS keyword in the SELECT clause?
Anonymous Quiz
10%
To sort the result set
20%
To define a group
70%
To create an alias for a column or expression
0%
To specify the join condition
To retrieve the names of employees whose salary is NULL, which WHERE condition should be used?
Anonymous Quiz
11%
Salary = NULL
56%
Salary IS NULL
33%
Salary == NULL
0%
Salary NOT EXIST
Which type of join returns only the rows that have matching values in both tables?
Anonymous Quiz
10%
Left Outer Join
40%
Full Outer Join
40%
Inner Join
10%
Right Outer Join
Which clause is evaluated after the GROUP BY clause?
Anonymous Quiz
9%
SELECT
82%
HAVING
0%
FROM
9%
WHERE