Oracle 1Z1-171 Actual Free Exam Questions & Community Discussion
Which operator can be used in a multiple-row subquery to match a single value to a list of values?
Correct Answer: B
Vote an answer
Which of the following data dictionary views provides information about constraints on tables?
Correct Answer: A
Vote an answer
Which INTERVAL data type would you use to store a period of time in years and months?
Correct Answer: C
Vote an answer
Which SQL keyword is used to remove duplicate rows from the result set of a query?
Correct Answer: B
Vote an answer
Which statement can be used to undo changes made in a transaction?
Correct Answer: C
Vote an answer
Which of the following is an example of an object privilege?
Correct Answer: B
Vote an answer
What will the following query result in?
SELECT e.employee_id, e.manager_id
FROM employees e
WHERE e.manager_id IS NOT NULL;
SELECT e.employee_id, e.manager_id
FROM employees e
WHERE e.manager_id IS NOT NULL;
Correct Answer: B
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