Oracle 1Z1-171 Actual Free Exam Questions & Community Discussion
What will the following query return?
SELECT EXTRACT(YEAR FROM CURRENT_DATE) AS year FROM dual;
SELECT EXTRACT(YEAR FROM CURRENT_DATE) AS year FROM dual;
Correct Answer: C
Vote an answer
What happens when the TRUNCATE TABLE statement is executed?
Correct Answer: C
Vote an answer
What is the output of the following query?
SELECT CURRENT_DATE FROM dual;
SELECT CURRENT_DATE FROM dual;
Correct Answer: A
Vote an answer
What does the following SQL statement do?
ALTER TABLE employees DROP COLUMN salary;
ALTER TABLE employees DROP COLUMN salary;
Correct Answer: A
Vote an answer
What does the following query return?
SELECT employee_id
FROM employees
WHERE department_id IN (SELECT department_id FROM departments WHERE location_id = 1000);
SELECT employee_id
FROM employees
WHERE department_id IN (SELECT department_id FROM departments WHERE location_id = 1000);
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: C
Vote an answer
Which of the following is a valid reason to create a synonym?
Correct Answer: C
Vote an answer
Which of the following can be achieved using a correlated subquery?
Correct Answer: C
Vote an answer
0
0
0
10