Online Access Free 1Z0-171 Practice Test

Which SQLPlus command displays defined substitution variable values?

• A.LIST
• B.DEFINE
• C.VERIFY
• D.SHOW

Which Oracle SQL function returns the current date and time, including time zone information?

• A.CURRENT_TIMESTAMP
• B.NOW
• C.CURRENT_DATE
• D.SYSDATE

Which of the following can be achieved using a correlated subquery?

• A.Retrieving duplicate records from a single table
• B.Joining two tables without a common column
• C.Comparing each employee's salary to the average salary of their department
• D.Inserting data into a table

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

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

What is the result of using the following SQL query?
SELECT 100 + NULL AS result;

• A.100
• B.An error
• C.0
• D.NULL