1Z0-071 or 1Z0-171: which exam to choose
Both exams test SQL on Oracle. They differ in the version of the database and in what is new in it.
| 1Z0-071 | 1Z0-171 | |
|---|---|---|
| Database version | Oracle Database 19c | Oracle AI Database 26ai |
| Questions | 63 | 60 |
| Time | 120 minutes | 120 minutes |
| Pass mark | 63% | 65% |
| In short | The established Oracle SQL exam, on Oracle Database 19c. Not sure which to choose? Start here. | The newer exam, on Oracle 26ai: the same SQL plus what 26ai adds, such as vector search. |
Which to choose
Not sure which to choose? Start with 1Z0-071.