問題1
How are NULL values treated in relational databases?
How are NULL values treated in relational databases?
正確答案: B
問題2
What does a Cartesian product in SQL result from?
What does a Cartesian product in SQL result from?
正確答案: C
問題3
What does the following query return?
SELECT department_id FROM departments
INTERSECT
SELECT department_id FROM employees;
What does the following query return?
SELECT department_id FROM departments
INTERSECT
SELECT department_id FROM employees;
正確答案: B
問題4
Which SQL clause is used to specify the source table in a query?
Which SQL clause is used to specify the source table in a query?
正確答案: A
問題5
Which command creates a new role in Oracle Database?
Which command creates a new role in Oracle Database?
正確答案: A
問題6
What will the following query result in?
SELECT e.employee_id, e.manager_id
FROM employees e
WHERE e.manager_id IS NOT NULL;
What will the following query result in?
SELECT e.employee_id, e.manager_id
FROM employees e
WHERE e.manager_id IS NOT NULL;
正確答案: C
問題7
Which type of join includes rows that do not have matching values in the joined table?
Which type of join includes rows that do not have matching values in the joined table?
正確答案: C