Q72 Examine the description of the employees table:
Which query requires explicit data type conversion?
- (A). SELECT join_date FROM employees WHERE join_date > ’10-02-2018′;
- (B). SELECT join_date I I ‘ ‘ II salary FROM employees;
- (C). SELECT SUBSTR(join_date, 1, 2) – 10 FROM employees;
- (D). SELECT join_date + ’20’ FROM employees; SELECT salary * ‘120.50’ FROM employees;
Xem thêm:
- Q135 Which two are true about a SQL statement using SET operators such as UNION?
- Sử dụng hàm MIN() và MAX() trong SQL
- Q166 Which query produces output for CUST_LAST_NAME containing Oder for the first row and Aus for the second?
- Q163 Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)?
- Sửa lỗi CSDL với Data Recovery Advisor Oracle database