Examine the structure of the BOOKS_TRANSACTIONStable.

You want to update this table such that BOOK_IDis set to 'INVALID'for all rows where no MEMBER_ID has been entered.
Examine this partial SQL statement:

Which condition must be used in the WHEREclause to perform the required update?
MEMBER_ID = '';

• A.MEMBER_ID = NULL;
• B.MEMBER_ID IS NULL;
• C.
• D.MEMBER_ID = "";

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. (Choose the best answer.)

You executed this UPDATE statement:

Which statement is true regarding the execution?

• A.It would not execute because a SELECT statement cannot be used in place of a table name.
• B.It would execute and restrict modifications to the columns specified in the SELECT statement.
• C.It would not execute because two tables cannot be referenced in a single UPDATE statement.
• D.It would not execute because a subquery cannot be used in the WHERE clause of an UPDATE statement.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following SELECT statement and view the Exhibit to examine its output:

SELECT constraint_name, constraint_type, search_condition, r_constraint_name, delete_rule, status FROM user_constraints WHERE table_name = ORDERS
Which two statements are true about the output? (Choose two.)

• A.The column DELETE_RULE decides the state of the related rows in the child table when the corresponding row is deleted from the parent table.
• B.In the second column, indicates a check constraint.
• C.The R_CONSTRAINT_NAME column gives the alternative name for the constraint.
• D.The STATUS column indicates whether the table is currently in use.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure in the EMPLOYEES tables.

Evaluate the following SQL statement:
SELECT employee_id, department_id
FROM employees
WHERE department_id= 50 ORDER BY department_id
UNION
SELECT employee_id, department_id
FROM employees
WHERE department_id=90
UNION
SELECT employee_id, department_id
FROM employees
WHERE department_id=10;
What would be the outcome of the above SQL statement?

• A.The statement would execute successfully and display all the rows in the ascending order of DEPARTMENT_ID.
• B.The statement would execute successfully but it will ignore the ORDER BY clause and display the rows in random order.
• C.The statement would not execute because the positional notation instead of the column name should be used with the ORDER BY clause.
• D.The statement would not execute because the ORDER BY clause should appear only at the end of the SQL statement, that is, in the last SELECT statement.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the EMPLOYEES table.

You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and who have salaries greater than 10000.
Which query would retrieve the required result?

• A.SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id = (SELECT employee_id FROM employees WHERE employee_id = '100')UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE-180INTERSECTSELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000;
• B.SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALLSELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100)INTERSECTSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE-180;
• C.(SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALLSELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100))UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE-180;
• D.SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id = (SELECT employee_id FROM employees WHERE employee_id = 100)UNION ALL(SELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE-180INTERSECTSELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000);

Comment: *

Name: *

Email: *

Verification: *