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

多选题

2022-01-03 23:06

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)

查看答案

正确答案

B| C

试题解析

标签： 1Z0-007

感兴趣题目

In each of the following groups of words, there are four underlined letters or letter combinations marked A, B, C and D. Compare the underlined parts and identify the one that is different from the others in pronunciation. Mark your answer by blackening the corresponding letter on the Answer Sheet.

Directions: In each of the following groups of words,there arc four underlined letters or letter combinationsmarked A, B, C and D. Compare the underlined parts and identify the one that is different from the others inpronunciation. Mark your answer by blackening the corresponding letter on the answer sheet.1.

Examine the description of the STUDENTS table:
STD_ID NUMBER(4)
COURSE_ID VARCHARD2(10)
START_DATE DATE
END_DATE DATE
Which two aggregate functions are valid on the START_DATE column?（）

（）shall be liable for loss of and damage to the Vessel and／or goods arising or resulting from inaccuracies in stating the description，quantity，weight，measurement or contents.

Whenever visible traces of oil are observed on or below the surface of the water in the immediate vicinity of ship or its wake，Governments of Parties to the Convention should，to the extent they are reasonably able to do so，promptly（）the facts bearing on the issue of whether there has been a violation of the provisions of this Regulation or Regulation 10 of this Annex of MARPOL 73/78.

Which of the following descriptions of the Mississippi River is NOT true?

The master may bind the Shipowner or Charterer（）doing such things as are necessary on the part of the one or of the other to carry out the contract.

Every deliberate act of wrongdoing by the master or any of the crew against the ship or cargo，without the authorization or privity of the Shipowner or his agent，is（）.

A salvor may be（）the whole or part of the payment due under Salvage Convention to the extent that the salvage operations have become necessary or more difficult because of fault or neglect on his part or if the salvor has been guilty of fraud or other dishonest conduct.

The（）may examine or re-examine the goods or take samples from them straightaway in the absence of the consignee or the consignor whenever it considers this necessary.

The life cycle of a project is a description of the various phases of the project from the beginning to the end. One of the followings is not a phase of the traditional project life cycleIt is().

Examine the description of the MARKS table:

SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table:

What is the result of the SELECT statement?（）