Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SELECT subj1+subj2 total_marks, std_id FROM marks WHERE subj1 > AVG(subj1) AND subj2 > AVG(subj2) ORDER BY total_ marks; What is the result of the SELECT statement?（） Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SELECT subj1+subj2 total_marks, std_id FROM marks WHERE subj1 > AVG(subj1) AND subj2 > AVG(subj2) ORDER BY total_ marks; What is the result of the SELECT statement?（）..

第1题

[单选题] 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?（）

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.

点击查看答案

第2题

[单选题] 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?（）

A、ALTER TABLE commercials MODIFY (description CHAR2(2000)); B、ALTER TABLE commercials CHANGE (description CHAR2(2000)); C、ALTER TABLE commercials CHANGE (description VARCHAR2 (2000)); D、ALTER TABLE commercials MODIFY (description VARCHAR2 (2000)); E、You cannot increase the size of a column if the table has rows.

点击查看答案

第3题

[单选题] 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?（）

A、ALTER TABLE commercials MODIFY (description CHAR2(2000)); B、ALTER TABLE commercials CHANGE (description CHAR2(2000)); C、ALTER TABLE commercials CHANGE (description VARCHAR2(2000)); D、ALTER TABLE commercials MODIFY (description VARCHAR2(2000)); E、You cannot increase the size of a column if the table has rows.

点击查看答案

第4题

[单选题] 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?（）

A、ALTER TABLE commercials MODIFY (description CHAR2(2000)); B、ALTER TABLE commercials CHANGE (description CHAR2(2000)); C、ALTER TABLE commercials CHANGE (description VARCHAR2 (2000)); D、ALTER TABLE commercials MODIFY (description VARCHAR2 (2000)); E、You cannot increase the size of a column if the table has rows.

点击查看答案

第5题

[多选题] Examine the description of the STUDENTS table: Which two aggregate functions are valid on the START_DATE column?（）

A、SUM(start_date) B、AVG(start_date) C、COUNT(start_date) D、AVG(start_date, end_date) E、MIN(start_date) F、MAXIMUM(start_date)

点击查看答案

第6题

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

A、A.ALTER TABLE commercials MODIFY (description CHAR2(1000)); B、B.ALTER TABLE commercials CHANGE (description CHAR2(1000)); C、C.ALTER TABLE commercials CHANGE (description VARCHAR2(1000)); D、D.ALTER TABLE commercials MODIFY (description VARCHAR2(1000)); E、E.You cannot increase the size of a column if the table has rows.

点击查看答案

第7题

[] Give the description of the following sound segments in English. [k];[z];[w];[u:];[i]

A、Give the description of the following sound segments in English. B、[k];[z];[w];[u:];[i]

点击查看答案

第8题

[单选题] Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SELECT subj1+subj2 total_marks, std_id FROM marks WHERE subj1 > AVG(subj1) AND subj2 > AVG(subj2) ORDER BY total_ marks; What is the result of the SELECT statement? （）

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.

点击查看答案

第9题

[单选题] Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SELECT subj1+subj2 total_marks, std_id FROM marks WHERE subj1 > AVG(subj1) AND subj2 > AVG(subj2) ORDER BY total_marks; What is the result of the SELECT statement?（）

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.

点击查看答案

请使用微信扫码支付