A. none B. DELETE, INSERT,SELECT C. ALTER, DELETE, INSERT, SELECT D. DELETE, INSERT, SELECT, UPDATE
A. SELECT ename, salary*12 ‘Annual Salary’ FROM employees; B. SELECT ename, salary*12 “Annual Salary” FROM employees; C. SELECT ename, salary*12 AS Annual Salary FROM employees; D. SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”) FROM employees
A. Once created, a sequence belongs to a specific schema. B. Once created, a sequence is linked to a specific table. C. Once created, a sequence is automatically available to all users. D. Only the DBA can control which sequence is used by a certain table. E. Once created, a sequence is automatically used in all INSERT and UPDATE statements.