Which three statements are true?

• A.The statement will fail if a row already exists in the SALES table for product 23.
• B.A customer can exist in many countries.
• C.The statement will execute successfully and a new row will be inserted into the SALES table.
• D.The statement will fail because subquery may not be I contained in a values clause.
• E.A product can have a different unit price at different times.
• F.The SALES table has five foreign keys.

Comment: *

Name: *

Email: *

Verification: *

The ORDERS table has a column ORDER_DATE of date type DATE The default display format for a date is DD-MON-RR
Which two WHERE conditions demonstrate the correct usage of conversion functions?

• A.WHERE TO_CHAR(order_date,'MON DD YYYY') ='JAN 20 2019';
• B.WHERE order_date> TO_DATE(ADD_MONTHS(SYSDATE,6),'MON DD YYYY');
• C.WHERE order_date> TO_DATE('JUL 10 2018','MON DD YYYY');
• D.WHERE ordet_date> TO_CHAR(ADD_MONTHS(SYSDATE, 6),'MON DD YYYY')
• E.WHERE order_date IN (TO_DATE ('Oct 21 2018','MON DD YYYY'), TO_CHAR('Nov 21 2018','MON DD YYYY'));

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the SALEStable:

The SALEStable has 55,000 rows.
Examine this statement:

Which two statements are true? (Choose two.)

• A.SALES1is created with 1 row.
• B.SALES1is created with 55,000 rows.
• C.SALES1is created with no rows.
• D.SALES1has PRIMARY KEYand UNIQUE constraints on any selected columns which had those constraints in the SALEStable.
• E.SALES1has NOT NULLconstraints on any selected columns which had those constraints in the SALES table.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the MEMBERS table: (Choose the best answer.)

Examine the SQL statement:
SQL > SELECT city, last_name LNAME FROM MEMBERS ORDER BY 1, LNAME DESC; What would be the result execution?

• A.It displays all cities in descending order, within which the last names are further sorted in descending order.
• B.It displays all cities in ascending order, within which the last names are further sorted in descending order.
• C.It fails because a column number and a column alias cannot be used together in the ORDER BY clause.
• D.It fails because a column alias cannot be used in the ORDER BY clause.

Comment: *

Name: *

Email: *

Verification: *

In the EMPLOYEES table there are 1000 rows and employees are working in the company for more than
10 years.
Evaluate the following SQL statement:

What would be the result?

• A.It executes successfully but no rows updated.
• B.It executes successfully and updates the records of those employees who have been working in the company for more than 600 days.
• C.It gives an error because NVL function cannot be used with UPDATE.
• D.It gives an error because multiple NVL functions are used in an expression.

Comment: *

Name: *

Email: *

Verification: *