Attested 1Z0-171 Dumps PDF Resource [2026]
Latest 1Z0-171 Actual Free Exam Questions Updated 111 Questions
NEW QUESTION # 39
What does the NEXTVAL pseudocolumn do in SQL?
- A. Resets the sequence to its starting value
- B. Deletes the sequence from the database
- C. Retrieves the current value of a sequence without incrementing it
- D. Retrieves the next value in a sequence and increments the sequence
Answer: D
NEW QUESTION # 40
What does the following SQL query do?
SELECT * FROM employees WHERE salary > 5000 ORDER BY department_id;
- A. Retrieves all employees with a salary greater than 5000, sorted by department ID in ascending order
- B. Retrieves all employees with a salary greater than 5000, sorted by salary in ascending order
- C. Retrieves all employees, sorted by department ID
- D. Retrieves employees with salary less than 5000, sorted by department ID
Answer: A
NEW QUESTION # 41
What is the purpose of the DBA_OBJECTS data dictionary view?
- A. To list all users in the database
- B. To provide information about all objects in the database
- C. To show the current session details
- D. To monitor system performance
Answer: B
NEW QUESTION # 42
How does SQL handle NULL values in arithmetic expressions?
- A. Treats them as the largest possible number
- B. Produces a NULL result
- C. Produces an error
- D. Treats them as zero
Answer: B
NEW QUESTION # 43
What will the following query return?
SELECT TO_CHAR(SYSDATE, 'DD-MM-YYYY') AS formatted_date FROM dual;
- A. The current date in the format 'DD-MM-YYYY'
- B. The time part of the current date
- C. The current date in the default system format
- D. An error
Answer: A
NEW QUESTION # 44
What will the following query return?
SELECT EXTRACT(YEAR FROM CURRENT_DATE) AS year FROM dual;
- A. The current year in the database time zone
- B. An error due to incorrect syntax
- C. The full date in the session time zone
Answer: A
NEW QUESTION # 45
Which component of an ERD (Entity-Relationship Diagram) represents the attributes of an entity?
- A. Rectangles
- B. Arrows
- C. Ovals
- D. Diamonds
Answer: C
NEW QUESTION # 46
What does a Cartesian product in SQL result from?
- A. An OUTER JOIN with NULL values
- B. A NATURAL JOIN without specifying join conditions
- C. An INNER JOIN without specifying join conditions
Answer: C
NEW QUESTION # 47
What is the result of the following SQL query?
SELECT COALESCE(NULL, 100, 200) AS result FROM dual;
- A. NULL
- B. 0
- C. 1
- D. 2
Answer: C
NEW QUESTION # 48
Which type of join includes rows that do not have matching values in the joined table?
- A. INNER JOIN
- B. CROSS JOIN
- C. OUTER JOIN
- D. SELF JOIN
Answer: C
NEW QUESTION # 49
What will the following SQL query return?
SELECT TRUNC(15.678, 2) AS truncated_value FROM dual;
- A. 15.68
- B. 15.678
- C. 15.6
- D. 15.67
Answer: D
NEW QUESTION # 50
Which statement can be used to undo changes made in a transaction?
- A. MERGE
- B. ROLLBACK
- C. COMMIT
- D. SAVEPOINT
Answer: B
NEW QUESTION # 51
In a relational database, what is a foreign key?
- A. A temporary key generated during query execution
- B. A key that is used to establish a relationship between two tables
- C. A key used to sort data in a specific order
- D. A unique identifier for a record in a table
Answer: B
NEW QUESTION # 52
What is the output of the following query?
SELECT CURRENT_DATE FROM dual;
- A. The current date in the session time zone
- B. The current date and time in UTC
- C. The current date and time in the database time zone
- D. The current date in the database time zone
Answer: A
NEW QUESTION # 53
What does the following SQL statement do?
ALTER TABLE employees DROP COLUMN salary;
- A. Drops the salary column from the employees table
- B. Sets the salary column to NULL for all rows
- C. Deletes the employees table
- D. Removes duplicate rows from the employees table
Answer: A
NEW QUESTION # 54
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. Employees and their managers' IDs
- B. All employees and their IDs
- C. Employees who have managers
- D. Employees who do not have managers
Answer: C
NEW QUESTION # 55
What happens when a temporary table is created in Oracle Database?
- A. It is permanently stored in the database.
- B. It is created for the duration of a user session or transaction.
- C. It is stored in external files.
- D. It cannot have any constraints.
Answer: B
NEW QUESTION # 56
What does the following command do?
GRANT CREATE SESSION TO user_name;
- A. Allows the user to create database objects
- B. Grants the user the ability to connect to the database
- C. Assigns the user to a specific role
- D. Allows the user to create new sessions for other users
Answer: B
NEW QUESTION # 57
What type of join does the following query perform?
SELECT *
FROM employees e, departments d
WHERE e.department_id = d.department_id;
- A. CROSS JOIN
- B. NATURAL JOIN
- C. OUTER JOIN
- D. EQUI JOIN
Answer: D
NEW QUESTION # 58
What is required for the queries combined by a SET operator to work correctly?
- A. The result sets must have the same number of columns and compatible data types.
- B. The tables must be joined using a primary key.
- C. Both queries must use the GROUP BY clause.
- D. Both queries must include the WHERE clause.
Answer: A
NEW QUESTION # 59
Which of the following is a valid reason to create a synonym?
- A. To enforce unique constraints on a table
- B. To improve query performance
- C. To automatically generate numeric values for a column
- D. To provide simplified and consistent access to an object
Answer: D
NEW QUESTION # 60
Which of the following is an example of an object privilege?
- A. SELECT ON table_name
- B. ALTER USER
- C. CREATE TABLE
- D. DROP DATABASE
Answer: A
NEW QUESTION # 61
What does the following SQL query return?
SELECT employee_id, salary * 12 AS annual_salary FROM employees;
- A. Employee IDs and their annual salaries
- B. Monthly salaries of all employees
- C. Salaries multiplied by 12 and stored in a new table
- D. Only employees with salaries greater than 12
Answer: A
NEW QUESTION # 62
......
1Z0-171 Certification Overview Latest 1Z0-171 PDF Dumps: https://www.passleader.top/Oracle/1Z0-171-exam-braindumps.html
Free 1Z0-171 Exam Braindumps certification guide Q&A: https://drive.google.com/open?id=1bZdKyiK1PWJmKSi9HASt4wGQy5X_4Y_E