Oracle Database 23ai SQL Associate - 1Z1-171 模擬練習
What does the following SQL query return?
SELECT employee_id, salary * 12 AS annual_salary FROM employees;
SELECT employee_id, salary * 12 AS annual_salary FROM employees;
正解: B
Which SQLPlus command displays defined substitution variable values?
正解: B
What is the primary purpose of granting privileges in Oracle Database?
正解: C
What is a subquery in SQL?
正解: A
Which type of privilege allows a user to perform administrative tasks, such as creating other users?
正解: D
Which command grants a user the ability to query data from a specific table?
正解: A
Which component of an ERD (Entity-Relationship Diagram) represents the attributes of an entity?
正解: C
What is the purpose of the DBA_OBJECTS data dictionary view?
正解: D
What does the EXISTS operator check in a subquery?
正解: B
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;
正解: D