考試科目：1Z0-082

考試題量：90

通過分數(shù)：60%

考試時間：150min

本文為云貝教育郭一軍（微信：guoyJoe）原創(chuàng)，請尊重知識產(chǎn)權(quán)，轉(zhuǎn)發(fā)請注明出處，不接受任何抄襲、演繹和未經(jīng)注明出處的轉(zhuǎn)載。

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

解析：

關(guān)于連接字符串和用于連接的服務(wù)名稱，哪三個語句是正確的Oracle數(shù)據(jù)庫實例?
A. 錯：連接字符串必須包含數(shù)據(jù)庫實例的SID? ===>（#用SERVICE_NAME就可以，SID不是必須的）
B. 對：一個連接字符串可以引用多個數(shù)據(jù)庫實例? ? ? ===> RAC
C. 錯：包含服務(wù)名的連接字符串必須在tnsnames.ora文件中定義? ?===>?包含了service_name的連接串必須在tns.ora中定義,sqlplus sys/oracle@solaris:1521/ora12c as sysdba簡易連接不用tnsnames.ora，數(shù)據(jù)庫連接串跟TNSNAME.ORA文件沒啥關(guān)系，真要用TNS解析來連接數(shù)據(jù)庫，配置SID也是可以的，不一定非要SERVICE_NAME
D. 錯：服務(wù)名由偵聽器創(chuàng)建? ?===>靜態(tài)監(jiān)聽定義服務(wù)名，動態(tài)監(jiān)聽定義的服務(wù)名：是在service_names參數(shù)中定義，默認是取了db_unique_name，注冊到監(jiān)聽中
E. 對：相同tnsnames.ora文件中的不同連接字符串可以包含相同的服務(wù)名稱主機和端口參數(shù)
F. 對：一個數(shù)據(jù)庫實例可以支持多個服務(wù)名的連接

解析視頻：