Free Access Oracle.1Z0-082.v2022-02-11.q110 Practice Test (Page 4)

Question 11

Which three statements are true about a self-join? (Choose three.)

A.The query must use two different aliases for the table

B.It must be an inner join

C.The ON clause must be used

D.The ON clause can be used

E.It can be an outer join

F.It must be an equi join

Question 12

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

A.It must resolve to a valid connect descriptor in the server's tnsnames.ora file

B.It must resolve to a valid connect descriptor in the client's tnsnames.ora file

C.It must be the name of the server running the database to whose instance HR wishes to connect

D.It must be the value of the SERVICE_NAMES parameter on the client side

E.It must be the name of the database to whose instance HR wishes to connect

Question 13

Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

A.The Oracle Net Configuration Assistant is only used when running the Oracle installer

B.Oracle Net Manager can be used to centrally configure listeners on any database server target

C.The lsnrctl utility requires a listener.ora file to exist before it is started

D.Oracle Net Manager can be used to locally configure naming methods on a database server

E.Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server

F.Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target

Question 14

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement: