Free Oracle 1Z0-171 Exam 2026 Practice Materials Collection
1Z0-171 Exam Info and Free Practice Test All-in-One Exam Guide Sep-2026
NEW QUESTION # 64
What does the following query return?
SELECT department_id FROM departments
INTERSECT
SELECT department_id FROM employees;
- A. Department IDs that exist in both the departments and employees tables
- B. Department IDs that exist only in the employees table
- C. All department IDs from the employees table
- D. All department IDs from the departments table
Answer: A
NEW QUESTION # 65
What is the purpose of using external tables in Oracle Database?
- A. To improve the performance of complex queries
- B. To store backup copies of database tables
- C. To manage data stored in external files using SQL
- D. To create temporary tables for session-specific data
Answer: C
NEW QUESTION # 66
What is a role in Oracle Database?
- A. A predefined SQL statement stored in the database
- B. A user-defined function
- C. A set of privileges that can be granted to users or other roles
- D. A database object used to enforce constraints
Answer: C
NEW QUESTION # 67
What is the result of the following SQL query?
SELECT COALESCE(NULL, 100, 200) AS result FROM dual;
- A. 0
- B. 1
- C. NULL
- D. 2
Answer: D
NEW QUESTION # 68
What is the difference between UNION and UNION ALL?
- A. UNION removes duplicates, while UNION ALL includes all rows, including duplicates.
- B. UNION includes all rows, while UNION ALL removes duplicates.
- C. UNION works with subqueries, while UNION ALL does not.
- D. UNION combines columns, while UNION ALL combines rows.
Answer: A
NEW QUESTION # 69
Which type of INSERT statement allows inserting rows into multiple tables using a single SELECT query?
- A. Insert rows into multiple tables without conditions
- B. Insert rows into a table only when a condition is met
- C. Insert rows into multiple tables simultaneously
- D. Insert rows into a single table based on values in other tables
Answer: C
NEW QUESTION # 70
What does the following SQL statement do?
CREATE TABLE employees (
employee_id NUMBER PRIMARY KEY,
first_name VARCHAR2(50),
hire_date DATE NOT NULL
);
- A. Creates a table with no constraints
- B. Creates a temporary table
- C. Creates a table with a primary key and a NOT NULL constraint
- D. Creates a table with only VARCHAR2 and DATE columns
Answer: C
NEW QUESTION # 71
What is the result of using the following SQL query?
SELECT 100 + NULL AS result;
- A. An error
- B. 0
- C. 1
- D. NULL
Answer: D
NEW QUESTION # 72
What is the purpose of a correlated subquery?
- A. A subquery that references columns from the outer query
- 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 combines data from multiple tables
Answer: A
NEW QUESTION # 73
What is a SELF JOIN in SQL?
- A. A join between tables with identical structures
- B. A join that does not require a WHERE clause
- C. A join used for Cartesian products
- D. A join of a table with itself
Answer: D
NEW QUESTION # 74
What does the following SQL query return?
SELECT employee_id, salary * 12 AS annual_salary FROM employees;
- A. Monthly salaries of all employees
- B. Only employees with salaries greater than 12
- C. Salaries multiplied by 12 and stored in a new table
- D. Employee IDs and their annual salaries
Answer: D
NEW QUESTION # 75
Which of the following is an example of an object privilege?
- A. ALTER USER
- B. DROP DATABASE
- C. CREATE TABLE
- D. SELECT ON table_name
Answer: D
NEW QUESTION # 76
Which function is used to convert a string to uppercase in SQL?
- A. TO_UPPERCASE
- B. CASE_UPPER
- C. UPPER
- D. CONVERT_UPPER
Answer: C
NEW QUESTION # 77
Which SQL JOIN keyword retrieves all rows from both tables, including those without matches?
- A. FULL OUTER JOIN
- B. LEFT
- C. RIGHT
- D. CROSS
Answer: A
NEW QUESTION # 78
What will the following query result in?
SELECT e.employee_id, e.manager_id
FROM employees e
WHERE e.manager_id IS NOT NULL;
- A. All employees and their IDs
- B. Employees who have managers
- C. Employees and their managers' IDs
- D. Employees who do not have managers
Answer: B
NEW QUESTION # 79
What is a subquery in SQL?
- A. A query used to create a table
- B. A query inside another query
- C. A query used for joining two or more tables
- D. A query that combines data from multiple tables
Answer: B
NEW QUESTION # 80
Which of the following statements is true about constraints in Oracle Database?
- A. Constraints can only be added when creating a table.
- B. Constraints cannot reference other tables.
- C. Constraints can be added or modified using the ALTER TABLE statement.
- D. Constraints are automatically dropped when rows are deleted.
Answer: C
NEW QUESTION # 81
......
Pass Oracle 1Z0-171 Actual Free Exam Q&As Updated Dump: https://www.exam4docs.com/1Z0-171-study-questions.html
Latest 1Z0-171 Actual Free Exam Updated 111 Questions: https://drive.google.com/open?id=1Ig9NnP10FVc2co6ytq03nY-wjaTk8UpU
