1Z0-071 Study Guide 2026
Everything you need to pass the 1Z0-071 exam in one place: the exam format, every topic to study, real practice questions with explanations, flashcards, and full-length practice tests. Free, no sign-up needed.
📋 1Z0-071 Exam Format at a Glance
📚 1Z0-071 Topics to Study (22)
✍️ Sample 1Z0-071 Questions & Answers
1. Which set operator returns all rows from both queries, including duplicate rows?
UNION ALL combines result sets from both queries and retains all duplicate rows without performing any deduplication.
2. Which error occurs when a single-row operator is used with a multi-row subquery result?
ORA-01427 'single-row subquery returns more than one row' is raised when = or < is used against a multi-row subquery.
3. Which type of join condition compares columns using an operator other than equals (=)?
A non-equijoin uses comparison operators like BETWEEN, instead of = to match rows.
4. What does the ON DELETE CASCADE option on a FOREIGN KEY do?
ON DELETE CASCADE automatically deletes all child rows in the referencing table when the parent row is deleted.
5. Which DML statement can both insert new rows and update existing rows in a single operation?
MERGE (also called an upsert) matches source rows to target rows and inserts new ones or updates existing ones conditionally.
6. Which of the following is true about relational databases?
Relational databases are fundamentally structured around tables, which are composed of rows and columns. Each row represents a single record, and each column represents an attribute of that record. This tabular structure is central to how relational databases store, organize, and manage data, allowing for clear definition and relationships between data entities.