認證考試內容年年調整，2026 年的 1z0-071 考試也不例外。KaoGuTi 持續追蹤 Oracle Database SQL 的考綱變化，437 道題目隨之更新，購買後還享有 365 天免費更新。

Oracle 1z0-071 考試概覽:

認證廠商:	Oracle
考試名稱:	Oracle Database SQL
考試代碼:	1Z0-071
考試時間:	120 分鐘
考試形式:	多選題, 單選題, 監考考試, 電腦化考試
支援語言:	簡體中文, 西班牙文, 葡萄牙文, 英文, 日文
相關認證:	Oracle Database Administrator Certified Associate Oracle Database Development certifications
證照有效期限:	永久有效 (Oracle 認證政策可能有所變更)
考試費用:	USD 245 (因國家/地區而異)
推薦課程:	Oracle Database SQL 培訓
考試報名:	Oracle 認證註冊
範例考題:
考試方式:	依地區提供線上監考或測試中心實體考試
必備條件:	無強制先修條件；建議具備關聯式資料庫與 SQL 的基本知識。
官方大綱網址:	https://education.oracle.com/oracle-database-sql/pexam_1Z0-071

Oracle 1z0-071 考試大綱主題:

Oracle Database SQL 考試常見問題解答

最新的 Oracle PL/SQL Developer Certified Associate 1z0-071 免費考試真題：

問題 #1

Examine the description of the CUSTOMERStable:

Which two SELECTstatements will return these results (Choose two.):

A. SELECT customer_name FROM customers WHERE UPPER (customer_name) LIKE `MA*';
B. SELECT customer_name FROM customers WHERE customer_name LIKE `%a%';
C. SELECT customer_name FROM customers WHERE UPPER (customer_name) LIKE `MA%';
D. SELECT customer_name FROM customers WHERE customer_name LIKE `Ma*';
E. SELECT customer_name FROM customers WHERE customer_name LIKE `Ma%';
F. SELECT customer_name FROM customers WHERE customer_name LIKE `*Ma*';
G. SELECT customer_name FROM customers WHERE customer_name = `*Ma*';

問題 #2

View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables.

Evaluate the following MERGE statement:
MERGE INTO orders_master o
USING monthly_orders m
ON (o.order_id = m.order_id)
WHEN MATCHED THEN
UPDATE SET o.order_total = m.order_total
DELETE WHERE (m.order_total IS NULL)
WHEN NOT MATCHED THEN
INSERT VALUES (m.order_id, m.order_total);
What would be the outcome of the above statement?

A. The ORDERS_MASTER table would contain the ORDERJDs 1 and 2.
B. The ORDERS MASTER table would contain the ORDER IDs 1,2,3 and 4.
C. The ORDERS_MASTER table would contain the ORDERJDs 1,2 and 3.
D. The ORDERS_MASTER table would contain the ORDERJDs 1,2 and 4.

問題 #3

Which two are true about transactions in the Oracle Database? (Choose two.)

A. An uncommitted transaction is automatically committed when the user exits SQL*Plus.
B. A DDL statement issued by a session with an uncommitted transaction automatically commits that transaction.
C. DML statements always start new transactions.
D. A session can see uncommitted updates made by the same user in a different session.
E. DDL statements automatically commit only data dictionary updates caused by executing the DDL.

問題 #4

Examine the SQL statement used to create the TRANSACTION table.
SQL > CREATE TABLE transaction
(trn_id char(2) primary key,
Start_date date DEFAULT SYSDATE,
End_date date NOT NULL);
The value 'A1' does not exist for trn_id in this table.
Which SQL statement successfully inserts a row into the table with the default value for START_DATE?

A. INSERT INTO transaction (trn_id, end_date) VALUES ('A1', '10-DEC-2014')
B. INSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE('SYSDATE+10'))
C. INSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE(DEFAULT+10))
D. INSERT INTO transaction (trn_id, start_date, end_date) VALUES ('A1', , '10-DEC-2014')

問題 #5

Evaluate the following query:

What would be the outcome of the above query?

A. It executes successfully and introduces an 's at the end of each promo_name in the output.
B. It produces an error because flower braces have been used.
C. It produces an error because the data types are not matching.
D. It executes successfully and displays the literal " {'s start date was \> " for each row in the output.

問題與答案：