Online Access Free 1Z0-171 Exam Questions

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

• A.Retrieving duplicate records from a single table
• B.Joining two tables without a common column
• C.Comparing each employee's salary to the average salary of their department
• D.Inserting data into a table

What does the EXISTS operator check in a subquery?

• A.If the subquery returns a specific number of rows
• B.If the subquery returns any rows
• C.If the subquery references the outer query
• D.If the subquery contains only unique values

What does the following query return?
SELECT ROUND(123.456, 1) AS rounded_value FROM dual;

• A.123.5
• B.123.45
• C.124
• D.123.4

Which command creates a new role in Oracle Database?

• A.CREATE ROLE role_name;
• B.ADD ROLE role_name;
• C.CREATE NEW ROLE role_name;

Which SQL function can be used to replace NULL values with a specified value?

• A.ISNULL
• B.REPLACE
• C.NVL
• D.COALESCE