單項(xiàng)選擇題

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;

你可能感興趣的試題

多項(xiàng)選擇題

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

單項(xiàng)選擇題

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;

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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?（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

The CUSTOMERS table has these columns:

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