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?

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?
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?

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.)
ALTER TABLE employees SET UNUSED(department_id)
Which two are true? (Choose two.)
