Oracle Cloud Infrastructure 2023 Architect Associate — Question 38

A new Python developer has joined your team and needs to access the Autonomous Database data.

How does the developer connect to and interact with ADB from Python?

Answer options

• A. By using SQL Developer
• B. By using Oracle Client and the cx_Oracle interface
• C. By using Oracle Client and the DBD-Oracle interface
• D. By using JDBC Driver

Correct answer: B

Explanation

The correct answer is B, as the cx_Oracle interface is specifically designed for connecting Python applications to Oracle databases, including Autonomous Database. Option A is incorrect because SQL Developer is a GUI tool, not a Python library. Options C and D are also incorrect because DBD-Oracle is for Perl and JDBC is for Java, neither of which are relevant for a Python developer.