The EMPLOYEE table contains the following information: EMPNO NAME WORKDEPT 101 SAM A11 102 JOHN C12 103 JANE -104 PAT Remote 105 ANNE -106 BOB A11 The MANAGER table contains the following information: MGRID NAME DEPTNO EMPCOUNT 1 WU B01 - 2 JONES A11 - 3

题目

The EMPLOYEE table contains the following information: EMPNO NAME WORKDEPT 101 SAM A11 102 JOHN C12 103 JANE -104 PAT Remote 105 ANNE -106 BOB A11 The MANAGER table contains the following information: MGRID NAME DEPTNO EMPCOUNT 1 WU B01 - 2 JONES A11 - 3 CHEN - - 4 SMITH - -5 THOMAS C12 - After this statement is executed: UPDATE manager m SET empcount = (SELECT COUNT(workdept) FROM employee e WHERE workdept=m.deptno) What is the result of the following query?（） SELECT mgrid, empcount FROM MANAGER WHERE empcount IS NOT NULL ORDER BY mgrid

  • A、MGRID EMPCOUNT ----- -------- 1 0 2 2 5 1
  • B、MGRID EMPCOUNT ----- -------- 1 0 2 2 3 0 4 0 5 1
  • C、MGRID EMPCOUNT ----- -------- 1 3 2 3 3 3 4 3 5 3
  • D、MGRID EMPCOUNT ----- -------- 1 0 2 2 3 2 4 2 5 1
相似考题

1.You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? （）A. MERGEB. INSERTC. UPDATED. ADDE. ENTERF. You cannot enter the phone numbers for the existing employee records.

2.Examine the data in the EMPLOYEES table.On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column.Evaluate this DELETE statement:Why does the DELETE statement fail when you execute it?（）A. There is no row with dept_id 90 in the EMPLOYEES table.B. You cannot delete the JOB_ID column because it is a NOT NULL column.C. You cannot specify column names in the DELETE clause of the DELETE statement.D. You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.

3.Examine the data in the EMPLOYEES and EMP_HIST tables:The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID, and salary of each existing employee are modified with the latest data. New employee details are added to the table.Which statement accomplishes this task?（）A.B.C.D.

4.Examine the data from the EMP table:The COMMISSION column shows the monthly commission earned by the employee.Which three tasks would require subqueries or joins in order to perform in a single step?（）A. Deleting the records of employees who do not earn commission.B. Increasing the commission of employee 3 by the average commission earned in department 20.C. Finding the number of employees who do NOT earn commission and are working for department 20.D. Inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3.E. Creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table.F. Decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800.

