A.  The CREATE TABLE AS SELECT statement can be used to upload data into a normal table in the database from an external table.

B.  The data and metadata for an external table are stored outside the database.

C.  The default REJECT LIMIT for external tables is UNLIMITED.

D.  ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table.

A.  SELECT product_id, expiry_date * 2 FROM products;

B.  SELECT product_id, (expiry_date - delivery_date) * 2 FROM products;

C.  SELECT product_id, unit_price, 5 "Discount", unit_price + surcharge - discount FROM products;

D.  SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;

E.  SELECT product_id, unit_price, unit_price + surcharge FROM products;

F.  SELECT product_id, unit_price | | 5 "Discount", unit_price + surcharge - discount FROM products;

A.  SELECT SYSDATE - TO_DATE('01-JANUARY-2019*) FROM DUAL;

B.  SELECT TO_CHAR(SYSDATE, *DD-MON-YYYY*) - '01-JAN-2019' FROM DUAL;

C.  SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;

D.  SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;

E.  SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY") - '01/JANUARY/2019" FROM DUAL;

A.  すべての SELECT ステートメントの列の名前は同一である必要があります。

B.  NULL は無視されます。

C.  列の数とデータ型は、クエリ内のすべての SELECT ステートメントで同一である必要があります。
INTERSECT 両方のクエリの結果セットに含まれる行のみを返し、それらを並べ替えて重複を削除します。
複合クエリを構成するクエリ内の列には異なる名前を付けることができますが、出力結果セットでは最初のクエリ内の列の名前が使用されます。

D.  交差するテーブルの順序を逆にすると、結果が変わります。

A.  The DEPARTMENT_ID column can be recovered from the recycle bin

B.  The DEPARTMENT_ID column is set to null for all tows in the table

C.  No updates can be made to the data in the DEPARTMENT_ID column.

D.  A query can display data from the DEPARTMENT_ID column.

E.  A new column with the name DEPARTMENT_ID can be added to the EMPLOYEES table.

F.  The storage space occupied by the DEPARTMENT_ID column is released only after a COMMIT is issued.