Oracle Database 23ai SQL Associate - 1Z0-171 Exam Practice Test
Which of the following best describes a relational database?
Correct Answer: C
Vote an answer
Which of the following is true about foreign key constraints in SQL?
Correct Answer: C
Vote an answer
Which type of INSERT statement allows inserting rows into multiple tables using a single SELECT query?
Correct Answer: C
Vote an answer
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;
Correct Answer: A
Vote an answer
What does the following SQL statement do?
SELECT e.employee_id, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;
SELECT e.employee_id, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;
Correct Answer: A
Vote an answer
What is the primary purpose of granting privileges in Oracle Database?
Correct Answer: B
Vote an answer