Oracle 19c OCP 1Z0-082認證考試題庫（13-18）

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

答案：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

答案：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

答案：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

答案：DF

null參與運算的結果是null，但並不報錯

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

答案：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

答案：D