The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER(8, 2).
Evaluate this SQL statement:
SELECT TO_CHAR(unit_price,'$9,999') FROM PRODUCT_INFORMATION;
Which two statements are true about the output?

• A.A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,023.
• B.A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as #####
• C.A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,024.
• D.A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,023.
• E.A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,0236.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibits and examine PRODUCTS and 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 executes successfully and produces the required output.
• B.The statement produces an error because a subquery in the FROM clause and outer- joins cannot be used together.
• C.The statement produces an error because ITEM_CNT cannot be displayed in the outer query.
• D.The statement produces an error because the GROUP BY clause cannot be used in a subquery in the FROM clause.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following SQL query;

What would be the outcome?

• A.200
• B.16
• C.160
• D.150
• E.100

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about conditional INSERT ALL?

• A.Each row returned by the subquery can be inserted into only a single target table.
• B.It cannot have an ELSE clause.
• C.The total number of rows inserted is always equal to the number of rows returned by the subquery
• D.A single WHEN condition can be used for multiple INTO clauses.
• E.Each WHEN condition is tested for each row returned by the subquery.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the BOOKS_TRANSACTIONS table:

Which two WHERE conditions give the same result?

• A.WHERE borrowed_date = SYSDATE AND (transaction_type ='RM' OR member_id IN ('A101','A102'));
• B.WHERE borrowed_date = SYSDATE AND transaction_type ='RM' OR member_id IN ('A101','A102');
• C.WHERE borrowed_date = SYSDATE AND (transaction_type ='RM' AND member_id='A101' OR member_id ='A102'));
• D.WHERE (borrowed_date = SYSDATE AND transaction_type ='RM') OR member_id IN ('A101','A102');
• E.WHERE borrowed_date = SYSDATE AND (transaction_type ='RM' AND (member_id ='A101' OR member_id ='A102') );

Comment: *

Name: *

Email: *

Verification: *