Oracle数据库考试试题库(3)

哪个输出是正确的？（ B ） A. Abigail PA B. Abigail Pa C. Abigail IS

D. an error message 41. 查看下列查询：

SQL> SELECT TRUNC(ROUND(156.00,-1),-1) FROM DUAL; 哪个输出是正确的？（ C ） A. 16 B. 100 C. 160 D. 200 E. 150

42. 查看表CUSTOMER的CUST_NAME字段的值： CUST_NAME ------------------------ Renske Ladwig Jason Mallin Samuel McCain Allan MCEwen Irene Mikkilineni Julia Nayer

你需要显示的客户，其中第二名称以“Mc”或“MC ”。 哪个查询能得到正确的结果？（ B ）

A. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers

WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1))='Mc'; B. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers

WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) LIKE 'Mc%'; C. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers

WHERE SUBSTR(cust_name, INSTR(cust_name,' ')+1) LIKE INITCAP('MC%'); D. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers

WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) = INITCAP('MC%'); 43. 查看表CUST_TRANS的结构和数据： CUST_TRANS

------------------------- Name Null Type

CUSTNO NOT NULL CHAR(2) TRANSDATE DATE

TRANSAMT NUMBER(6,2)

CUSTNO TRANSDATE TRANSAMT

---------------------------------------- 11 01-JAN-07 1000 22 01-FEB-07 2000 33 01-MAR-07 3000

日期存储的默认格式为dd-mon-rr。

哪个SQL语句能执行成功？（ ACD ）选三项 A. SELECT transdate + '10' FROM cust_trans;

B. SELECT * FROM cust_trans WHERE transdate = '01-01-07'; C. SELECT transamt FROM cust_trans WHERE custno > '11';

D. SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07'; E. SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000; 44. 你需要计算从2007年1月1日至今天的天数？ 日期的默认存储格式为dd-mon-rr。

下列哪两个SQL能得到正确的结果？（ BC ）选二项 A. SELECT SYSDATE - '01-JAN-2007' FROM DUAL;

B. SELECT SYSDATE - TO_DATE('01/JANUARY/2007') FROM DUAL; C. SELECT SYSDATE - TO_DATE('01-JANUARY-2007') FROM DUAL;

D. SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY') - '01-JAN-2007' FROM DUAL;

E. SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2007' FROM DUAL;

45. 下列哪两个SQL语句能执行成功？（ AB ）

A. UPDATE promotions

SET promo_cost = promo_cost+ 100

WHERE TO_CHAR(promo_end_date, 'yyyy') > '2000'; B. SELECT promo_begin_date FROM promotions

WHERE TO_CHAR(promo_begin_date,'mon dd yy')='jul 01 98'; C. UPDATE promotions

SET promo_cost = promo_cost+ 100

WHERE promo_end_date > TO_DATE(SUBSTR('01-JAN-2000',8)); D. SELECT TO_CHAR(promo_begin_date,'dd/month') FROM promotions

WHERE promo_begin_date IN (TO_DATE('JUN 01 98'), TO_DATE('JUL 01 98')); 46. 查看表PROGRAMS结构： name Null Type

PROG_ID NOT NULL NUMBER(3) PROG_COST NUMBER(8,2) START_DATE NOT NULL DATE END_DATE DATE

下列哪两个SQL语句能执行成功？（AD）

A. SELECT NVL(ADD_MONTHS(END_DATE,1),SYSDATE) FROM programs;

B. SELECT TO_DATE(NVL(SYSDATE-END_DATE,SYSDATE)) FROM programs;

C. SELECT NVL(MONTHS_BETWEEN(start_date,end_date),'Ongoing') FROM programs;

D. SELECT NVL(TO_CHAR(MONTHS_BETWEEN(start_date,end_date)),'Ongoing') FROM programs;

47. 查看表INVOICE结构： name Null Type

INV_NO NOT NULL NUMBER(3) INV_DATE DATE

INV_AMT NUMBER(10,2)

下列哪两个SQL语句能执行成功？（ AC ）

