최신Oracle Database 23ai SQL Associate - 1Z0-171무료샘플문제
문제1
Which of the following is a valid reason to create a synonym?
Which of the following is a valid reason to create a synonym?
정답: B
문제2
Which SQL function can be used to replace NULL values with a specified value?
Which SQL function can be used to replace NULL values with a specified value?
정답: A
문제3
What is a subquery in SQL?
What is a subquery in SQL?
정답: C
문제4
What does the following SQL query do?
SELECT * FROM employees WHERE salary > 5000 ORDER BY department_id;
What does the following SQL query do?
SELECT * FROM employees WHERE salary > 5000 ORDER BY department_id;
정답: D
문제5
What will the following query return?
SELECT TO_CHAR(SYSDATE, 'DD-MM-YYYY') AS formatted_date FROM dual;
What will the following query return?
SELECT TO_CHAR(SYSDATE, 'DD-MM-YYYY') AS formatted_date FROM dual;
정답: C
문제6
What happens when the TRUNCATE TABLE statement is executed?
What happens when the TRUNCATE TABLE statement is executed?
정답: D
문제7
What is the purpose of the DBA_OBJECTS data dictionary view?
What is the purpose of the DBA_OBJECTS data dictionary view?
정답: A
문제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
문제9
What does the UNION ALL operation do when selecting matching columns from different tables?
SELECT employee_id, salary FROM employees
UNION ALL
SELECT employee_id, bonus FROM bonuses;
What does the UNION ALL operation do when selecting matching columns from different tables?
SELECT employee_id, salary FROM employees
UNION ALL
SELECT employee_id, bonus FROM bonuses;
정답: B
문제10
Which SQL function calculates the number of months between two dates?
Response:
Which SQL function calculates the number of months between two dates?
Response:
정답: B