参考答案和解析
正确答案:B
更多“The EMPLOYEE table contains the”相关问题

  • 第1题：

    Examine the data of the EMPLOYEES table.EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee‘s manager, for all the employees who have a manager and earn more than 4000?（）

    A.

    B.

    C.

    D.

    E.


    参考答案：C

  • 第2题：

    Which statement is correct about the forwarding table?()

    A. The forwarding table is stored only on the PFE

    B. The forwarding table contains all known routes

    C. The forwarding table is stored on both the RE and PFE

    D. The forwarding table is stored only on the RE


    参考答案：C

  • 第3题：

    Click the Exhibit button and examine the data in the EMPLOYEES table.On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column.Evaluate this DELETE statement:DELETE employee_id, salary, job_idFROM employeesWHERE dept_id = 90;Why does the DELETE statement fail when you execute it?（）

    A.There is no row with dept_id 90 in the EMPLOYEES table.

    B.You cannot delete the JOB_ID column because it is a NOT NULL column.

    C.You cannot specify column names in the DELETE clause of the DELETE statement.

    D.You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.


    参考答案：C

  • 第4题：

    You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）

    • A、MERGE
    • B、INSERT
    • C、UPDATE
    • D、ADD
    • E、ENTER
    • F、You cannot enter the phone numbers for the existing employee records.

    正确答案:C

  • 第5题：

    Which statement is true about the routing table?（）

    • A、The routing table exists in the control plane only
    • B、The routing table exists in the control plane and the forwarding plane
    • C、The routing table contains both active and inactive routes
    • D、The routing table is stored on compact flash

    正确答案:A

  • 第6题：

    Which statement is correct about the forwarding table?（）

    • A、The forwarding table is stored only on the PFE
    • B、The forwarding table contains all known routes
    • C、The forwarding table is stored on both the RE and PFE
    • D、The forwarding table is stored only on the RE

    正确答案:C

  • 第7题：

    Examine the data in the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA*DIR 6500 DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME 10 Admin 20 Education 30 IT 40 Human Resources Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables: CREATE TABLE departments (department_id NUMBER PRIMARY KEY, department _ name VARCHAR2(30)); CREATE TABLE employees (EMPLOYEE_ID NUMBER PRIMARY KEY, EMP_NAME VARCHAR2(20), DEPT_ID NUMBER REFERENCES departments(department_id), MGR_ID NUMBER REFERENCES employees(employee id), MGR_ID NUMBER REFERENCES employees(employee id), JOB_ID VARCHAR2(15). SALARY NUMBER); ON the EMPLOYEES, On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key. Examine this DELETE statement: DELETE FROM departments WHERE department id = 40; What happens when you execute the DELETE statement?（）

    • A、Only the row with department ID 40 is deleted in the DEPARTMENTS table.
    • B、The statement fails because there are child records in the EMPLOYEES table with department ID 40.
    • C、The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.
    • D、The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.
    • E、The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.
    • F、The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.

    正确答案:B

  • 第8题：

    单选题
    The EMP table contains these columns: EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR2 (25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this SQL statement: SELECT empname,hire_date HIREDATE, salary FROM EMP ORDER BY hire_date; How will the results be sorted?（）
    A

    randomly

    B

    ascending by date

    C

    descending by date

    D

    ascending alphabetically

    E

    descending alphabetically


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

  • 第9题：

    单选题
    您在公司的数据库中成功创建了名为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
    解析： 暂无解析

  • 第10题：

    单选题
    You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this.  Which data type would you use for the new column（）
    A

    CLOB

    B

    BLOB

    C

    BFILE

    D

    LONG RAW


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

  • 第11题：

    单选题
    You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）
    A

    MERGE

    B

    INSERT

    C

    UPDATE

    D

    ADD

    E

    ENTER

    F

    You cannot enter the phone numbers for the existing employee records.


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

  • 第12题：

    单选题
    评估EMPLOYEE表的结构： EMPLOYEE_IDNUMBER（9） LAST_NAMEVARCHAR2（25） FIRST_NAMEVARCHAR2（25） DEPARTMENT_IDNUMBER（9） MANAGER_IDNUMBER（9） SALARYNUMBER（7，2） EMPLOYEE_ID列当前包含500个雇员标识号。业务需求已发生变化，您需要允许用户在标识值中包含文本字符。应该使用哪条语句来更改该列的数据类型（）
    A

    ALTER TABLE employee MODIFY（employee_id VARCHAR2（9））

    B

    ALTER TABLE employee REPLACE（employee_id VARCHAR2（9））

    C

    ALTER employee TABLEMODIFY COLUMN（employee_id VARCHAR2（15））

    D

    您不能修改EMPLOYEE_ID列的数据类型，因为该表不为空


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

  • 第13题：

    Examine the data in the EMPLOYEES and DEPARTMENTS tables:Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:On the EMPLOYEES table, EMPLOYEE_ID is the primary key.MGR_ID is the ID of managers and refers to the EMPLOYEE_ID.DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table.On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.Examine this DELETE statement:What happens when you execute the DELETE statement?（）

    A. Only the row with department ID 40 is deleted in the DEPARTMENTS table.

    B. The statement fails because there are child records in the EMPLOYEES table with department ID 40.

    C. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.

    D. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.

    E. The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.

    F. The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.


    参考答案：B

  • 第14题：

    Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?()

    A.REVOKE ALL PRIVILEGES FROM USER tom

    B.REVOKE ALL ON EMPLOYEE FROM USER tom

    C.REVOKE EXECUTE ON EMPLOYEE FROM USER tom

    D.REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom


    参考答案：B

  • 第15题：

    The EMP table contains these columns:EMPLOYEE_ID NUMBER(4)EMPNAME VARCHAR2 (25)SALARY NUMBER(9,2)HIRE_DATE DATEYou query the database with this SQL statement:SELECT empname,hire_date HIREDATE, salaryFROM EMPORDER BY hire_date;How will the results be sorted?（）

    A.randomly

    B.ascending by date

    C.descending by date

    D.ascending alphabetically

    E.descending alphabetically


    参考答案：B

  • 第16题：

    What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）

    • A、A check constraint on the EMPLOYEE table
    • B、A unique constraint on the EMPLOYEE table WORKDEPT column
    • C、A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
    • D、A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

    正确答案:D

  • 第17题：

    Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）

    • A、REVOKE ALL PRIVILEGES FROM USER tom
    • B、REVOKE ALL ON EMPLOYEE FROM USER tom
    • C、REVOKE EXECUTE ON EMPLOYEE FROM USER tom
    • D、REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom

    正确答案:B

  • 第18题：

    You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature？ （）

    • A、 RESETLOGS
    • B、 TO TIMESTAMP
    • C、 TO BEFORE DROP
    • D、 RENAME TO
    • E、 TO SCN

    正确答案:B,E

  • 第19题：

    The EMP table contains these columns: EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR2 (25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this SQL statement: SELECT empname,hire_date HIREDATE, salary FROM EMP ORDER BY hire_date; How will the results be sorted?（）

    • A、randomly
    • B、ascending by date
    • C、descending by date
    • D、ascending alphabetically
    • E、descending alphabetically

    正确答案:B

  • 第20题：

    单选题
    Which statement is true about the routing table?（）
    A

    The routing table exists in the control plane only

    B

    The routing table exists in the control plane and the forwarding plane

    C

    The routing table contains both active and inactive routes

    D

    The routing table is stored on compact flash


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

  • 第21题：

    单选题
    The EMP table contains these columns: EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR2 (25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this SQL statement: SELECT empname,hire_date HIREDATE, salary FROM EMP ORDER BY hire_date; How will the results be sorted?（）
    A

    randomly

    B

    ascending by date

    C

    descending by date

    D

    ascending alphabetically

    E

    descending alphabetically


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

  • 第22题：

    单选题
    The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）
    A

    ALTER TABLE employees monitor index employee_idx_fk; 

    B

    ALTER INDEX employee_idx_fk monitoring on; 

    C

    ALTER TABLE employees monitor all indexes; 

    D

    ALTER INDEX employee_idx_fk monitoring usage; 


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

  • 第23题：

    多选题
    You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature？ （）
    A

    RESETLOGS

    B

    TO TIMESTAMP

    C

    TO BEFORE DROP

    D

    RENAME TO

    E

    TO SCN


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

  • 第24题：

    单选题
    What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）
    A

    A check constraint on the EMPLOYEE table

    B

    A unique constraint on the EMPLOYEE table WORKDEPT column

    C

    A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table

    D

    A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table


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

相关内容