1Z0-047 試験問題を無料オンラインアクセス

View the Exhibit and examine the description of the ORDERS table.
Evaluate the following SQL statement:
SELECT order_id, customer_id FROM orders WHERE order_date > 'June 30 2001';
Which statement is true regarding the execution of this SQL statement?

• A.It would execute and would return ORDER_ID and CUSTOMER_ID for all records having ORDER_DATE greater than 'June 30 2001'.
• B.It would not execute because 'June 30 2001' in the WHERE condition cannot be converted implicitly and needs the use of the TO_DATE conversion function for proper execution.
• C.It would not execute because 'June 30 2001' in the WHERE condition is not enclosed within double quotation marks.
• D.It would not execute because 'June 30 2001' in the WHERE condition cannot be converted implicitly and needs the use of the TO_CHAR conversion function for proper execution.

Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)

• A.The nested query executes first and then the outer query executes.
• B.Each row returned by the outer query is evaluated for the results returned by the inner query.
• C.The outer query executes only once for the result returned by the inner query.
• D.The nested query executes after the outer query returns the row.

View the Exhibit and examine the structure of the EMP table.

You executed the following command to add a primary key to the EMP table:
ALTER TABLE emp
ADD CONSTRAINT emp_id_pk PRIMARY KEY (emp_id)
USING INDEX emp_id_idx;
Which statement is true regarding the effect of the command?

• A.The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.
• B.The PRIMARY KEY would be created in a disabled state because it is using an existing index.
• C.The PRIMARY KEY is created and it would use an existing unique index.
• D.The PRIMARY KEY is created along with a new index.

Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)

• A.The nested query executes first and then the outer query executes.
• B.Each row returned by the outer query is evaluated for the results returned by the inner query.
• C.The outer query executes only once for the result returned by the inner query.
• D.The nested query executes after the outer query returns the row.

Which two statements are true regarding constraints? (Choose two.)

• A.A constraint can be disabled even if the constraint column contains data.
• B.A column with the UNIQUE constraint can contain NULL.
• C.All the constraints can be defined at the column level as well as the table level
• D.A constraint is enforced only for the INSERT operation on a table.
• E.A foreign key cannot contain NULL values.