No-user-defined locks are used in your database.
Which three are true about Transaction Control Language (TCL)?

• A.COMMITerases all the transaction's savepoints and releases its locks.
• B.ROLLBACK TO SAVEPOINT undoes the transaction's changes made since the named savepoint and then ends the transaction.
• C.COMMITends the transaction and makes all its changes permanent.
• D.ROLLBACKwithout the TO SAVEPOINT clause undoes all the transaction's changes but does not erase its savepoints.
• E.ROLLBACKwithout the TO SAVEPOINT clause undoes all the transaction's changes but does not release its locks.
• F.ROLLBACKwithout the TO SAVEPOINT clause undoes all the transaction's changes, releases its locks and erases its savepoints.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine PRODUCTS and ORDER_ITEMS tables.

You executed the following query to display PRODUCT_NAME and the number of times the product has been ordered:
SELECT p.product_name, i.item_cnt
FROM (SELECT product_id, COUNT (*) item_cnt
FROM order_items
GROUP BY product_id) i RIGHT OUTER JOIN products p
ON i.product_id = p.product_id;
What would happen when the above statement is executed?

• A.The statement would not execute because inline views and outer joins cannot be used together.
• B.The statement would execute successfully to produce the required output.
• C.The statement would not execute because the ITEM_CNT alias cannot be displayed in the outer query.
• D.The statement would not execute because the GROUP BY clause cannot be used in the inline.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMPLOYEES table:

You write this failing statement:
SELECT dept_no AS department_id, MAX (salary) As max_sal
FROM employees
WHERE salary >10000
GROUP BY department_id
ORDER BY max_sal;
Which clause causes the error?

• A.WHERE
• B.ORDER BY
• C.GROUP BY
• D.SELECT

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the MARKStable:

Which two statements would execute successfully? (Choose two.)
SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1)

• A.FROM marks
  WHERE student_name LIKE 'R%';
• B.FROM marks
  WHERE subject1 > AVG(subject1);
  SELECT SUM(subject1+subject2+subject3)
• C.FROM marks
  WHERE student_name IS NULL;
  SELECT student_name,SUM(subject1)
• D.FROM marks
  WHERE subject1 > subject2;
  SELECT student_name subject1

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the description of the DEPARTMENTS and EMPLOYEES tables.

You wrote this SQL statement to retrieve EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, for all employees:
SELECT employee_id, first_name, department_name
FROM employees
NATURAL JOIN departments;
The desired output is not obtained after executing the above SQL statement. What could be the reason for this?

• A.The table prefix is missing for the column names in the SELECT clause.
• B.The NATURAL JOIN clause is missing the USING clause.
• C.The DEPARTMENTS table is not used before the EMPLOYEES table in the FROM clause.
• D.The EMPLOYEES and DEPARTMENTS tables have more than one column with the same column name and data type.

Comment: *

Name: *

Email: *

Verification: *