Examine the description of the TRANSACTIONS table:

Which two SQL statements execute successfully?

• A.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;
• B.SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100 'DUES' FROM transactions;
• C.SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount +100 DUES FROM transactions;
• D.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;
• E.SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 "DUES AMOUNT" FROM transactions;

Comment: *

Name: *

Email: *

Verification: *

The PRODUCTStable has the following structure.

Evaluate the following two SQL statements:
SQL>SELECT prod_id, NVL2 (prod_expiry_date, prod_expiry_date + 15, ' ') FROM products; SQL>SELECT prod_id, NVL (prod_expiry_date, prod_expiry_date + 15) FROM products; Which statement is true regarding the outcome?

• A.Both the statements execute and give different results
• B.Only the second SQL statement executes successfully
• C.Both the statements execute and give the same result
• D.Only the first SQL statement executes successfully

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the CUSTOMERStable.

Which two tasks would require subqueries or joins to be executed in a single statement?

• A.finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers
• B.finding the number of customers, in each city, whose marital status is 'married'.
• C.listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'.
• D.finding the average credit limit of male customers residing in 'Tokyo'or 'Sydney'
• E.listing of customers who do not have a credit limit and were born before 1980

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the members table:

Which query can be used to display the last names and city names only for members from the states MO and MI?
A)

B)

C)

D)

• A.Option C
• B.Option D
• C.Option A
• D.Option B

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the data in the PRODUCTS table. (Choose the best answer.)

You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure.
You issue this query:
SQL > SELECT prod_name, prod_category, prod_min_price FROM products
Where prod_category LIKE '%Other%' AND (prod_min_price = 2000 OR prod_min_price = 4000) AND prod_unit_of_measure <> ' '; Which statement is true?

• A.It executes successfully and returns the required result.
• B.It generates an error because the condition specified for the PROD_CATEGORY column is not valid.
• C.It executes successfully but returns no result.
• D.It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.

Comment: *

Name: *

Email: *

Verification: *