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 requiredB.Local Naming requires setting the TNS_ADMIN environment variable on the client side C.Local naming can be used if Connect-Time Failover is requiredD.Directory Naming requires setting the TNS_ADMIN environment variable on the client sideE.A client can connect to an Oracle database instance even if no client side network admin has been configureF.Easy Connect supports TCP/IP and SSL答案：ACE14.Examine the description of the SATES1 tableSALES2 is a table with the same description as SALES1 Some sales data is contained erroneously in both tablesYou 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.SUBTRACTD.UNIONE.INTERSECT答案：B15.Which two statements are true about Oracle synonyms?A.A synonym can be created on an object in a packageB.A synonym can have a synonymC.Any user can create a PUBLIC synonymD.A synonym has an object numberE.All private synonym names must be unique in the database答案：BD16.Examine the description of the PRODUCT DETAILs table:Which two statements are true?A.PRODUCT_NAME cannot contain duplicate valuesB.EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it C.EXPIRY_DATE cannot be used in arithmetic expressionsD.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 itF.PRODUCT_ID can be assigned the PRIMARY KEY constraint答案：DFnull参与运算的结果是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 instancesC.A connection string including a service name must be defined in the tnsnames.ora fileD.A service name is created by a listenerE.Different connection strings in the same tnsnames. ora file can contain the same service name host and port parametersF. A single database instance can support connections for multiple service names答案：BEF18.Which compression method is recommended for Direct-Path Insert operations? A.COLUMN STORE COMPRESS ADVANCEDB.ROW STORE COMPRESS ADVANCED C.COLUMN STORE COMPRESS BASIC D.ROW STORE COMPRESS BASIC答案：D