Which statement is true regarding transactions? (Choose all that apply.)

• A. A transaction can consist only of a set of DML and DDL statements.
• B. A part or an entire transaction can be undone by using ROLLBACK command.
• C. A transaction consists of a set of DML or DCL statements.
• D. A transaction can consist of only a set of queries or DML or DDL statements.
• E. A part or an entire transaction can be made permanent with a COMMIT.

Examine the structure of the SHIPMENTS table:

You want to generate a report that displays the PO_ID and the penalty amount to be paid if
the
SHIPMENT_DATE is later than one month from the PO_DATE. The penalty is $20 per day.
Evaluate the following two queries:

Which statement is true regarding the above commands?

• A. Only the first query executes successfully but gives a wrong result.
• B. Both execute successfully and give correct results.
• C. Only the first query executes successfully and gives the correct result.
• D. Only the second query executes successfully but gives a wrong result.
• E. Only the second query executes successfully and gives the correct result.

Examine the structure of the MARKS table: Exhibit:

Which two statements would execute successfully? (Choose two.)

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

Evaluate the following SQL statements: Exhibit:

You issue the following command to create a view that displays the IDs and last names of the sales staff in the organization.
Exhibit: Which two statements are true regarding the above view? (Choose two.)

• A. It allows you to insert rows into the EMPLOYEES table
• B. It allows you to insert IDs, last names, and job IDs of the sales staff from the view if it is used in multitable INSERT statements
• C. It allows you to delete details of the existing sales staff from the EMPLOYEES table
• D. It allows you to update job IDs of the existing sales staff to any other job ID in the EMPLOYEES table