You execute these commands:
SQL> DEFINE hiredate = '01-APR -2011';
SQL> SELECT employee_id, first_name, salary FROM employees WHERE hire date > &hiredate AND manager_id >&mgr_id; For which substitution variables will you be prompted?

View the exhibit and examine the structure of ORDERSand CUSTOMERStables.

Which INSERT statement should be used to add a row into the ORDERStable for the customer whose CUST_LAST_NAMEis Robertsand CREDIT_LIMITis 600? Assume there exists only one row with CUST_LAST_NAME as Roberts and CREDIT_LIMIT as 600.
INSERT INTO (SELECT o.order_id, o.order_date, o.order_mode, c.customer_id,

View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables.

Examine this query which must select the employee IDs of all the employees who have held the job SA_MAN at any time during their employment.
SELECT employee_id
FROM employees
WHERE job_id = 'SA_MAN'
-------------------------------------
SELECT employee_id
FROM job_history
WHERE job_id='SA_MAN';
Choose two correct SET operators which would cause the query to return the desired result. (Choose two.)

Examine the description of the EMPLOYEES table:

NLS_DATE_FORMAT is set to DD-MON-YY.
Which query requires explicit data type conversion?

資料を参照して、ORDER_ITEMS テーブルと ORDERS テーブルの構造を調べてください。

ORDER_ID、product_ID、および合計価格 (UNIT_PRICE に QUANTITY を掛けたもの) を取得するように求められます。合計価格は 50,000 を超えます。
次の SQL ステートメントを実行しました。
SELECTprder_id、product_id、unit_price*数量「合計価格」
order_items から
WHERE 単価*数量 > 50000
NATURAL JOIN 命令。
ステートメントの実行に関して正しいのはどれですか?