[单选]
The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(4)
ENAME VARCHAR2 (25)
JOB_ID VARCHAR2(10)
Which SQL statement will return the ENAME, length of the ENAME, and the numeric position of the
letter "a" in the ENAME column, for those employees whose ENAME ends with a the letter "n"?（）

A . SELECT ENAME, LENGTH(ENAME), INSTR(ENAME, 'a') FROM EMPLOYEES WHERE SUBSTR (ENAME, -1,1) = 'n';
B . SELECT ENAME, LENGTH(ENAME), INSTR(ENAME, ,-1,1) FROM EMPLOYEES WHERE SUBSTR (ENAME, -1,1) = 'n';
C . SELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR (ENAME, 1,1) = 'n';
D . SELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR (ENAME, -1,1) = 'n'

通过设置一定的情境让学生自然而然地得到教育的一种教育方法叫（）。 In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（） recovery catalog。 Oracle Enterprise Manager Repository。 Automatic Workload Repository （AWR）。 Oracle 10g Enterprise Manager Grid Control。 Automatic Database Diagnostic Monitor （ADDM）。语言教育活动的"有计划"集中体现在哪些方面？ You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this. Which data type would you use for the new column（） CLOB。 BLOB。 BFILE。 LONG RAW。真核微生物

The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(4)
ENAME VARCHAR2 (25)
JOB_ID VARCHAR2(10)
Which SQL statement will return the ENAME, length of the ENAME, and the numeric position of the
letter "a" in the ENAME column, for those employees whose ENAME ends with a the letter "n"?（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-007题库

相关题目: