View the Exhibit and examine the details of the PRODUCT_INFORMATION table.

Evaluate this SQL statement:
SELECT TO_CHAR (list_price, '$9,999')
From product_information;
Which two statements are true regarding the output? (Choose two.)

• A.A row whose LIST_PRICE column contains value 11235.90 would be displayed as $1,123.
• B.A row whose LIST_PRICE column contains value 11235.90 would be displayed as #######.
• C.A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,124.
• D.A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,123.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the PROGRAMS table:

Which two SQL statements would execute successfully?

• A.SELECT NVL (ADD_MONTHS (END_DATE,1) SYSDATE) FROM programs;
• B.SELECT NVL (MONTHS_BETWEEN (start_date, end_date), 'Ongoing') FROM programs;
• C.SELECT NVL (TO_CHAR (MONTHS_BETWEEN (start-date, end_date)), 'Ongoing') FROM programs
• D.SELECT TO_DATE (NVL (SYSDATE-END_DATE, SYSDATE)) FROM programs;

Comment: *

Name: *

Email: *

Verification: *

You create a table named 123.
Which statement runs successfully?

• A.SELECT * FROM "123";
• B.SELECT * FROM TABLE (123) ;
• C.SELECT * FROM '123';
• D.SELECT * FROM V'123V';

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the PROMOTIONS table.

Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?

• A.It produces an error because subqueries cannot be used with the CASE expression.
• B.It shows COST_REMARK for all the promos in the table.
• C.It produces an error because the subquery gives an error.
• D.It shows COST_REMARK for all the promos in the promo category 'TV'.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are correct regarding indexes? (Choose three.)

• A.A non-deferrable PRIMARY KEYor UNIQUE KEYconstraint in a table automatically attempts to creates a unique index.
• B.Indexes should be created on columns that are frequently referenced as part of any expression.
• C.When a table is dropped, the corresponding indexes are automatically dropped.
• D.For each DML operation performed, the corresponding indexes are automatically updated.

Comment: *

Name: *

Email: *

Verification: *