搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单项选择题】

Examine the description of the EMPLOYEES table:<br /> EMP_ID NUMBER(4) NOT NULL<br /> LAST_NAME VARCHAR2(30) NOT NULL<br /> FIRST_NAME VARCHAR2(30)<br /> DEPT_ID NUMBER(2)<br /> Which statement produces the number of different departments that have employees with last name Smith?（）<p> Examine the description of the EMPLOYEES table:<br /> EMP_ID NUMBER(4) NOT NULL<br /> LAST_NAME VARCHAR2(30) NOT NULL<br /> FIRST_NAME VARCHAR2(30)<br /> DEPT_ID NUMBER(2)<br /> Which statement produces the number of different departments that have employees with last name Smith?（）</p>

A、A. SELECT COUNT (*) FROM employees WHERE last _name='smith';

B、B. SELECT COUNT (dept_id) FROM employees WHERE last _name='smith';

C、C. SELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name='smith';

D、D. SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith';

E、E. SELECT UNIQE (dept_id) FROM employees WHERE last _name='smith';

查看正确答案
更多“Examine the description of the EMPLOYEES table:<br /> EMP_ID NUMBER(4) NOT NULL<br /> LAST_NAME VARCHAR2(30) NOT NULL<br /> FIRST_NAME VARCHAR2(30)<br /> DEPT_ID NUMBER(2)<br /> Which statement produces the number of different departments that have employees with last name Smith?（）<p> Examine the description of the EMPLOYEES table:<br /> EMP_ID NUMBER(4) NOT NULL<br /> LAST_NAME VARCHAR2(30) NOT NULL<br /> FIRST_NAME VARCHAR2(30)<br /> DEPT_ID NUMBER(2)<br /> Which statement produces the number of different departments that have employees with last name Smith?（）</p>”相关的问题
第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题
[] 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?（）

A、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、B. The statement returns an error at the SELECT clause.  C、C. The statement returns an error at the WHERE clause.  D、D. The statement returns an error at the ORDER BY clause.  

点击查看答案
第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题
[单选题] 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.  

点击查看答案
第6题
[多选题] 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)  

点击查看答案
第7题
[] 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.  

点击查看答案
第8题
[] 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]  

点击查看答案
第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.  

点击查看答案
第10题
[单选题] 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.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服