Free Oracle 1Z0-171 Exam Dumps Questions & Answers

What is the purpose of the DBA_OBJECTS data dictionary view?

• A.To list all users in the database
• B.To monitor system performance
• C.To show the current session details
• D.To provide information about all objects in the database

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

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

What will the following query return?
SELECT TO_CHAR(SYSDATE, 'DD-MM-YYYY') AS formatted_date FROM dual;

• A.An error
• B.The time part of the current date
• C.The current date in the default system format
• D.The current date in the format 'DD-MM-YYYY'

Which type of join includes rows that do not have matching values in the joined table?

• A.SELF JOIN
• B.CROSS JOIN
• C.OUTER JOIN
• D.INNER JOIN

How are NULL values treated in relational databases?

• A.NULL values represent missing or unknown data.
• B.NULL values are treated as zero.
• C.NULL values are treated as empty strings.
• D.NULL values are not allowed in relational databases.