Which two methods can you use to get the required result?

Examine the structure of the CUSTOMERS table:
name Null Type
CUSTNO NOT NULL NUMBER(3)
CUSTNAME NOT NULL VARCHAR2(25)
CUSTADDRESS VARCHAR2(35)
CUST_CREDIT_LIMIT NUMBER(5)
CUSTNO is the PRIMARY KEY in the table. You want to find out if any customers’ details have been
entered more than once using different CUSTNO, by listing all the duplicate names.
Which two methods can you use to get the required result? (Choose two.)

Examine the structure of the CUSTOMERS table:
name Null Type
CUSTNO NOT NULL NUMBER(3)
CUSTNAME NOT NULL VARCHAR2(25)
CUSTADDRESS VARCHAR2(35)
CUST_CREDIT_LIMIT NUMBER(5)
CUSTNO is the PRIMARY KEY in the table. You want to find out if any customers’ details have been
entered more than once using different CUSTNO, by listing all the duplicate names.
Which two methods can you use to get the required result? (Choose two.)

A.
self-join

B.
subquery

C.
full outer-join with self-join

D.
left outer-join with self-join

E.
right outer-join with self-join



Leave a Reply 5

Your email address will not be published. Required fields are marked *


user

user

why can’t you use an outer join?

Neal

Neal

Could outer joins work in this situation?

kar

kar

THESE ALL QUESTION ARE FOR 1Z0 144 EXAM AH?

kar

kar

HI Neal I think u are in online now…
Is these all 151 questions are for 1z0 144 exam?

Neal

Neal

Hi kar:
Is these all 151 questions are for 1z0 144 exam?
I am not sure about it sorry