Oracle Database 23ai SQL Associate - 1Z0-171 模擬練習
Which SQL keyword is used to define a substitution variable in a SQL statement?
正解: B
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;
正解: C
What is the result of the following SQL query?
SELECT COALESCE(NULL, 100, 200) AS result FROM dual;
SELECT COALESCE(NULL, 100, 200) AS result FROM dual;
正解: A
What is the purpose of using external tables in Oracle Database?
正解: B
What does the following SQL statement do?
SELECT e.employee_id, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;
SELECT e.employee_id, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;
正解: A
Which SQL function calculates the number of months between two dates?
Response:
Response:
正解: C
What does the following command do?
GRANT CREATE SESSION TO user_name;
GRANT CREATE SESSION TO user_name;
正解: B
What does the following SQL query do?
SELECT *
FROM employees e
JOIN employees m ON e.manager_id = m.employee_id;
SELECT *
FROM employees e
JOIN employees m ON e.manager_id = m.employee_id;
正解: C
Which data dictionary view lists all indexes created by the current user?
正解: A
Which command would drop an index from a table?
正解: C