Online Access Free 1Z1-171 Exam Questions

What does the INTERSECT operator do in SQL?

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

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

• A.INDEX_LIST
• B.USER_INDEXES
• C.ALL_INDEXES
• D.DBA_INDEXES

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

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

Which of the following is an example of an object privilege?

• A.SELECT ON table_name
• B.CREATE TABLE
• C.DROP DATABASE
• D.ALTER USER

What will the following query return?
SELECT EXTRACT(YEAR FROM CURRENT_DATE) AS year FROM dual;

• A.The full date in the session time zone
• B.The current year in the database time zone
• C.An error due to incorrect syntax