Microsoft
70-516 · Question #255
You are creating a Microsoft .NET Framework 4 application that will access data from an Oracle database named DB1. DB1 is located on a server named DBSVR. The Oracle instance requires that…
The correct answer is D. Data Source=DBSVR: 1433/331; User ID=/. For Windows Authentication use connection strings like: Data Source=myOracleDB;User Id=/;
Implementing Data Access
Question
You are creating a Microsoft .NET Framework 4 application that will access data from an Oracle database named DB1. DB1 is located on a server named DBSVR. The Oracle instance requires that connections be authenticated by using Windows authentication. You need to identify the connection string for the application. Which connection string should you identify?
Options
- AData Source=DBSVR; initial catalog=DBl; Integrated Security=SSPI;
- BData Source=DBSVS: 1433/231; SPPRMSLOB=True;
- CData Source=DBSVR; initial catalog=DB1; Network Library=DBMSSOCN;
- DData Source=DBSVR: 1433/331; User ID=/;
How the community answered
(45 responses)- A13% (6)
- B7% (3)
- C2% (1)
- D78% (35)
Explanation
For Windows Authentication use connection strings like: Data Source=myOracleDB;User Id=/;
Topics
#Oracle connection string#Windows authentication#Integrated Security#connection configuration
Community Discussion
No community discussion yet for this question.