[2026] Oracle Database 23ai SQL Associate - 1Z1-171 무료 시험 문제

문제1

Which operator can be used in a multiple-row subquery to match a single value to a list of values?

A. NOT NULL

B. EXISTS

C. =

D. IN

정답: D

문제2

What will the following SQL query do?
UPDATE employees
SET salary = salary * 1.1
WHERE department_id = 10;

A. Increase the salary of employees in department 10 by 10%

B. Increase the salary of all employees by 10%

C. Decrease the salary of employees in department 10 by 10%

D. Set the salary to 1.1 for employees in department 10

정답: A

문제3

Which command grants a user the ability to query data from a specific table?

A. GRANT SELECT ON table_name TO user_name;

B. GRANT ALL ON table_name TO user_name;

C. ALLOW SELECT ON table_name TO user_name;

D. ENABLE SELECT ON table_name TO user_name;

정답: A

문제4

What is the primary purpose of an index in SQL?

A. To improve the performance of data retrieval queries

B. To enforce data integrity constraints

C. To store metadata about a table

D. To ensure uniqueness of values in a column

정답: A

문제5

Which Oracle SQL function returns the current date and time, including time zone information?

A. CURRENT_DATE

B. SYSDATE

C. NOW

D. CURRENT_TIMESTAMP

정답: D

문제6

Which of the following SQL commands retrieves data from a relational database?

A. INSERT

B. UPDATE

C. SELECT

D. DELETE

정답: C

문제7

Which command can be used to rename a table in Oracle Database?

A. ALTER TABLE RENAME

B. RENAME

C. MODIFY TABLE NAME

D. RENAME TABLE

정답: B

Oracle Database 23ai SQL Associate - 1Z1-171무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트