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

• A.Rows added through a view are deleted from the table automatically when the view is dropped.
• B.The OR REPLACEoption is used to change the definition of an existing view without dropping and re- creating it.
• C.Rows cannot be deleted through a view if the view definition contains the DISTINCTkeyword.
• D.A simple view in which column aliases have been used cannot be updated.
• E.The WITH CHECK OPTIONconstraint can be used in a view definition to restrict the columns displayed through the view.
• F.A subquery used in a complex view definition cannot contain group functions or joins.

Comment: *

Name: *

Email: *

Verification: *

Choose two
Examine the description of the PRODUCT DETALS table:

• A.PRODUCT_PRICE contains the value zero by default if no value is assigned to it.
• B.PRODUCT_NAME cannot contain duplicate values.
• C.EXPIRY_DATE cannot be used in arithmetic expressions.
• D.PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it
• E.PRODUCT_ID can be assigned the PEIMARY KEY constraint.
• F.EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it

Comment: *

Name: *

Email: *

Verification: *

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

Which two tasks would require subqueries? (Choose two.)

• A.display the total number of products supplied by supplier 102 and have product status as 'OBSOLETE'
• B.display all products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
• C.display the minimum PROD_LIST_PRICE for each product status
• D.display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE.
• E.display suppliers whose PROD_LIST_PRICE is less than 1000

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the description of the EMPLOYEEStable.

Evaluate the following SQL statement:
SELECT first_name, employee_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) "Review" FROM employees; The query was written to retrieve the FIRST_NAME, EMPLOYEE_ID,and review date for employees. The review date is the firsts Monday after the completion of six months of the hiring. The NLS_TERRITORY parameter is set to AMERICAin the session.
Which statement is true regarding this query?

• A.The query would execute to give the desired output.
• B.The query would not execute because the NEXT_DAYfunction accepts a string as argument.
• C.The query would not execute because date functions cannot be nested.
• D.The query would execute but the output would give review dates that are Sundays.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following statement.
INSERT ALL
WHEN order_total < 10000 THEN
INTO small_orders
WHEN order_total > 10000 AND order_total < 20000 THEN
INTO medium_orders
WHEN order_total > 200000 AND order_total < 20000 THEN
INTO large_orders
SELECT order_id, order_total, customer_id
FROM orders;
Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?

• A.They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
• B.They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.
• C.They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.
• D.The insert statement would give an error because the ELSE clause is not present for support in case none of WHEN clauses are true.

Comment: *

Name: *

Email: *

Verification: *