We're so confident of our products that we provide no hassle product exchange.
Oracle 1Z1-171 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 23ai SQL Associate |
| Exam Number: | 1Z0-171 |
| Exam Format: | Multiple Choice |
| Exam Price: | USD 245 |
| Certificate Validity Period: | Lifetime |
| Real Exam Qty: | 60 |
| Available Languages: | English |
| Exam Duration: | 120 minutes |
| Passing Score: | 65% |
| Related Certifications: | Oracle Database 23ai SQL Associate Certification |
| Sample Questions: | Oracle 1Z1-171 Sample Questions |
| Exam Way: | Online or In-Person at Oracle Testing Centers |
| Pre Condition: | None |
| Official Syllabus URL: | https://education.oracle.com/oracle-database-23ai-sql-associate/pexam_1Z0-171 |
Oracle 1Z1-171 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Using SQL Functions | - Use character, number, and date functions in SELECT statements - Use conversion functions |
| Using Subqueries | - Use single-row subqueries - Use multiple-row subqueries - Use correlated subqueries |
| Using DML Statements | - Update rows in a table - Control transactions - Use the MERGE statement - Delete rows from a table - Insert rows into a table |
| Using DDL Statements | - Create and manage indexes - Create and manage views - Create and manage tables - Create and manage constraints - Create and manage sequences |
| Using Joins | - Use equijoins and non-equijoins - Use self-joins - Use outer joins (LEFT, RIGHT, FULL) - Use cross joins |
| Controlling User Access | - Differentiate system privileges from object privileges - Grant and revoke privileges - Create and manage roles |
| Using SELECT Statements | - Use the FETCH clause to limit rows returned - Use the WHERE clause to restrict rows - Execute a basic SELECT statement - Use the ORDER BY clause to sort rows |
| Using Set Operators | - Use UNION, UNION ALL, INTERSECT, and MINUS operators |
Oracle Database 23ai SQL Associate Sample Questions:
Question #1
Which SET operator returns rows from the first query that are not present in the second query?
- A. MINUS
- B. UNION
- C. UNION ALL
- D. INTERSECT
Correct Answer: A 🗳️
Question #2
What happens when the TRUNCATE TABLE statement is executed?
- A. Deletes the table structure permanently
- B. Deletes all rows in the table without logging the operation for rollback
- C. Deletes all rows in the table and logs the operation for rollback
- D. Deletes only the last row in the table
Correct Answer: B 🗳️
Question #3
Which Oracle SQL function returns the current date and time, including time zone information?
- A. SYSDATE
- B. CURRENT_TIMESTAMP
- C. CURRENT_DATE
- D. NOW
Correct Answer: B 🗳️
Question #4
Which command is used to add a new column to an existing table?
- A. ALTER TABLE
- B. ADD COLUMN
- C. MODIFY COLUMN
- D. ALTER COLUMN
Correct Answer: A 🗳️
Question #5
What is the purpose of a correlated subquery?
- A. A subquery that combines data from multiple tables
- B. A subquery that depends on the result of another subquery
- C. A subquery that can be used only with aggregate functions
- D. A subquery that references columns from the outer query
Correct Answer: D 🗳️
Viewing page 1 out of 23 pages.
Viewing questions 1-5 out of 111 questions.
By Edwiin
