Oracle Database 23ai SQL Associate - 1Z0-171 FREE EXAM DUMPS QUESTIONS & ANSWERS
Which SQL keyword is used to define a substitution variable in a SQL statement?
Correct Answer: B
Vote an answer
Which function is used to extract the year from a date in SQL?
Correct Answer: A
Vote an answer
What will the following SQL statement output?
SELECT first_name || ' ' || last_name AS full_name FROM employees;
SELECT first_name || ' ' || last_name AS full_name FROM employees;
Correct Answer: D
Vote an answer
What will the following SQL query do?
UPDATE employees
SET salary = salary * 1.1
WHERE department_id = 10;
UPDATE employees
SET salary = salary * 1.1
WHERE department_id = 10;
Correct Answer: A
Vote an answer
What happens if a privilege is revoked from a user who has granted the same privilege to others?
Correct Answer: D
Vote an answer
How is the LOCALTIMESTAMP function different from CURRENT_TIMESTAMP?
Correct Answer: A
Vote an answer
Which command is used to add a new column to an existing table?
Correct Answer: C
Vote an answer