单项选择题
Evaluate this SQL statement: SELECT ename, sal, 12* sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?()
A. No change is required to achieve the desired results. B. SELECT ename, sal, 12* (sal+100) FROM emp; C. SELECT ename, sal, (12* sal)+100 FROM emp; D. SELECT ename, sal +100,*12 FROM emp;
单项选择题 Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?()
多项选择题 Which two statements are true regarding the ORDER BY clause?()
多项选择题 Which two tasks can your perform by using the TO_CHAR function?()