2026년 1z1-071 시험 준비 중 궁금한 점이 생기면 언제든 문의해 주시기 바랍니다. KoreaDumps은 Oracle Database SQL 관련 상담을 한국어로 지원하며 연습문제 437문항의 이용 방법도 안내해 드립니다.

Oracle 1z1-071 시험 개요:

Oracle 1z1-071 시험 요강 주제:

1z1-071 시험 준비, 자주 묻는 질문으로 정리했습니다

최신 Oracle PL/SQL Developer Certified Associate 1z1-071 무료샘플문제

문제 #1

Which is true about the ROUND, TRUNC and MOD functions?

A. TRUNC(MOD(25,3),-1) is invalid.
B. ROUND(MOD(25,3),-1) and TRUNC(MOD(25,3),-1) are both valid but give different results.
C. ROUND(MOD(25,3),-1) is invalid.
D. ROUND(MOD(25,3),-1) and TRUNC(MOD(25,3),-1) are both valid and give the same result.

문제 #2

Which three statements are true about Oracle synonyms? (Choose three.)

A. A synonym cannot be created for a PL/SQL package.
B. A SEQUENCE can have a synonym.
C. A synonym created by one user can refer to an object belonging to another user.
D. Any user can drop a PUBLIC synonym.
E. A synonym can be available to all users.

문제 #3

Examine the data in the PRODUCTStable:

Examine these queries:

Which queries generate the same output?

A. 1 and 2
B. 2 and 3
C. 1, 2, and 3
D. 1 and 3

문제 #4

An Oracle Database session has an uncommitted transaction in progress which updated 5000 rows in a table.
In which three situations does the transaction complete thereby committing the updates? (Choose three.)

A. when the session logs out successfully
B. when a CREATE INDEX statement is executed successfully in the same session
C. when a COMMIT statement is issued by the same user from another session in the same database instance
D. when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT
E. when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT
F. when a CREATE TABLE AS SELECT statement is issued in the same session but fails with a syntax error

문제 #5

Which two are true about the data dictionary? (Choose two.)

A. All users have permissions to access all information in the data dictionary by default.
B. All user actions are recorded in the data dictionary.
C. The SYS user owns all base tables and user-accessible views in the data dictionary.
D. Base tables in the data dictionary have the prefix DBA_.
E. The data dictionary is constantly updated to reflect changes to database objects, permissions, and data.

질문과 대답: