单选题A A family list.B A resume.C A ticket.D Their salary requirement.

题目
单选题
A

A family list.

B

A resume.

C

A ticket.

D

Their salary requirement.

相似考题

1.We try our best to() your requirement.A、meetB、getC、make

2.Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000? ()A. ORDER BY SALARY > 5000B. GROUP BY SALARY > 5000C. HAVING SALARY > 5000D. WHERE SALARY > 5000

3.Examine the data in the EMPLOYEES table:LAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 30 5000...Which three subqueries work? ()A. SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);C. SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);D. SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);E. SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);F. SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));

4.删除视图salary的命令是( )。A.DROP VIEW salaryB.DROP salary VIEWC.DELETE salaryD.DELETE salary VIEW

更多“单选题A A family list.B A resume.C A ticket.D Their salary requirement.”相关问题

  • 第1题：

    Click the Exhibit button and examine the data in the EMPLOYEES table.Which three subqueries work? ()

    A.SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);

    B.SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);

    C.SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);

    D.SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);

    E.SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);

    F.SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));


    参考答案：C, D, E

  • 第2题：

    SQL中，SALARYIN(1000，2000)的语义是______。

    A．SALARY≤2000 AND SALARY≥1000

    B．SALARY＜2000 AND SALARY＞1000

    C．SALARY=1000 AND SALARY=2000

    D．SALARY=1000 OR SALARY=2000


    正确答案：D

  • 第3题：

    Some women ___________ a good salary in a job instead of staying home, but they decided not to work for the sake of the family.

    A.must make
    B.should have made
    C.would make
    D.could have made

    答案：D
    解析：
    考查情态动词的用法。Should have done表示过去本应该做某事而实际上没有做；could have done表示过去本来有能力可以做某事而实际上没有做，通常译为“本来可以”“本来能够”等。句意为“有些妇女本来可以出去工作挣得高薪，不必待在家里，但是她们为了家庭而决定放弃工作”，could have done比较符合题意。

  • 第4题：

    Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?（）

    • A、ORDER BY SALARY > 5000
    • B、GROUP BY SALARY > 5000
    • C、HAVING SALARY > 5000
    • D、WHERE SALARY > 5000

    正确答案:D

  • 第5题：

    Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）

    • A、SELECT ename, salary*12 'Annual Salary' FROM employees;
    • B、SELECT ename, salary*12 "Annual Salary" FROM employees;
    • C、SELECT ename, salary*12 AS Annual Salary FROM employees;
    • D、SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees

    正确答案:B

  • 第6题：

    Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? （）

    • A、SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);
    • B、SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
    • C、SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
    • D、SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
    • E、SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
    • F、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));

    正确答案:C,D,E

  • 第7题：

    单选题
    Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER SALARY NUMBER What is the correct syntax for an inline view?（）
    A

    SELECT a.last_name, a.salary, a.department_id,

    B

    maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary < b.maxsal;

    C

    SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))

    D

    SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);

    E

    SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id);


    正确答案： C
    解析： 暂无解析

  • 第8题：

    多选题
    Examine the data in the EMPLOYEES table: Which three subqueries work? （）
    A

    SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);

    B

    SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    C

    SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    D

    SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);

    E

    SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);

    F

    SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));


    正确答案： D,E
    解析： 暂无解析

  • 第9题：

    单选题
    Given the following stored procedure:CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6), OUT p_sum DECIMAL(9,2) ) SET p_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept);How can this stored procedure be called from the Command Line Processor?（）
    A

    CALL increase_salary('A00')

    B

    VALUES increase_salary('A00')

    C

    CALL increase_salary('A00', ?)

    D

    VALUES increase_salary('A00', ?)


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    Examine the structures of the EMPLOYEES and TAX tables. EMPLOYEES EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT _ID column of the DEPARTMENT table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER Percentage tax for given salary range You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）
    A

    SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salary

    B

    SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent

    C

    SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary

    D

    You cannot find the information because there is no common column between the two tables.


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?（）
    A

    ORDER BY SALARY > 5000

    B

    GROUP BY SALARY > 5000

    C

    HAVING SALARY > 5000

    D

    WHERE SALARY > 5000


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    下面哪条语句可以取出薪水最高的前三个人：（）
    A

    SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ）；

    B

    SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ） WHERE ROWNUM<=3；

    C

    SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY DESC） WHERE ROWNUM<=3；

    D

    SELECT * FROM EMPLOYEES WHERE ROWNUM<=3 ORDER BY SALARY DESC；


    正确答案： C
    解析： 暂无解析

  • 第13题：

    删除视图salary的命令是 A) DROP salary VIEW B）DROP VIEW salary C）DELETE salary VIEW D）DELETE salary


    正确答案：B
    本题考查SQL中删除视图的命令．删除视图的命令格式为：
    　　DROP VIEW <视图名>
    　　故选项B为正确答案。

  • 第14题：

    删除视图salary的命令是

    A．DROP salary VIEW

    B．DROP VIEW salary

    C．DELETE salary VIEW

    D．DELETE salary


    正确答案：B

  • 第15题：

    SELECT语句中使用（）子句来显示工资超过5000的员工。

    • A、ORDER BY SALARY>5000
    • B、GROUP BY SALARY>5000
    • C、HAVING SALARY>5000
    • D、WHERE SALARY>5000

    正确答案:D

  • 第16题：

    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;

    正确答案:D

  • 第17题：

    Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work?（）

    • A、SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);
    • B、SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);
    • C、SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);
    • D、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);
    • E、SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);
    • F、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

    正确答案:C,D,E

  • 第18题：

    单选题
    类Teacher：  class Teacher{   String name；   float salary；   Teacher（String name）{   this.name = name；  }   Teacher（String name，float salary）{   this.name = name；   this.salary = salary；  }  }   执行语句Teacher t = new Teacher（“Tom”，2000.0f）；后，字段salary的值是哪一项？（）
    A

     2000.0f

    B

     0.0f

    C

     null；

    D

     2000


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    Jerry, Will, and AI all work at the same company. Jerry earns 80% of Will's salary, and Will earns 75% of Al's salary. What percent of Al's salary is equal to Jerry's salary?
    A

    80%

    B

    75%

    C

    70%

    D

    65%

    E

    60%


    正确答案： B
    解析：
    J = 0.8W and W = 0.75A. Substitute 0. 75A for W. J = 0.8 × 0.75A = 0.6A. Therefore, 60% of Al's salary is equal to Jerry's salary.

  • 第20题：

    单选题
    您在公司的数据库中成功创建了名为SALARY的表。您现在要通过向引用EMPLOYEES表的匹配列的SALARY表添加FOREIGNKEY约束条件来建立EMPLOYEES表与SALARY表之间的父/子关系。尚未向SALARY表添加任何数据。应执行以下哪条语句（）
    A

    ALTER TABLE salary ADD CONSTRAINT fk_employee_id_01 FOREIGN KEY（employee_id）REFERENCES employees（employee_id）

    B

    ALTER TABLE salary ADD CONSTRAINT fk_employee_id_ FOREIGN KEY BETWEEN salary（employee_id）AND employees（employee_id）

    C

    ALTER TABLE salary FOREIGN KEY CONSTRAINT fk_employee_id_REFERENCES employees（employee_id）

    D

    ALTER TABLE salary ADD CONSTRAINT fk_employee_id_FOREIGN KEY salary（employee_id）=employees（employee_id）


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    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;


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）
    A

    SELECT ename, salary*12 'Annual Salary' FROM employees;

    B

    SELECT ename, salary*12 Annual Salary FROM employees;

    C

    SELECT ename, salary*12 AS Annual Salary FROM employees;

    D

    SELECT ename, salary*12 AS INITCAP(ANNUAL SALARY) FROM employees


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    删除视图salary的命令是（　　）。
    A

    DROP VIEW salary

    B

    DROP salary VIEW

    C

    DELECT salary

    D

    DELECT salary VIEW


    正确答案： A
    解析：
    SQL语句中，删除视图的格式为：DROP VIEW<视图名>。

相关内容