1Z0-171 Exam Question 6
What does the following command do?
GRANT CREATE SESSION TO user_name;
GRANT CREATE SESSION TO user_name;
1Z0-171 Exam Question 7
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;
1Z0-171 Exam Question 8
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;
1Z0-171 Exam Question 9
How can you ensure that data is sorted in descending order in a SQL query?
1Z0-171 Exam Question 10
Which SQL statement is used to insert a new row into a table?