In the PROMOTIONS table, the PROMO_BEGIN_DATEcolumn is of data type DATEand the default date format is DD-MON-RR.
Which two statements are true about expressions using PROMO_BEGIN_DATEcontained a query? (Choose two.)

• A.TO_DATE(PROMO_BEGIN_DATE * 5)will return a date.
• B.TO_NUMBER(PROMO_BEGIN_DATE)- 5 will return a number.
• C.PROMO_BEGIN_DATE - SYSDATEwill return an error.
• D.PROMO_BEGIN_DATE- 5 will return a date.
• E.PROMO_BEGIN_DATE - SYSDATEwill return a number.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the MEMBERS table:

You want to display details of all members who reside in states starting with the letter A followed by exactly one character.
Which SQL statement must you execute?

• A.SELECT * FROM MEMBERS WHERE state LIKE 'A_';
• B.SELECT * FROM MEMBERS WHERE state LIKE 'A%';
• C.SELECT * FROM MEMBERS WHERE state LIKE 'A_%';
• D.SELECT * FROM MEMBERS WHERE state LIKE '%A_';

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

• A.The output is sorted by the UNION ALL operator
• B.The number of columns selected in each SELECT statement must be identical
• C.NULLS are not ignored during duplicate checking
• D.The names of columns selected in each SELECT statement must be identical
• E.Duplicates are eliminated automatically by the UNION ALL operator

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine, the description for the SALES and CHANNELS tables.
(Choose the best answer.)

You issued this SQL statement:
INSERT INTO SALES VALUES (23, 2300, SYSDATE,
(SELECT CAHNNEL_ID
FROM CHANNELS
WHERE CHANNEL_DESC='DIRECT SALES'), 12, 1, 500);
Which statement is true regarding the result?

• A.The statement will fail because the sub-query in the VALUES clause is not enclosed within single quotation marks.
• B.The statement will execute and a new row will be inserted in the SALES table.
• C.The statement will fail because the VALUES clause is not required with the subquery.
• D.The statement will fail because a subquery cannot be used in a VALUES clause.

Comment: *

Name: *

Email: *

Verification: *

Evaluate this query:
SQL> SELECT TRUNC(ROUND(156.00,-1),-1)
FROM DUAL;
What will be the result?

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

Comment: *

Name: *

Email: *

Verification: *