可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Examine the description of the EMPLOY


Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHAR2(30) SALARY NUMBER(8,2) Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and the maximum salary is more than 15000?()

  • A SELECT dept_id, MIN(salary(, MAX(salary) FROM employees WHERE MIN(salary) <5000 AND MAX (salary) > 15000;
  • B SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000 GROUP BY dept_id;
  • C SELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) <5000 AND MAX (salary) > 15000;
  • D SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN (salary) < 5000 AND MAX(salary)
  • E SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN (salary) <5000 AND MAX (salary) > 15000
参考答案
参考解析:
分类:1Z0-007题库
相关推荐

1、Examine the description of the EMPLOY

Examine the description of the EMPLOYEES table:EMP_ID NUMBER(4) NOT NULLLAST_NAME VARCHAR2(30) NOT NULLFIRST_NAME VARCHAR2(30)DEPT_ID NUMBER(2)Which s...

2、Examine the description of the CUSTOM

Examine the description of the CUSTOMERS table:CUSTOMER_ID NUMBER(4) NOT NULLCUSTOMER_NAME VARCHAR2(100) NOT NULLSTREET_ADDRESS VARCHAR2(150)CITY_ADDRES...

3、Examine the description of the STUDEN

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)

4、Examine the description of the MARKS

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 SUBJ...

5、Examine the description of the EMPLOY

Examine the description of the EMPLOYEES table:EMP_ID NUMBER(4) NOT NULLLAST_NAME VARCHAR2(30) NOT NULLFIRST_NAME VARCHAR2(30)DEPT_ID NUMBER(2)Which s...

6、Examine the description of the STUDEN

Examine the description of the STUDENTS table:STD_ID NUMBER(4)COURSE_ID VARCHARD2(10)START_DATE DATEEND_DATE DATEWhich two aggregate functions are val...