최신Oracle Database 23ai SQL Associate - 1Z0-171무료샘플문제
문제1
What is the purpose of the DBA_OBJECTS data dictionary view?
What is the purpose of the DBA_OBJECTS data dictionary view?
정답: A
문제2
What does the following query return?
SELECT employee_id
FROM employees
WHERE department_id IN (SELECT department_id FROM departments WHERE location_id = 1000);
What does the following query return?
SELECT employee_id
FROM employees
WHERE department_id IN (SELECT department_id FROM departments WHERE location_id = 1000);
정답: C
문제3
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
문제4
What does the following SQL query return?
SELECT employee_id, salary * 12 AS annual_salary FROM employees;
What does the following SQL query return?
SELECT employee_id, salary * 12 AS annual_salary FROM employees;
정답: C
문제5
The column data type is converted to a primary key.
The column data type is converted to a primary key.
정답: C
문제6
What is the purpose of using external tables in Oracle Database?
What is the purpose of using external tables in Oracle Database?
정답: B
문제7
What is the purpose of a correlated subquery?
What is the purpose of a correlated subquery?
정답: A
문제8
What is the primary purpose of a primary key in a relational database?
What is the primary purpose of a primary key in a relational database?
정답: A