Oracle 1Z0-171 Actual Free Exam Questions & Community Discussion
What does the following command do?
GRANT CREATE SESSION TO user_name;
GRANT CREATE SESSION TO user_name;
Correct Answer: D
Vote an answer
Which of the following best describes a relational database?
Correct Answer: A
Vote an answer
What does the following query return?
SELECT ROUND(123.456, 1) AS rounded_value FROM dual;
SELECT ROUND(123.456, 1) AS rounded_value FROM dual;
Correct Answer: C
Vote an answer
Which command is used to add a new column to an existing table?
Correct Answer: B
Vote an answer
Which SQL function can be used to replace NULL values with a specified value?
Correct Answer: C
Vote an answer
What will the following query do?
SELECT employee_id, salary
FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);
SELECT employee_id, salary
FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);
Correct Answer: D
Vote an answer
0
0
0
10