[Aug-2026] Exam 1Z1-171: New Brain Dump Professional - RealExamFree
Free 1Z1-171 Exam Dumps to Improve Exam Score
NEW QUESTION # 19
Which component of an ERD (Entity-Relationship Diagram) represents the attributes of an entity?
- A. Diamonds
- B. Arrows
- C. Ovals
- D. Rectangles
Answer: C
NEW QUESTION # 20
What is the result of using the following SQL query?
SELECT 100 + NULL AS result;
- A. NULL
- B. 0
- C. An error
- D. 1
Answer: A
NEW QUESTION # 21
What is the purpose of using external tables in Oracle Database?
- A. To store backup copies of database tables
- B. To create temporary tables for session-specific data
- C. To improve the performance of complex queries
- D. To manage data stored in external files using SQL
Answer: D
NEW QUESTION # 22
What is the relationship between SQL and a relational database?
- A. SQL is a standard query language used to interact with relational databases
- B. SQL is a scripting language used for file manipulation.
- C. SQL is used to create flat file databases.
- D. SQL is a file system used to store relational database data.
Answer: A
NEW QUESTION # 23
Which SQL JOIN keyword retrieves all rows from both tables, including those without matches?
- A. RIGHT
- B. LEFT
- C. FULL OUTER JOIN
- D. CROSS
Answer: C
NEW QUESTION # 24
What is a subquery in SQL?
- A. A query used for joining two or more tables
- B. A query that combines data from multiple tables
- C. A query used to create a table
- D. A query inside another query
Answer: D
NEW QUESTION # 25
What will the following query do?
SELECT employee_id, salary
FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);
- A. Return employees with a salary below the average salary
- B. Return employees with a salary equal to the average salary
- C. Return employees with a salary above the average salary
- D. Return all employees and their salaries
Answer: C
NEW QUESTION # 26
What is the purpose of a correlated subquery?
- A. A subquery that combines data from multiple tables
- B. A subquery that can be used only with aggregate functions
- C. A subquery that depends on the result of another subquery
- D. A subquery that references columns from the outer query
Answer: D
NEW QUESTION # 27
What happens if a DELETE statement is executed without a WHERE clause?
- A. An error is raised.
- B. No rows are deleted.
- C. Only the first row is deleted.
- D. All rows in the table are deleted.
Answer: D
NEW QUESTION # 28
What will the following query return?
SELECT EXTRACT(YEAR FROM CURRENT_DATE) AS year FROM dual;
- A. An error due to incorrect syntax
- B. The full date in the session time zone
- C. The current year in the database time zone
Answer: C
NEW QUESTION # 29
What happens when the maximum value of a sequence is reached?
- A. An error is raised, and the sequence must be recreated.
- B. The sequence starts decrementing values.
- C. The sequence resets to the starting value if the CYCLE option is specified.
- D. The sequence stops generating values.
Answer: C
NEW QUESTION # 30
Which SQL clause is used to specify the source table in a query?
- A. WHERE
- B. FROM
- C. SELECT
- D. GROUP BY
Answer: B
NEW QUESTION # 31
Which SQL function converts a string representation of a date into a date data type?
- A. CONVERT_TO_DATE
- B. DATE_CONVERT
- C. TO_DATE
- D. CAST_TO_DATE
Answer: C
NEW QUESTION # 32
Which SQL keyword is used to remove duplicate rows from the result set of a query?
- A. ONLY
- B. DISTINCT
- C. DISTINCTROW
- D. UNIQUE
Answer: B
NEW QUESTION # 33
Which statement can be used to undo changes made in a transaction?
- A. MERGE
- B. COMMIT
- C. SAVEPOINT
- D. ROLLBACK
Answer: D
NEW QUESTION # 34
What does the COMMIT statement do in SQL?
- A. Rolls back changes to a previous state
- B. Begins a new transaction
- C. Discards all pending changes in the transaction
- D. Saves all pending changes to the database permanently
Answer: D
NEW QUESTION # 35
......
Powerful 1Z1-171 PDF Dumps for 1Z1-171 Questions: https://passleader.realexamfree.com/1Z1-171-real-exam-dumps.html
