Examine this data in the EMPLOYEES table:

Which statement will execute successfully?
Which statement will execute successfully?

• A.SELECT dept_id, MAX (last_name) . SUM(salary) FROM employees GROUP BY dept_id;
• B.SELECT dept_id, STDDEV(last_name), SUM( salary) FROM employees GROUP BV dept_id;
• C.SELECT dept_id( INSTR(last_name, 'A'), SUM (salary) FROM employees GROUP BY dept_id;
• D.SELECT dept_id, LENGTH (last: name) , SUM(salary) FROM employees GROUP BV dept_id;

Comment: *

Name: *

Email: *

Verification: *

The first DROP operation is performed on PRODUCTS table using this command:
DROP TABLE products PURGE;
Then a FLASHBACK operation is performed using this command:
FLASHBACK TABLE products TO BEFORE DROP;
Which is true about the result of the FLASHBACK command?

• A.It recovers only the table structure.
• B.It recovers the table structure, data, and the indexes.
• C.It recovers the table structure and data but not the related indexes.
• D.It is not possible to recover the table structure, data, or the related indexes.

Comment: *

Name: *

Email: *

Verification: *

A non-correlated subquery can be defined as __________. (Choose the best answer.)

• A.A set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query.
• B.A set of sequential queries, all of which must return values from the same table.
• C.A set of sequential queries, all of which must always return a single value.
• D.A SELECT statement that can be embedded in a clause of another SELECT statement only.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about multitable insert statements?

• A.The conditional insert first statement always Inserts a row Into a single table.
• B.They can transform a row from a source table Into multiple rows In a target table.
• C.They always use subqueries.
• D.The conditional insert all statement inserts rows into a single table by aggregating source rows.
• E.The unconditional insert all statement must have the same number of columns In both the source and target tables.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure in ORDERS and ORDER_ITEMS tables.

You need to create a view that displays the ORDER_ID, ORDER_DATE, and the total number of items in each order.
Which CREATE VIEW statement would create the view successfully?

• A.CREATE OR REPLACE VIEW ord_vu (order_id, order_date)AS SELECT o.order_id, o.order_date, COUNT(i.line_item_id)"NO OF ITEMS"FROM orders o JOIN order_items iON (o.order_id = i.order_id)GROUP BY o.order_id, o.order_date;
• B.CREATE OR REPLACE VIEW ord_vuAS SELECT o.order_id, o.order_date,
  COUNT(i.line_item_id)||'NO OF ITEMS'FROM orders o JOIN order_items iON (o.order_id = i.order_id)GROUP BY o.order_id,o.order_dateWHITH CHECK OPTION;
• C.CREATE OR REPLACE VIEW ord_vuAS SELECT o.order_id, o.order_date,
  COUNT(i.line_item_id)FROM orders o JOIN order_items iON (o.order_id = i.order_id)GROUP BY o.order_id,o.order_date;
• D.CREATE OR REPLACE VIEW ord_vuAS SELECT o.order_id, o.order_date,
  COUNT(i.line_item_id)"NO OF ITEMS"FROM orders o JOIN order_items iON (o.order_id = i.order_id)GROUP BY o.order_id,o.order_date;

Comment: *

Name: *

Email: *

Verification: *