本番の時間配分に不安がある場合は、1z1-071の模擬試験形式で解答ペースを確認する練習が役立ちます。Oracle Database SQLに対応したFast2testの437問の問題集なら、知識の定着と時間管理をあわせて鍛えられます。

1z1-071試験対策に選べる3つの学習形式

• PDF版：印刷して持ち運べる形式で、専門家が作成した内容をすぐにダウンロードして確認できます。学習場所を選ばず、365日間の無料更新と無料PDFサンプルに対応しています。
• Desktop Test Engine：インストールして使用するソフトウェアで、実際の試験環境を再現した2つの練習モードを利用できます。オフライン学習に対応し、Windowsで動作します。
• Online Test Engine：ブラウザーからすぐにアクセスでき、学習履歴と成績を確認できます。Windows、Mac、Android、iOSで利用できます。

Fast2testの安心な購入・利用サポート

• McAfeeのセキュリティサービスにより、お客様の情報を安全に取り扱います。
• ご購入後365日間は無料で更新版をご利用いただけます。更新期間の終了後も、50%割引で継続更新が可能です。
• ご入金確認後はすぐにダウンロードでき、通常1分以内にメールでもお届けします。2時間経っても届かない場合は、カスタマーサポートへご連絡ください。
• インストール可能なパソコン台数に制限はありません。

Oracle Database SQLの試験情報

Oracle 1z1-071 試験概要:

1z1-071試験の出題範囲

Oracle 1z1-071 試験シラバストピック:

1z1-071試験の疑問を解消するFAQ

Oracle Database SQL 認定 1z1-071 試験問題：

問題 #1

In your session, the NLS_DATE_FORMATis DD-MM-YYYY.
There are 86400 seconds in a day.
Examine this result:
DATE
-----------
02-JAN-2020
Which statement returns this?

A. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '6' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;
B. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;
C. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '3' MONTH + INTERVAL '7' DAY - INTERVAL '360' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;
D. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '4' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;
E. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5' DAY - INTERVAL '86410' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

問題 #2

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

A. ALTER TABLE TRUNCATE PARTITION
B. ALTER TABLE MERGE PARTITION
C. ALTER TABLE ADD PARTITION
D. ALTER TABLE SPLIT PARTITION
E. ALTER TABLE DROP PARTITION
F. ALTER TABLE MOVE PARTITION

問題 #3

View the Exhibit and examine the data in ORDERS and ORDER_ITEMS tables.
You need to create a view that displays the ORDER ID, ORDER_DATE, and the total number of items in each order.

Which CREATE VIEW statement would create the view successfully?

A. CREATE OR REPLACE VIEW ord_vu
AS SELECT o.order_id, o.order_date, COUNT(i.line_item_id) FROM orders o JOIN order_items i ON (o.order_id = i.order_id) GROUP BY o.order_id,o.order_date;
B. CREATE OR REPLACE VIEW ord_vu
AS SELECT o.order_id, o.order_date, COUNT(i.line_item_id) "NO OF ITEMS" FROM orders o JOIN order_items i ON (o.order_id = i.order_id) GROUP BY o.order_id,o.order_date;
C. CREATE OR REPLACE VIEW ord_vu (order_id,order_date) AS SELECT o.order_id, o.order_date, COUNT(i.line_item_id) "NO OF ITEMS" FROM orders o JOIN order_items i ON (o.order_id = i.order_id) GROUP BY o.order_id,o.order_date;
D. CREATE OR REPLACE VIEW ord_vu
AS SELECT o.order_id, o.order_date, COUNT(i.line_item_id)ll' NO OF ITEMS' FROM orders o JOIN order_items i ON (o.order_id = i.order_id) GROUP BY o.order_id,o.order_date WITH CHECK OPTION;

問題 #4

View the exhibit and examine the structure and data in the INVOICE table.

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

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

問題 #5

You issue this command which succeeds:
SQL> DROP TABLE products;
Which three statements are true?

A. Table data is deleted but the table structure is retained.
B. All existing views and synonyms that refer to the table are invalidated but retained.
C. Any uncommitted transaction in the session is committed.
D. All the table's indexes if any exist, are invalidated but retained.
E. Table data and the table structure are deleted.

解説：