Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the storage of data in the above table structure? (Choose two.)

• A.The TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, and seconds.
• B.The CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of
  4,000 characters.
• C.The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format.
• D.The CUST_CREDIT_VALUE column would allow storage of positive and negative integers.

Comment: *

Name: *

Email: *

Verification: *

Which statement will return the last sequence number generated by the EMP_ SEQ sequence?

• A.SELECT CURRVAL FROM emp_ seq;
• B.SELECT emp_ seq . NEXTVAL FROM DUAL;
• C.SELECT NEXTVAL FROM emp_ seq;
• D.SELECT emp_ seq. CURRVAL FROM DUAL;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the SALESand PRODUCTStables. (Choose two.)

In the SALEStable, 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 JOINoperator:

Which two JOINoperations can be used to obtain the required output? (Choose two.) FULL OUTER JOIN

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

Comment: *

Name: *

Email: *

Verification: *

Sales data of a company is stored in two tables, SALES1and SALES2, with some data being duplicated across the tables. You want to display the results from the SALES1table, which are not present in the SALES2table.

Which set operator generates the required output?
INTERSECT

• A.UNION
• B.PLUS
• C.MINUS
• D.SUBTRACT
• E.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.

The CUSTOMERS table contains the current location of all currently active customers.
The CUST_HISTORY table stores historical details relating to any changes in the location of all current as well as previous customers who are no longer active with the company.
You need to find those customers who have never changed their address.
Which SET operator would you use to get the required output?

• A.INTERSECT
• B.UNION ALL
• C.MINUS
• D.UNION

Comment: *

Name: *

Email: *

Verification: *