單項選擇題

Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?（）

A. SELECT SUBSTR( ‘Hello World’,1) FROM dual;
B. SELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;
C. SELECT LOWER(SUBSTR(‘Hello World’, 1, 1) FROM dual;
D. SELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;
E. SELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;

你可能感興趣的試題

多項選擇題

Which two statements about creating constraints are true? （）

A. Constraint names must start with SYS_C
B. All constraints must be defines at the column level
C. Constraints can be created after the table is created
D. Constraints can be created at the same time the table is created
E. Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

單項選擇題

The CUSTOMERS table has these columns:

Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）

A. SELECT customer_id, customer_name   FROM customers   WHERE postal_code CONTAINS NULL;
B. SELECT customer_id, customer_name   FROM customers   WHERE postal_code = '________';
C. SELECT customer_id, customer_name   FROM customers   WHERE postal_code IS NULL;
D. SELECT customer_id, customer_name   FROM customers   WHERE postal code IS NVL;
E. SELECT customer_id, customer_name   FROM customers   WHERE postal_code = NULL;

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?（）

你可能感興趣的試題

Which two statements about creating constraints are true? （）

The CUSTOMERS table has these columns: Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）

The CUSTOMERS table has these columns:

Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）