Free Oracle 1Z1-171 Exam Dumps Questions & Answers

Which of the following is a valid reason to create a synonym?

• A.To improve query performance
• B.To automatically generate numeric values for a column
• C.To enforce unique constraints on a table
• D.To provide simplified and consistent access to an object

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

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

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

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

What is the default order of evaluation when multiple SET operators are used in a query?

• A.UNION, INTERSECT, MINUS
• B.INTERSECT, MINUS, UNION
• C.INTERSECT, UNION, MINUS
• D.UNION, MINUS, INTERSECT

Which INTERVAL data type would you use to store a period of time in years and months?

• A.INTERVAL MINUTE TO HOUR
• B.INTERVAL YEAR TO MONTH
• C.INTERVAL MONTH TO DAY
• D.INTERVAL DAY TO SECOND