問題1
Which clause is used to allow a user to grant a privilege to others?
Which clause is used to allow a user to grant a privilege to others?
正確答案: A
問題2
What will the following query do?
SELECT employee_id, salary
FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);
What will the following query do?
SELECT employee_id, salary
FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);
正確答案: B
問題3
What is the result of the following query?
SELECT employee_id
FROM employees
WHERE EXISTS (SELECT 1 FROM departments WHERE department_id = 10);
What is the result of the following query?
SELECT employee_id
FROM employees
WHERE EXISTS (SELECT 1 FROM departments WHERE department_id = 10);
正確答案: C
問題4
What is the output of the following query?
SELECT CURRENT_DATE FROM dual;
What is the output of the following query?
SELECT CURRENT_DATE FROM dual;
正確答案: A
問題5
Which SQL keyword is used to remove duplicate rows from the result set of a query?
Which SQL keyword is used to remove duplicate rows from the result set of a query?
正確答案: B
問題6
What does the following command do?
GRANT CREATE SESSION TO user_name;
What does the following command do?
GRANT CREATE SESSION TO user_name;
正確答案: A
問題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
問題8
What does the following SQL statement do?
SELECT e.employee_id, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;
What does the following SQL statement do?
SELECT e.employee_id, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;
正確答案: D