Examine the structure of the EMPLOYEES table:You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:Which UPDATE statement meets the requirements?（）A.B.C.D.E.

题目

Examine the structure of the EMPLOYEES table:You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:Which UPDATE statement meets the requirements?（）

A.

B.

C.

D.

E.

相似考题

1.现有如下两个关系模式：Employees(Eid，Name，DeptNO)Departments(DeptNO，DeptName，TotalNumber)Employees关系模式描述了职工编号、姓名和所在部门编号；Departments关系模式描述了部门编号、名称和职工总人数。请按SQL Server所采用的’rransact—SQL语法格式编写实现具有如下功能的后触发型触发器：每当在Employees表中插入一行数据时，相应部门的职工总人数就加1。

2.I have never worked for such a considerate________; I think all the other________ have the same opinion.A.employee...employerB.employee...employersC.employer...employeeD.employer...employees

3.Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? ()A. An error is generated.B. You will have two identical tables in the HR schema with different names.C. You create a table called employees in the HR schema based on you EMP table.D. You create an alternative name for the employees table in the HR schema in your own schema.

4.（ 2 ）现有如下两个关系模式：Employees （ Eid ， Name ， DeptNO ）Departments （ DeptNO ， DeptName ， TotalNumber ）Employees 关系模式描述了职工编号、姓名和所在部门编号； Departments 关系模式描述了部门编号、名称和职工总人数。请 按 SQL Serve r 所采用 的 Tansact — SQ L 语法格式编写实现具有功能的后触发型触发器 ： 每当在Employee s表中插入一行数据时，相应部门的职工总人数就加 1 。（ 10 分）

更多“Examine the structure of the EMPLOYEES table:You need to update the records of employees 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. MERGE

    B. INSERT

    C. UPDATE

    D. ADD

    E. ENTER

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


    参考答案：C

  • 第2题：

    YouneedtoimportalldefinitionsofobjectsbelongingtotheTS_EMPLOYEEStablespacebyusingtheexportfileexpdat.dmp.Whichimportstatementiscorrect?()

    A.imphr/hrTABLES=（ts_employees）rows=y

    B.impsystem/managerFROMUSER=hrfile=expdat.dmp

    C.imphr/hrTRANSPORT_TABLESPACE=yfile=expdat.dmp

    D.impsystem/managerTRANSPORT_TABLESPACE=yTABLESPACE=ts_employees


    参考答案：C

  • 第3题：

    Wal-Mart has been criticized by some groups for its .（ ）

    [A] low service quality

    [B] employees' low salary

    [C] high pressure on the other companies

    [D] discrimination against women


    正确答案：D

  • 第4题：

    已知下列员工关系表。Employees对该表的工资属性和完整性约束为：2000≤工资≤5000 现将如下2个操作组织为事务T，操作1先执行，操作2后执行。 操作1：INSERT INTO Employees VALUES(‘03650’，‘研发’，‘4600’) 操作2：UPDATE Employees SET工资=工资1.2 WHERE部门=‘市场OR部门=研发’事务T执行完毕后，关系表Employees．的数据是


    正确答案：B
    B 解析：事务中的操作，要么都成功，要么都失败。在数据更新时，将工资乘以1.2，4600*1.2=5520>5000，不满足完整性约束，显然操作2在针对(“03560”，“研发”，4600) 时会失败，则整个操作全部失败，数据将不会修改，故选B。

  • 第5题：

    TheCiscoSA500SeriesSecurityAppliancesarebuiltspecificallyforbusinesseswithlessthan100employees.Whatarethreeimportantbenefitsofthisdevice?()

    A.site-to-siteVPNforremoteoffices

    B.business-gradefirewall

    C.CiscoIOSsoftware-based

    D.emailsecurity

    E.XMLsupport

    F.premiumsupportviaSMARTnet


    参考答案：A, B, D

  • 第6题：

    用所给的词和词组写出符合逻辑的句子。 a number of/have been/smoking/received from/requests/employees/in offices/asking that/be banned
    A number of requests have been received from employees asking that smoking be banned in offices.
    略

相关内容