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

What type of join does the following query perform?
SELECT *
FROM employees e, departments d
WHERE e.department_id = d.department_id;

• A. NATURAL JOIN
• B. OUTER JOIN
• C. CROSS JOIN
• D. EQUI JOIN

How can you ensure that data is sorted in descending order in a SQL query?

• A. Use the ASC keyword
• B. Use the ORDER keyword
• C. Use the DESC keyword
• D. Use the DISTINCT keyword

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

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

Which type of INSERT statement allows inserting rows into multiple tables using a single SELECT query?

• A. Insert rows into a single table based on values in other tables
• B. Insert rows into a table only when a condition is met
• C. Insert rows into multiple tables without conditions
• D. Insert rows into multiple tables simultaneously

What happens when a unique index is created on a table column?

• A. The column data type is converted to a primary key.
• B. The column values are automatically encrypted.
• C. The column can only contain NULL values.
• D. The column cannot contain duplicate values.