Free Oracle 1Z0-171 Exam Dumps Questions & Answers

Which command grants a user the ability to query data from a specific table?

• A.ENABLE SELECT ON table_name TO user_name;
• B.GRANT ALL ON table_name TO user_name;
• C.GRANT SELECT ON table_name TO user_name;
• D.ALLOW SELECT ON table_name TO user_name;

What will the following SQL query do?
UPDATE employees
SET salary = salary * 1.1
WHERE department_id = 10;

• A.Decrease the salary of employees in department 10 by 10%
• B.Set the salary to 1.1 for employees in department 10
• C.Increase the salary of employees in department 10 by 10%
• D.Increase the salary of all employees by 10%

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

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

Which of the following data dictionary views provides information about constraints on tables?

• A.All of the above
• B.DBA_CONSTRAINTS
• C.USER_CONSTRAINTS
• D.ALL_CONSTRAINTS

Which clause in an UPDATE statement typically uses a subquery to assign values to columns?

• A.SET
• B.WHERE
• C.FROM
• D.HAVING