Oracle Database 23ai SQL Associate - 1Z0-171무료 덤프문제 풀어보기
Which of the following is a valid reason to create a synonym?
정답: C
Which of the following statements creates an ascending sequence starting at 100 and incrementing by 10?
정답: C
What does the following SQL query do?
SELECT * FROM employees WHERE salary > 5000 ORDER BY department_id;
SELECT * FROM employees WHERE salary > 5000 ORDER BY department_id;
정답: D
What is the primary purpose of a primary key in a relational database?
정답: A
Which operator can be used in a multiple-row subquery to match a single value to a list of values?
정답: D
What will the following SQL query return?
SELECT TRUNC(15.678, 2) AS truncated_value FROM dual;
SELECT TRUNC(15.678, 2) AS truncated_value FROM dual;
정답: B
What will the following SQL query do?
UPDATE employees
SET salary = salary * 1.1
WHERE department_id = 10;
UPDATE employees
SET salary = salary * 1.1
WHERE department_id = 10;
정답: A