最新的Oracle Database 23ai SQL Associate - 1Z1-171免費考試真題
What does the following SQL query return?
SELECT employee_id, salary * 12 AS annual_salary FROM employees;
SELECT employee_id, salary * 12 AS annual_salary FROM employees;
正確答案: D
How are NULL values treated in relational databases?
正確答案: C
What is the purpose of the SAVEPOINT statement?
正確答案: B
What is the output of the following query?
SELECT CURRENT_DATE FROM dual;
SELECT CURRENT_DATE FROM dual;
正確答案: B
Which command grants a user the ability to query data from a specific table?
正確答案: A
Which function returns the current system date and time in the database session's time zone?
正確答案: A
What will the following SQL query return?
SELECT TRUNC(15.678, 2) AS truncated_value FROM dual;
SELECT TRUNC(15.678, 2) AS truncated_value FROM dual;
正確答案: A
What does the INTERSECT operator do in SQL?
正確答案: A