想在正式上場前先感受真實考試的節奏嗎？Fast2test 的 1Z0-051 桌面測試引擎完整模擬 Oracle Database: SQL Fundamentals I 的考試環境，搭配 2026 年持續更新的題庫，讓每一次模考都更接近實戰。

Oracle 1Z0-051 考試概覽:

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

Oracle Database: SQL Fundamentals I 考生常見問題解答

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

問題 #1

The user Sue issues this SQL statement:
GRANT SELECT ON sue.EMP TO alice WITH GRANT OPTION;
The user Alice issues this SQL statement:
GRANT SELECT ON sue.EMP TO reena WITH GRANT OPTION;
The user Reena issues this SQL statement:
GRANT SELECT ON sue.EMP TO timber;
The user Sue issues this SQL statement:
REVOKE select on sue.EMP FROM alice;
For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?

A. Sue, Alice, Reena, and Timber
B. Alice and Reena
C. Alice, Reena, and Timber
D. Alice only

問題 #2

You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:
Exhibit:

PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table.
What is the outcome?

A. Number of days since the promo started based on the current Chicago data and time
B. An error because the WHERE condition specified is invalid
C. An error because the ROUND function specified is invalid
D. Number of days since the promo started based on the current Singapore data and time.

問題 #3

View the Exhibits and examine the structures of the PRODUCTS SALES and CUSTOMERS tables.

You need to generate a report that gives details of the customer's last name, name of the product, and the quantity sold for all customers in Tokyo'. Which two queries give the required result? (Choose two.)

A. SELECT c.cust_id,c.cust_last_name,p.prod_id, p.prod_name, s.quantity_sold FROM
products p JOIN sales s
USING(prod_id)
JOIN customers c
USING(cust_id)
WHERE c.cust_city='Tokyo';
B. SELECT c.cust_last_name,p.prod_name, s.quantity_sold FROM sales s JOIN products p
USING(prod_id)
JOIN customers c
USING(cust_id)
WHERE c.cust_city='Tokyo';
C. SELECT c.cust_last_name, p.prod_name, s.quantity_sold
FROM products p JOIN sales s
ON(p.prod_id=s.prod_id)
JOIN customers c
ON(s.cust_id=c.cust_id)
AND c.cust_city='Tokyo';
D. SELECT c.cust_last_name, p.prod_name, s.quantity_sold
FROM products p JOIN sales s JOIN customers c
ON(p.prod_id=s.prod_id)
ON(s.cust_id=c.cust_id)
WHERE c.cust_city='Tokyo';

問題 #4

See the Exhibit and examine the structure and data in the INVOICE table: Exhibit:

Which two SQL statements would execute successfully? (Choose two.)

A. SELECT MAX(AVG(SYSDATE-inv_date)) FROM invoice;
B. SELECT AVG(inv_date-SYSDATE),AVG(inv_amt) FROM invoice;
C. SELECT AVG(inv_date) FROM invoice;
D. SELECT MAX(inv_date),MIN(cust_id) FROM invoice;

問題 #5

View the Exhibit; e xamine the structure of the PROMOTIONS table.

Each promotion has a duration of at least seven days.
Your manager has asked you to generate a report, which provides the weekly cost for each promotion done to l date.
Which query would achieve the required result?

A. SELECT promo_name,(promo_cost/promo_end_date-promo_begin_date)/7 FROM promotions;
B. SELECT promo_name, promo_cost/((promo_end_date-promo_begin_date)/7) FROM promotions;
C. SELECT promo_name, promo_cost/promo_end_date-promo_begin_date/7 FROM promotions;
D. SELECT promo_name, promo_cost/(promo_end_date-promo_begin_date/7) FROM promotions;

問題與答案：