View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables.
ORDER_ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table wherein it is created with the ON DELETE CASCADE option.
Which DELETE statement would execute successfully?

• A.DELETE order_idFROM ordersWHERE order_total < 1000;
• B.DELETE orders o, order_items IWHERE o.order_id = i.order_id;
• C.DELETE ordersWHERE order_total < 1000;
• D.DELETEFROM ordersWHERE (SELECT order_idFROM order_items);

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the data in the EMPLOYEES table.
Exhibit

You want to generate a report showing the total compensation paid to each employee to date.
You issue the following query:

What is the outcome?

• A.It generates an error because the concatenation operator can be used to combine only two items.
• B.It generates an error because the usage of the ROUNDfunction in the expression is not valid.
• C.IT executes successfully and gives the correct output.
• D.It executes successfully but does not give the correct output.
• E.It generates an error because the alias is not valid.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the ORDERS table:

Which three statements execute successfully?

• A.SELECT order_ id, order_ data FROM orders
  UNION ALL
  SELECT invoice_ id, invoice_ data FROM invoices ORDER BY order_ id;
• B.SELECT order_ id, invoice_ data order_ date FROM orders
  MINUS
  SELECT invoice_ id, invoice_ data FROM invoices ORDER BY invoice_ id;
• C.SELECT * FROM orders ORDER BY order_ id
  UNION
  SELECT * FROM invoices;
• D.SELECE order _id, order _ date FRON orders
  LNTERSECT
  SELECT invoice_ id, invoice_ id, order_ date FROM orders
• E.(SELECT * FROM orders
  UNION ALL
  SELECT* FROM invoices) ORDER BY order _id;
• F.SELECT * FROM orders ORDER BY order_ id
  INTERSEOT
  SELECT * FROM invoices ORDER BY invoice_ id;
• G.SELECT * FROM orders
  MINUS
  SELECT * FROM INVOICES ORDER BY 1

Comment: *

Name: *

Email: *

Verification: *

Table ORDER_ITEMS contains columns ORDER_TO, UNIT_PRICE and QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:

Statement 2:

Which two statements are true? (Choose two.)

• A.Statement 2 may return multiple rows of output.
• B.Both statements will return NULLif either UNIT_PRICEor QUANTITYcontains NULL.
• C.Statement 2 returns only one row of output.
• D.Both the statements give the same output.
• E.Statement 1 returns only one row of output.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding the data types? (Choose three.)

• A.The minimum column width that can be specified for a VARCHAR2data type column is one.
• B.The value for a CHARdata type column is blank-padded to the maximum defined column width.
• C.A TIMESTAMPdata type column stores only time values with fractional seconds.
• D.Only one LONGcolumn can be used per table.
• E.The BLOBdata type column is used to store binary data in an operating system file.

Comment: *

Name: *

Email: *

Verification: *