多項(xiàng)選擇題

Examine the description of the MARKS table:
STD_ID NUMBER(4)
STUDENT_NAME VARCHAR2(30)
SUBJ1 NUMBER(3)
SUBJ2 NUMBER(3)
SUBJ3 NUMBER(3)
SUBJ1, SUBJ2, and SUBJ3 indicate the marks (grades) obtained by a student in the three subjects. Which two statements are valid? （）

A.SELECT SUM(subj1, subj2, subj3) FROM marks;
B.SELECT SUM(subj1 + subj2 + subj3) FROM marks;
C.SELECT SUM(subj1), SUM(subj2), SUM(subj3) FROM marks;
D.SELECT MAX(subj1, subj2, subj3) FROM marks;
E.SELECT MINIMUM(subj1) FROM marks;
F.SELECT COUNT(std_id) FROM marks WHERE subj1 >= AVG(subj1);

你可能感興趣的試題

單項(xiàng)選擇題

Examine the description of the EMPLOYEES table:

Which statement produces the number of different departments that have employees with last name Smith?（）

A.SELECT COUNT(*) FROM employees WHERE last_name='Smith';
B.SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith';
C.SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';
D.SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';
E.SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';

單項(xiàng)選擇題

Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?（）

A.SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;
B.SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;
C.SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;
D.SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;
E.SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ3 NUMBER(3) SUBJ1, SUBJ2, and SUBJ3 indicate the marks (grades) obtained by a student in the three subjects. Which two statements are valid? （）

你可能感興趣的試題

Examine the description of the EMPLOYEES table: Which statement produces the number of different departments that have employees with last name Smith?（）

Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

Examine the description of the MARKS table:
STD_ID NUMBER(4)
STUDENT_NAME VARCHAR2(30)
SUBJ1 NUMBER(3)
SUBJ2 NUMBER(3)
SUBJ3 NUMBER(3)
SUBJ1, SUBJ2, and SUBJ3 indicate the marks (grades) obtained by a student in the three subjects. Which two statements are valid? （）

Examine the description of the EMPLOYEES table:

Which statement produces the number of different departments that have employees with last name Smith?（）