Online Access Free 1Z1-171 Exam Questions

Which SQL clause can be used in Oracle to limit the number of rows returned?

• A.DISTINCT
• B.FETCH FIRST n ROWS ONLY
• C.WHERE
• D.GROUP BY

Which function returns the current system date and time in the database session's time zone?

• A.SYSDATE
• B.LOCAL_TIME
• C.SYSTEM_TIME
• D.CURRENT_TIMESTAMP

How does SQL handle NULL values in arithmetic expressions?

• A.Produces an error
• B.Treats them as the largest possible number
• C.Treats them as zero
• D.Produces a NULL result

What is a role in Oracle Database?

• A.A user-defined function
• B.A set of privileges that can be granted to users or other roles
• C.A predefined SQL statement stored in the database
• D.A database object used to enforce constraints

Which statement can be used to undo changes made in a transaction?

• A.MERGE
• B.COMMIT
• C.SAVEPOINT
• D.ROLLBACK