A. it can be used to concatenate two strings.
B. it can be used to find out the total length of the string.
C. it can be used for string manipulation and searching operations.
D. it can be used to format the output for a column or expression having string data.
E. it can be used to find and replace operations for a column or expression having string data.
您可能感兴趣的试卷
你可能感兴趣的试题
EMPDET is an external table containing the columns EMPNO and ENAME.
Which command would work in relation to the EMPDET table？ （）
A.A
B.B
C.C
D.D
A. ’os’
B. local
C. -8：00’
D. dbtimezone Li
E. ’Australia’
最新试题
View the Exhibit and examine the data in the PRODUCT INFORMATION table.Which two tasks would require subqueries？ （）
Evaluate the following SQL statements that are issued in the given order： What would be the status of the foreign key EMP_MGR_FK？（）
View the Exhibit and examine the details of the EMPLOYEES table. The query was written to format the PHONE_NUMBER for the employees. Which option would be the correct format in the output？（）
View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables.What would be the outcome of the above statement？（）
View the Exhibit and examine the structure of the EMP table.You executed the following command to add a primary key to the EMP table： ALTER TABLE emp ADD CONSTRAINT emp_id_pk PRIMARY KEY （emp_id） USING INDEX emp_id_idx； Which statement is true regarding the effect of the command？（）
Which statements are correct regarding indexes？ （）
The details of the order ID， order date， order total， and customer ID are obtained from the ORDERS table. If the order value is more than 30000， the details have to be added to the LARGEjDRDERS table. The order ID， order date， and order total should be added to the ORDERJHISTORY table， and order ID and customer ID should be added to the CUSTJHISTORY table. Which multitable INSERT statement would you use？ （）
EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table？ （）
View the Exhibit and examine the structure of the ORDERS table.Which task would require subqueries？ （）
EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table？（）