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?（） -题库考试答案搜索网

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

单选题

2022-09-22 04:51

A、The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
B、The statement returns an error at the SELECT clause.
C、The statement returns an error at the WHERE clause.
D、The statement returns an error at the ORDER BY clause.

查看答案

正确答案

试题解析

标签： CMS专题

感兴趣题目

You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）

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.

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

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

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().

Exhibit： Using Database Control， you have scheduled a job to shrink the TRANStable residing on the TTtablespace. The job would run at 5：00 p.m. every Friday.When you examine the space usage of the table after the completion of the job， you find that the table has not been shrunk. What could have been the reason for this？（）

You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?（）

You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 1000 bytes. The column can currently hold 500 bytes per value. The table contains 20000 rows. Which statement is valid?（）

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