The customers table has the following structure:
You need to write a query that does the following tasks:
1. Display the first name and tax amount of the customers. Tax is 5% of their credit limit.
2. Only those customers whose income level has a value should be considered.
3. Customers whose tax amount is null should not be considered.
Which statement accomplishes all the required tasks?

• A.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNTFROM customersWHERE cust_income_level <> NULL ANDtax_amount <> NULL;
• B.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNTFROM customersWHERE cust_income_level IS NOT NULL ANDtax_amount IS NOT NULL;
• C.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNTFROM customersWHERE cust_income_level IS NOT NULL ANDcust_credit_limit IS NOT NULL;
• D.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNTFROM customersWHERE (cust_income_level, tax_amount) IS NOT NULL;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the PRODUCT_INFORMATIONand INVENTORIEStables.

You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID, and QUANTITY_ON_HANDfor all the products wherein QUANTITY_ON_HANDis less than five.
Which two SQL statements can accomplish the task? (Choose two.)
SELECT i.product_id, i.quantity_on_hand, pi.supplier_id

• A.FROM product_information pi JOIN inventories i
  USING (product_id) AND quantity_on_hand < 5;
• B.FROM product_information pi JOIN inventories i
  ON (pi.product_id=i.product_id)
  WHERE quantity_on_hand < 5;
  SELECT product_id, quantity_on_hand, supplier_id
• C.FROM product_information pi JOIN inventories i
  ON (pi.product_id=i.product_id) AND quantity_on_hand < 5;
  SELECT i.product_id, i.quantity_on_hand, pi.supplier_id
• D.FROM product_information
  NATURAL JOIN inventories AND quantity_on_hand < 5;
  SELECT i.product_id, i.quantity_on_hand, pi.supplier_id

Comment: *

Name: *

Email: *

Verification: *

The SALES table has columns PROD_IDand QUANTITY_SOLDof data type NUMBER.
Which two queries execute successfully? (Choose two.)

• A.prod_id;
  SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP
• B.SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING
• C.BY prod_id HAVING COUNT(*) >10;
  SELECT COUNT (prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY
• D.COUNT(*) >10;
  SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP
• E.BY COUNT(*) >10;
  SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about sequences created in a single instance database? (Choose two.)

• A.CURRVAL is used to refer to the last sequence number that has been generated
• B.DELETE <sequencename> would remove a sequence from the database
• C.The numbers generated by a sequence can be used only for one table
• D.When the MAXVALUE limit for a sequence is reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement
• E.When a database instance shuts down abnormally, the sequence numbers that have been cached but not used would be available once again when the database instance is restarted

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the SALES table. (Choose two.)

Examine this statement:
SQL > CREATE TABLE sales1 (prod_id, cust_id, quantity_sold, price)
AS
SELECT product_id, customer_id, quantity_sold, price
FROM sales
WHERE 1 = 2;
Which two statements are true about the SALES1 table?

• A.It will have NOT NULL constraints on the selected columns which had those constraints in the SALES table.
• B.It will not be created because of the invalid WHERE clause.
• C.It will not be created because the column-specified names in the SELECT and CREATE TABLE clauses do not match.
• D.It has PRIMARY KEY and UNIQUE constraints on the selected columns which had those constraints in the SALES table.
• E.It is created with no rows.

Comment: *

Name: *

Email: *

Verification: *