최신Oracle Database 23ai SQL Associate - 1Z1-171무료샘플문제
문제1
Which data dictionary view lists all indexes created by the current user?
Which data dictionary view lists all indexes created by the current user?
정답: C
문제2
Which statement can be used to undo changes made in a transaction?
Which statement can be used to undo changes made in a transaction?
정답: B
문제3
What does the EXISTS operator check in a subquery?
What does the EXISTS operator check in a subquery?
정답: C
문제4
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);
정답: A
문제5
Which operator can be used in a multiple-row subquery to match a single value to a list of values?
Which operator can be used in a multiple-row subquery to match a single value to a list of values?
정답: A
문제6
What does the following SQL statement do?
ALTER TABLE employees DROP COLUMN salary;
What does the following SQL statement do?
ALTER TABLE employees DROP COLUMN salary;
정답: C
문제7
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;
정답: D
문제8
Which SQL JOIN keyword retrieves all rows from both tables, including those without matches?
Which SQL JOIN keyword retrieves all rows from both tables, including those without matches?
정답: B