Examine this SQL statement:

Which two are true?

• A.The subquery is not a correlated subquery.
• B.The subquery is executed for every row in the employees table.
• C.The DELETE statement executes successfully even if the subquery selects multiple rows.
• D.The subquery is executed before the DELETE statement is executed.
• E.All existing rows in the EMPLOYEES table are deleted.

Comment: *

Name: *

Email: *

Verification: *

Examine these statements:

Which two are true?

• A.The create TABLE EMP statement must precede the create table DEPT statement for all three statements to execute successfully.
• B.The DEPT_FKEY constraint definition must be removed from the CREATE TABLE DEPT statement. and the added with an D. ALTER statement once both tables are created, for the two CREATE TABLE statements to execute successfully in the order shown.
• C.All three statements execute successfully in the order shown.
• D.The MGR column In the DEPT table will not be able to contain null values.
• E.Both foreign key constraint definition must be removed from the CREATE statements, and be added with ALTER TABLE statements once both tables are created, for the two CREATE TABLE statements to execute successfully in the order shown.
• F.The DEPTNO column in the EMP table will be able to contain null values.

Comment: *

Name: *

Email: *

Verification: *

Which two tasks can be performed by using Oracle SQL statements?

• A.changing the password for an existing database user
• B.connecting to a database instance
• C.querying data from tables across databases
• D.starting up a database instance
• E.executing operating system (OS) commands in a session

Comment: *

Name: *

Email: *

Verification: *

You want to display 5 percent of the rows from the SALEStable for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLDeven if this causes the output to exceed 5 percent of the rows.
Which query will provide the required result?

• A.SELECT prod_id, cust_id, amount_sold
  FROM sales
  ORDER BY amount_sold
  FETCH FIRST 5 PERCENT ROWS WITH TIES;
• B.SELECT prod_id, cust_id, amount_sold
  FROM sales
  ORDER BY amount_sold
  FETCH FIRST 5 PERCENT ROWS WITH TIES ONLY;
• C.SELECT prod_id, cust_id, amount_sold
  FROM sales
  ORDER BY amount_sold
  FETCH FIRST 5 PERCENT ROWS ONLY;
• D.SELECT prod_id, cust_id, amount_sold
  FROM sales
  ORDER BY amount_sold
  FETCH FIRST 5 PERCENT ROWS ONLY WITH TIES;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the SALES and PRODUCTS tables. (Choose two.)

In the SALES table, PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table. You must list each product ID and the number of times it has been sold.
Examine this query which is missing a JOIN operator:
SQL > SELECT p.prod_id, count(s.prod_id)
FROM products p ______________ sales s
ON p.prod_id = s.prod_id
GROUP BY p.prod_id;
Which two JOIN operations can be used to obtain the required output?

• A.LEFT OUETR JOIN
• B.JOIN
• C.FULL OUTER JOIN
• D.RIGHT OUTER JOIN

Comment: *

Name: *

Email: *

Verification: *