最新の1Z1-171問題集で試験を準備する

Oracle 1Z1-171 試験概要:

Oracle 1Z1-171 試験シラバストピック:

Oracle Database 23ai SQL Associate 認定 1Z1-171 試験問題：

問題 #1

What is the primary purpose of a primary key in a relational database?

A. To uniquely identify each record in a table
B. To establish relationships between tables
C. To store duplicate data in a table
D. To sort data in ascending order

問題 #2

The column data type is converted to a primary key.

A. CREATE SYNONYM
B. CREATE INDEX
C. CREATE SEQUENCE
D. CREATE ALIAS

問題 #3

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

A. Employee IDs from department 10
B. Employees with salaries greater than 10
C. All employee IDs
D. Employee IDs from departments with no employees

問題 #4

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

問題 #5

What does the following SQL query do?
SELECT *
FROM employees e
JOIN employees m ON e.manager_id = m.employee_id;

A. Lists employees who are managers
B. Lists employees who are not managers
C. Lists employees without departments
D. Lists employees and their corresponding managers

解説：