A. SELECT inv_no,NVL2(inv_date,'Pending','Incomplete') FROM invoice;

B. SELECT inv_no,NVL2(inv_amt,inv_date,'Not Available') FROM invoice;

C. SELECT inv_no,NVL2(inv_date,sysdate-inv_date,sysdate) FROM invoice;

D. SELECT inv_no,NVL2(inv_amt,inv_amt*.25,'Not Available') FROM invoice;

48. 查看表PRODUCTS的LIST_PRICE和MIN_PRICE字段： LIST_PRICE MIN_PRICE ------------------------------------- 10000 8000 20000

30000 30000

哪两个表达式能得到一样的结果？（ BD ） A. NVL(NULLIF(list_price, min_price), 0) B. NVL(COALESCE(list_price, min_price), 0)

C. NVL2(COALESCE(list_price, min_price), min_price, 0) D. COALESCE(NVL2(list_price, list_price, min_price), 0) 49. 查看表INVOICE的结果：

哪两个SQL语句能执行成功？（ BD ） A. SELECT AVG(inv_date ) FROM invoice;

B. SELECT MAX(inv_date),MIN(cust_id) FROM invoice;

C. SELECT MAX(AVG(SYSDATE - inv_date)) FROM invoice;

D. SELECT AVG( inv_date - SYSDATE), AVG(inv_amt) FROM invoice;

50. 查看表MARKS结构： name Null Type

----------------------------------------------------------- STUDENT_ID NOT NULL VARCHAR2(4) STUDENT_NAME VARCHAR2(25) SUBJECT1 NUMBER(3) SUBJECT2 NUMBER(3) SUBJECT3 NUMBER(3)

哪两个SQL语句能执行成功？（ CD ） A. SELECT student_name,subject1 FROM marks

WHERE subject1 > AVG(subject1);

B. SELECT student_name,SUM(subject1) FROM marks

WHERE student_name LIKE 'R%';

C. SELECT SUM(subject1+subject2+subject3) FROM marks

WHERE student_name IS NULL;

D. SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1) FROM marks

WHERE subject1 > subject2;

51. 查看表PROMOTIONS结构，检查下列SQL语句：

SQL>SELECT promo_category, AVG(promo_cost) Avg_Cost, AVG(promo_cost)*.25 Avg_Overhead

FROM promotions

WHERE UPPER(promo_category) IN ('TV', 'INTERNET','POST') GROUP BY Avg_Cost

ORDER BY Avg_Overhead;

此SQL查询在执行时会生成一个错误。哪个是原因导致这个错误？（ C ） A. WHERE B. SELECT C. GROUP BY D. ORDER BY

52. 查看表CUSTOMERS的数据： CUSTNO CUSTNAME CITY

------------------------------------------------ 1 KING SEATTLE 2 GREEN BOSTON 3 KOCHAR SEATTLE 4 SMITH NEW YORK

你想要显示多个客户的相关详细信息的所有城市，查看下列查询： SQL>SELECT c1.custname, c1.city

FROM Customers c1 __________________ Customers c2 ON (c1.city=c2.city AND c1.custname<>c2.custname); 哪两个JOIN选项能得到正确的输出？（ AE ） A. JOIN

B. NATURAL JOIN C. LEFT OUTER JOIN D. FULL OUTER JOIN E. RIGHT OUTER JOIN

53. 查看表CUSTOMERS, SALES, 和COUNTRIES，你需要生成一个报表用来显示所有的

城市 名及相关的所有客户（如果有）和销售明细（如果有）。 哪个FROM子句能得到需要的结果？（ C ） A. FROM sales JOIN customers USING (cust_id) FULL OUTER JOIN countries USING (country_id); B. FROM sales JOIN customers USING (cust_id) RIGHT OUTER JOIN countries USING (country_id);

C. FROM customers LEFT OUTER JOIN sales USING (cust_id) RIGHT OUTER JOIN countries USING (country_id);

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库Oracle数据库考试试题库(3)在线全文阅读。