1Z1-171 무료 덤프문제 온라인 액세스

What does the INTERSECT operator do in SQL?

• A.Returns rows from the first query that are not present in the second query
• B.Combines rows from two queries and includes all duplicates
• C.Returns rows that are present in both queries
• D.Combines all rows from two queries without any conditions

Which SQL function calculates the number of months between two dates?
Response:

• A.TIME_DIFF
• B.DATE_DIFF
• C.DATE_CALC
• D.MONTHS_BETWEEN

Which clause in a SQL SELECT statement is used to define the columns to be retrieved?

• A.GROUP BY
• B.SELECT
• C.WHERE
• D.FROM

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 not managers
• B.Lists employees and their corresponding managers
• C.Lists employees without departments
• D.Lists employees who are managers

What is the primary purpose of an index in SQL?

• A.To improve the performance of data retrieval queries
• B.To enforce data integrity constraints
• C.To ensure uniqueness of values in a column
• D.To store metadata about a table