2026 Valid 1Z0-171 Real Exam Questions, practice Oracle Database [Q37-Q58]

4/5 - (1 vote)

2026 Valid 1Z0-171 Real Exam Questions, practice Oracle Database

Latest Success Metrics For Actual 1Z0-171 Exam (Updated 111 Questions)

NO.37 What is the result of the following query?
SELECT employee_id
FROM employees
WHERE EXISTS (SELECT 1 FROM departments WHERE department_id = 10);

Employee IDs from department 10

All employee IDs

Employee IDs from departments with no employees

Employees with salaries greater than 10

NO.38 Which data dictionary view lists all indexes created by the current user?

USER_INDEXES

ALL_INDEXES

DBA_INDEXES

INDEX_LIST

NO.39 What is the output of the following query?
SELECT CURRENT_DATE FROM dual;

The current date in the database time zone

The current date in the session time zone

The current date and time in the database time zone

The current date and time in UTC

NO.40 What is a sequence in Oracle Database?

A list of numbers stored in a table

A database object that generates a series of unique numeric values

A type of index used for sorting rows

A predefined set of SQL queries executed in order

NO.41 What does the following SQL statement do?
ALTER TABLE employees DROP COLUMN salary;

Deletes the employees table

Drops the salary column from the employees table

Sets the salary column to NULL for all rows

Removes duplicate rows from the employees table

NO.42 What does the following query return?
SELECT employee_id
FROM employees
WHERE department_id IN (SELECT department_id FROM departments WHERE location_id = 1000);

Employees working in location ID 1000

Employees with no department

Departments located in location ID 1000

Employees with salaries greater than 1000

NO.43 Which of the following can be achieved using a correlated subquery?

Comparing each employee’s salary to the average salary of their department

Joining two tables without a common column

Inserting data into a table

Retrieving duplicate records from a single table

NO.44 What is the purpose of a correlated subquery?

A subquery that depends on the result of another subquery

A subquery that references columns from the outer query

A subquery that combines data from multiple tables

A subquery that can be used only with aggregate functions

NO.45 What happens when the TRUNCATE TABLE statement is executed?

Deletes all rows in the table and logs the operation for rollback

Deletes all rows in the table without logging the operation for rollback

Deletes the table structure permanently

Deletes only the last row in the table

NO.46 Which function is used to extract the year from a date in SQL?

EXTRACT(YEAR FROM date)

YEAR(date)

GET_YEAR(date)

TO_YEAR(date)

NO.47 Which operator can be used in a multiple-row subquery to match a single value to a list of values?

EXISTS

NOT NULL

NO.48 What happens if a DELETE statement is executed without a WHERE clause?

No rows are deleted.

Only the first row is deleted.

All rows in the table are deleted.

An error is raised.

NO.49 What does the EXISTS operator check in a subquery?

If the subquery returns any rows

If the subquery contains only unique values

If the subquery returns a specific number of rows

If the subquery references the outer query

NO.50 What is a SELF JOIN in SQL?

A join between tables with identical structures

A join of a table with itself

A join that does not require a WHERE clause

A join used for Cartesian products

NO.51 What does the following SQL query do?
SELECT * FROM employees WHERE salary > 5000 ORDER BY department_id;

Retrieves all employees with a salary greater than 5000, sorted by salary in ascending order

Retrieves all employees, sorted by department ID

Retrieves all employees with a salary greater than 5000, sorted by department ID in ascending order

Retrieves employees with salary less than 5000, sorted by department ID

NO.52 What is the purpose of using external tables in Oracle Database?

To create temporary tables for session-specific data

To manage data stored in external files using SQL

To store backup copies of database tables

To improve the performance of complex queries

NO.53 Which of the following SQL commands retrieves data from a relational database?

INSERT

SELECT

DELETE

UPDATE

NO.54 Which SET operator returns rows from the first query that are not present in the second query?

UNION

INTERSECT

MINUS

UNION ALL

NO.55 Which command grants a user the ability to query data from a specific table?

GRANT SELECT ON table_name TO user_name;

GRANT ALL ON table_name TO user_name;

ALLOW SELECT ON table_name TO user_name;

ENABLE SELECT ON table_name TO user_name;

NO.56 Which Oracle SQL function returns the current date and time, including time zone information?

CURRENT_DATE

SYSDATE

NOW

CURRENT_TIMESTAMP

NO.57 Which of the following best describes a relational database?

A database where all data is stored as key-value pairs

A database that uses a tabular structure with rows and columns to represent relationships between data entities

A database that organizes data hierarchically

A flat file system with no defined relationships between data

NO.58 What is the purpose of the SAVEPOINT statement?

To save changes permanently

To set a point within a transaction to which a rollback can occur

To restart a transaction

To delete data temporarily

Loading …

Genuine 1Z0-171 Exam Dumps Free Demo Valid QA’s: https://www.passleadervce.com/Oracle-Database/reliable-1Z0-171-exam-learning-guide.html

Leave a Reply Cancel reply