View the Exhibits and examine PRODUCTSand SALES tables.
Exhibit 1

Exhibit 2

You issue the following query to display product name the number of times the product has been sold:

What happens when the above statement is executed?

• A.The statement produces an error because a subquery in the FROMclause and outer-joins cannot be used together.
• B.The statement executes successfully and produces the required output.
• C.The statement produces an error because ITEM_CNTcannot be displayed in the outer query.
• D.The statement produces an error because the GROUP BYclause cannot be used in a subquery in the FROMclause.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about multiple row subqueries? (Choose three.)

• A.They can contain GROUP BY clauses.
• B.They cannot contain a subquery.
• C.Two or more values are always returned from the subquery.
• D.They can return multiple columns.
• E.They can contain HAVINGclauses.

Comment: *

Name: *

Email: *

Verification: *

Examine the description or the BOOKS_TRANSACTIONS table:

FOR customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

• A.SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
  FROM customers
  WHERE cust_income_level IS NOT NULL
  AND cust_credit_limit IS NOT NULL;
• B.SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
  FROM customers
  WHERE cust income_level <> NULL
  AND due_amount <> NULL;
• C.SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
  FROM customers
  WHERE cust income_level IS NOT NULL
  AND due_amount IS NOT NULL;
• D.SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
  FROM customers
  WHERE cust income_level !=NULL
  AND due_amount !=NULL;
• E.SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
  FROM customers
  WHERE cust income_level !=NULL
  AND cust credit_level !=NULL;

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about dropping and unused columns in an Oracle database?

• A.A drop column command can be rolled back.
• B.A primary key column referenced by another column as a foreign key can be dropped if using the cascade option.
• C.A column that is set to unused still counts towards the limit of 1000 columns per table.
• D.An unused column's space is reclaimed automatically when the block containing that column is next queried.
• E.An unused column's space is reclaimed automatically when the row containing that column is next queried.
• F.Partition key columns cannot be dropped.

Comment: *

Name: *

Email: *

Verification: *

In which three situations does a transaction complete?

• A.when a PL/SQL anonymous block is executed
• B.when a DELETE statement is executed
• C.when a ROLLBACK command is executed
• D.when a data definition language (DDL) statement is executed
• E.when a TRUNCATE statement is executed after the pending transaction

Comment: *

Name: *

Email: *

Verification: *