2026 Latest 100% Exam Passing Ratio – 1Z0-171 Dumps PDF [Q62-Q83]

Section	Objectives
Using Set Operators	– Use UNION, UNION ALL, INTERSECT, and MINUS operators
Using Subqueries	– Use correlated subqueries – Use single-row subqueries – Use multiple-row subqueries
Using SQL Functions	– Use conversion functions – Use character, number, and date functions in SELECT statements
Controlling User Access	– Differentiate system privileges from object privileges – Grant and revoke privileges – Create and manage roles
Using Joins	– Use outer joins (LEFT, RIGHT, FULL) – Use self-joins – Use equijoins and non-equijoins – Use cross joins
Using DML Statements	– Control transactions – Use the MERGE statement – Delete rows from a table – Insert rows into a table – Update rows in a table
Using DDL Statements	– Create and manage sequences – Create and manage indexes – Create and manage views – Create and manage tables – Create and manage constraints
Using SELECT Statements	– Execute a basic SELECT statement – Use the WHERE clause to restrict rows – Use the ORDER BY clause to sort rows – Use the FETCH clause to limit rows returned

Section

Objectives

Using Set Operators

– Use UNION, UNION ALL, INTERSECT, and MINUS operators

Using Subqueries

– Use correlated subqueries
– Use single-row subqueries
– Use multiple-row subqueries

Using SQL Functions

– Use conversion functions
– Use character, number, and date functions in SELECT statements

Controlling User Access

– Differentiate system privileges from object privileges
– Grant and revoke privileges
– Create and manage roles

Using Joins

– Use outer joins (LEFT, RIGHT, FULL)
– Use self-joins
– Use equijoins and non-equijoins
– Use cross joins

Using DML Statements

– Control transactions
– Use the MERGE statement
– Delete rows from a table
– Insert rows into a table
– Update rows in a table

Using DDL Statements

– Create and manage sequences
– Create and manage indexes
– Create and manage views
– Create and manage tables
– Create and manage constraints

Using SELECT Statements

– Execute a basic SELECT statement
– Use the WHERE clause to restrict rows
– Use the ORDER BY clause to sort rows
– Use the FETCH clause to limit rows returned