Oracle Database 23ai SQL Associate - 1Z1-171 Exam Practice Test
What does the following command do?
GRANT CREATE SESSION TO user_name;
GRANT CREATE SESSION TO user_name;
Correct Answer: A
Vote an answer
Which clause is used to ensure that only specific rows are deleted in a DELETE statement?
Correct Answer: A
Vote an answer
Which SQL function calculates the number of months between two dates?
Response:
Response:
Correct Answer: D
Vote an answer
What does the UNION ALL operation do when selecting matching columns from different tables?
SELECT employee_id, salary FROM employees
UNION ALL
SELECT employee_id, bonus FROM bonuses;
SELECT employee_id, salary FROM employees
UNION ALL
SELECT employee_id, bonus FROM bonuses;
Correct Answer: A
Vote an answer
What is the result of using the following SQL query?
SELECT 100 + NULL AS result;
SELECT 100 + NULL AS result;
Correct Answer: D
Vote an answer
What is the relationship between SQL and a relational database?
Correct Answer: D
Vote an answer