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

What is the purpose of the MERGE statement in SQL?

• A.To update existing rows or insert new rows in a target table
• B.To combine the results of two queries
• C.To delete duplicate rows from a table
• D.To join two tables into one

Which data dictionary view provides information about all tables accessible to the current user?

• A.USER_TABLES
• B.DBA_TABLES
• C.ALL_TABLES
• D.SESSION_TABLES

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

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

Which clause is used to allow a user to grant a privilege to others?

• A.WITH ADMIN OPTION
• B.WITH SELECT OPTION
• C.WITH SHARE OPTION
• D.WITH GRANT OPTION

How can a synonym benefit database design?

• A.It allows the renaming of columns in a table.
• B.It provides a consistent reference to database objects, even if their underlying names change.
• C.It enforces constraints on table columns.
• D.It improves query execution time.