Question 111

Examine the description of the CUSTOMERS table:

CUSTNO is the PRIMARY KEY.
You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result?
  • Question 112

    Which three statements are true about an ORDER BY clause?
  • Question 113

    Evaluate the following query:
    SQL> SELECT TRUNC (ROUND (156.00, -1),-1)
    FROM DUAL;
    What would be the outcome?
  • Question 114

    View the exhibit and examine the structure and data in the invoice table. (Choose two.)

    Which two SQL statements would execute successfully?
  • Question 115

    You execute this command:
    ALTER TABLE employees SET UNUSED(department_id)
    Which two are true? (Choose two.)