搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

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 SELECT statement will the result ‘ello World’ from the string ‘Hello World’?（）”相关的问题
第1题
[] Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?（） Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?（）

A、A.SELECT*FROMDEPT；  B、B.SELECT*FROMSCOTT.DEPT；  C、C.SELECT*FROMDBASCOTTDEPT；  D、D.SELECT*FROMALL_USERSWHEREUSER_NAME='；SCOTT'；ANDTABLENAME='；DEPT'；；  

点击查看答案
第2题
[单选题] Which object privileges can be granted on a view?（）

A、none  B、DELETE, INSERT,SELECT  C、ALTER, DELETE, INSERT, SELECT  D、DELETE, INSERT, SELECT, UPDATE  

点击查看答案
第3题
[单选题] Which object privileges can be granted on a view?（）

A、none  B、DELETE, INSERT,SELECT  C、ALTER, DELETE, INSERT, SELECT  D、DELETE, INSERT, SELECT, UPDATE  

点击查看答案
第4题
[单选题] Which object privileges can be granted on a view? （）

A、none  B、DELETE, INSERT,SELECT  C、ALTER, DELETE, INSERT, SELECT  D、DELETE, INSERT, SELECT, UPDATE  

点击查看答案
第5题
[单选题] Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?（）

A、SELECT * FROM t1 UNION SELECT * FROM t2  B、SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2  C、SELECT * FROM t1 INTERSECT SELECT * FROM t2  D、SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)  

点击查看答案
第6题
[] Which object privileges can be granted on a view? （）

A、A. none  B、B. DELETE, INSERT,SELECT  C、C. ALTER, DELETE, INSERT, SELECT  D、D. DELETE, INSERT, SELECT, UPDATE  

点击查看答案
第7题
[单选题] Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?（）

A、SELECT * FROM t1 UNION SELECT * FROM t2  B、SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2  C、SELECT * FROM t1 INTERSECT SELECT * FROM t2  D、SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)  

点击查看答案
第8题
[多选题] Which three SELECT statements displays 2000 in the format "$2,000.00"? （）

A、SELECT TO CNAR(2000, '$#,###.##') FROM dual;  B、SELECT TO CNAR(2000, '$0,000.00') FROM dual;  C、SELECT TO CNAR(2000, '$9,999.00') FROM dual;  D、SELECT TO CNAR(2000, '$9,999.99') FROM dual;  E、SELECT TO CNAR(2000, '$2,000.00') FROM dual;  F、SELECT TO CNAR(2000, '$N,NNN.NN') FROM dual;  

点击查看答案
第9题
[多选题] Which three SELECT statements displays 2000 in the format "$2,000.00"? （）

A、SELECT TO CNAR(2000, '$#,###.##') FROM dual;  B、SELECT TO CNAR(2000, '$0,000.00') FROM dual;  C、SELECT TO CNAR(2000, '$9,999.00') FROM dual;  D、SELECT TO CNAR(2000, '$9,999.99') FROM dual;  E、SELECT TO CNAR(2000, '$2,000.00') FROM dual;  F、SELECT TO CNAR(2000, '$N,NNN.NN') FROM dual;  

点击查看答案
第10题
[] Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（） Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（）

A、A.SELECT * FROM T1 MINUS SELECT * FROM T2  B、B.SELECT * FROM T1 EXCEPT SELECT * FROM T2  C、C.SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1  D、D.SELECT * FROM T1 NOT EXISTS SELECT * FROM T2  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服