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

Oracle 1Z1-051 考試概覽:

認證廠商:	Oracle
考試名稱:	Oracle Database：SQL 基礎 I
考試代碼:	1Z0-051
支援語言:	英文, 日文, 簡體中文, 繁體中文
實際考試題數:	66
相關認證:	Oracle Database 11g 管理員認證專家（OCP） Oracle Database 11g 管理員認證大師（OCM）
考試形式:	選擇題, 複選, 單選
考試時間:	120 分鐘
證照有效期限:	永久有效（無效期限制）
考試費用:	95 美元
及格分數:	60%
推薦課程:	Oracle Database 11g：SQL 基礎 I
考試報名:	Pearson VUE 報名系統 Oracle 認證入口網站
範例考題:
考試方式:	線上監考測驗或至 Pearson VUE 考場應考
必備條件:	無正式報考資格限制；建議具備基礎資訊素養並熟悉關聯式資料庫概念
官方大綱網址:	https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-051

Oracle 1Z1-051 考試大綱主題:

1Z1-051 認證考試問與答

最新的 11g 1Z1-051 免費考試真題：

問題 #1

Evaluate the SQL statement
DROP TABLE DEPT:
Which four statements are true of the SQL statement? (Choose four)

A. All data in the table is deleted, but the structure of the table is retained.
B. All data in the table is deleted, and the table structure is also deleted.
C. You cannot roll back this statement.
D. All indexes based on the DEPT table are dropped.
E. All synonyms based on the DEPT table are deleted.
F. All pending transactions are committed.
G. Allviews based on the DEPT table are deleted.

問題 #2

Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement?
(Choose all that apply.)

A. The HAVING clause can be used with aggregate functions in subqueries.
B. The WHERE and HAVING clauses can be used in the same statement only if they are applied to different columns in the table.
C. The aggregate functions and columns used in the HAVING clause must be specified in the SELECT list of the query.
D. The WHERE clause can be used to exclude rows after dividing them into groups.
E. The WHERE clause can be used to exclude rows before dividing them into groups.

問題 #3

Which constraint can be defined only at the column level?

A. NOT NULL
B. CHECK
C. UNIQUE
D. FOREIGN KEY
E. PRIMARY KEY

問題 #4

View the Exhibit and examine the structure of the PROMOTIONS table.
You need to generate a report of all promos from the PROMOTIONS table based on the following conditions:
1.The promo name should not begin with 'T' or 'N'.
2.The promo should cost more than $20000.
3.The promo should have ended after 1st January 2001.
Which WHERE clause would give the required result?

A. WHERE promo_name NOT LIKE 'T%' OR promo_name NOT LIKE 'N%' AND promo_cost > 20000 AND promo_end_date > '1-JAN-01'
B. WHERE (promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%')OR promo_cost > 20000 OR promo_end_date > '1-JAN-01'
C. WHERE (promo_name NOT LIKE '%T%' OR promo_name NOT LIKE '%N%') AND(promo_cost > 20000 AND promo_end_date > '1-JAN-01')
D. WHERE promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%' AND promo_cost > 20000 AND promo_end_date > '1-JAN-01'

問題 #5

You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.
Which set of statements accomplishes this?

A. CREATE NEW ROLE registrar; GRANT ALL ON student_grades TO registrar; GRANT registrar to user1, user2, user3
B. CREATE registrar; GRANT CHANGE ON student_grades TO registrar; GRANT registrar;
C. CREATE ROLE registrar; GRANT MODIFY ON student_grades TO registrar; GRANT registrar to user1, user2, user3
D. CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT registrar to user1, user2, user3;
E. CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT ROLE registrar to user1, user2, user3

問題與答案：