13.Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information?
A.Directory Naming can be used if Connect-Time Failover is required
B.Local Naming requires setting the TNS_ADMIN environment variable on the client side
C.Local naming can be used if Connect-Time Failover is required
D.Directory Naming requires setting the TNS_ADMIN environment variable on the client side
E.A client can connect to an Oracle database instance even if no client side network admin has been configure
F.Easy Connect supports TCP/IP and SSL
answer ：ACE

14.Examine the description of the SATES1 table
SALES2 is a table with the same description as SALES1 Some sales data is contained erroneously in both tables
You must display rows from SALES1 and SALES and wish to see the duplicates too.
Which set operator generates the required output?
A.MINUS
B.UNION ALL
C.SUBTRACT
D.UNION
E.INTERSECT
answer ：B

15.Which two statements are true about Oracle synonyms?
A.A synonym can be created on an object in a package

B.A synonym can have a synonym
C.Any user can create a PUBLIC synonym
D.A synonym has an object number
E.All private synonym names must be unique in the database
answer ：BD

16.Examine the description of the PRODUCT DETAILs table:

Which two statements are true?
A.PRODUCT_NAME cannot contain duplicate values
B.EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it
C.EXPIRY_DATE cannot be used in arithmetic expressions
D.PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it. E.PRODUCT_PRICE contains the value zero by default if no value is assigned to it
F.PRODUCT_ID can be assigned the PRIMARY KEY constraint
answer ：DF
null The result of participating in the operation is null, But it doesn't report an error
SQL> select 1+null from dual;

1+NULL

17.Which three statements are true about connection strings and service names used to connect to an Oracle database instance?
A.A connection string must include the SID of a database instance.
B.A single connection string can refer to multiple database instances
C.A connection string including a service name must be defined in the tnsnames.ora file
D.A service name is created by a listener
E.Different connection strings in the same tnsnames. ora file can contain the same service name host and port parameters
F. A single database instance can support connections for multiple service names
answer ：BEF

18.Which compression method is recommended for Direct-Path Insert operations?
A.COLUMN STORE COMPRESS ADVANCED
B.ROW STORE COMPRESS ADVANCED
C.COLUMN STORE COMPRESS BASIC
D.ROW STORE COMPRESS BASIC
answer ：D

need OCP Please add the exam materials I created qq Group