View the Exhibit and examine the structure of the ORDERS table.
The columns ORDER_MODE and ORDER TOTAL have the default values'direct "and respectively.
Which two INSERT statements are valid? (Choose two.)

• A.INSERT INTO orders VALUES('09-mar-2007',DEFAULT,101, DEFALLT);
• B.INSERT INTO orders (order id, order_date, order mode, order_total)VALUES (1,'10-mar-2007','online', 1000)
• C.INSERT INTO (SELECT order_id, order date, customer_id FROM orders) VALUES (1, '09-mar-2007",101);
• D.INSERT INTO orders (order_id, order_date, order mode,customer_id, order_total) VALUES (1, TO_DATE (NULL),'online',101, NULL) ;
• E.INSERT INTO orders VALUES (1, '09-mar-2007', 'online',' ',1000);

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about GLOBAL TEMPORARY TABLES?

• A.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• B.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
• C.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
• D.A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.
• E.A TRUNCATE command issued in a session causes all rows In a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• F.GLOBAL TEMPORARY TABLE space allocation occurs at session start.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the INVOICE table.

Which two SQL statements would execute successfully? (Choose two.)

• A.SELECT inv_no,NVL2(inv_date,'Pending','Incomplete')FROM invoice;
• B.SELECT inv_no,NVL2(inv_date,sysdate-inv_date,sysdate)FROM invoice;
• C.SELECT inv_no,NVL2(inv_amt,inv_amt*.25,'Not Available')FROM invoice;
• D.SELECT inv_no,NVL2(inv_amt,inv_date,'Not Available')FROM invoice;

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the STORES table.

You must display the NAME of stores along with the ADDRESS, START_DATE, PROPERTY_PRICE, and the projected property price, which is 115% of property price.
The stores displayed must have START_DATE in the range of 36 months starting from 01-Jan-2000 and above.
Which SQL statement would get the desired output?

• A.SELECT name, concat(address||', '||city||', ', country) AS full_address, start_date,property_price, property_price*115/100FROM storesWHERE MONTHS_BETWEEN(start_date,TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;
• B.SELECT name, concat(address||', '||city||', ',country) AS full_address, start_date,property_price, property_price*115/100FROM storesWHERE TO_NUMBER(start_date-TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;
• C.SELECT name, concat(address||', '||city||', ',country) AS full_address, start_date, property_price, property_price*115/100FROM storesWHERE MONTHS_BETWEEN(start_date,'01-JAN-2000') <=36;
• D.SELECT name, address||', '||city||', '||country AS full_address, start_date,property_price, property_price*115/100FROM storesWHERE MONTHS_BETWEEN(start_date,TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the SALES and PRODUCTS tables. (Choose two.)

In the SALES table, 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 JOIN operator:
SQL > SELECT p.prod_id, count(s.prod_id)
FROM products p ______________ sales s
ON p.prod_id = s.prod_id
GROUP BY p.prod_id;
Which two JOIN operations can be used to obtain the required output?

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

Comment: *

Name: *

Email: *

Verification: *