Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVELCLERK 3If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1()A.0B.1C.3D.6

题目
Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVELCLERK 3If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1()

A.0

B.1

C.3

D.6

相似考题

1.以下语句获取表中第1行第1列(FirstName列)的数据,其中正确的语句是()。A.myTable.Rows(0).Item("FirstName")B.myTable.Rows(1)("FirstName")C.myTable.Rows(0)(1)D.myTable.Rows(0).Item(0)E.myTable.Rows(0).Item(1)

2.3．In China，the________ is behind________A． first name ;last nameB． last name; family nameC． family name; first nameD． last name; first name

3.You’re going to have a quiz ( )by another two in the ( )month.A. followed,followedB. followed,followingC. following,followedD. following,following

4.在执行语句SELECT department_id FROM employees,departments WHERE employees.department_id= departments.department_id;时报错,原因是()。A.没有给表employees和表departments加别名B.没有给列department_id加别名C.不能用employees.department_id=departments.department_id作为条件D.SELECT后面的department_id没有指定是哪个表

更多“Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVELCLERK 3If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1() ”相关问题

  • 第1题：

    Examine the data in the EMPLOYEES and EMP_HIST tables:EMPLOYEESNAME DEPT_ID MGR_ID JOB_ID SALARYEMPLOYEE_ID101 Smith 20 120 SA_REP 4000102 Martin 10 105 CLERK 2500103 Chris 20 120 IT_ADMIN 4200104 John 30 108 HR_CLERK 2500105 Diana 30 108 IT_ADMIN 5000106 Smith 40 110 AD_ASST 3000108 Jennifer 30 110 HR_DIR 6500110 Bob 40 EX_DIR 8000120 Ravi 20 110 SA_DIR 6500EMP HISTEMPLOYEE_ID NAME JOB_ID SALARY101 Smith SA_CLERK 2000103 Chris IT_CLERK 2200104 John HR_CLERK 2000106 Smith AD_ASST 3000108 Jennifer HR_MGR 4500The 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. UPDATE emp_hist SET employee_id, name, job_id, salary = (SELECT employee_id, name, job_id, salary FROM employees) WHERE employee_id IN (SELECT employee_id FROM employees);

    B. MERGE INTO emp_hist eh USING employees e ON (eh.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT VALUES (e.employee id, e.name, job id, e.salary);

    C. MERGE INTO emp_hist eh USING employees e ON (eh.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE emp hist SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT INTO emp_hist VALUES (e.employees_id, e.name, e.job_id, e.salary);

    D. MERGE INTO emp_hist eh USING employees e WHEN MATCHED THEN UPDATE emp_hist SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT INTO emp_hist VALUES (e.employees_id, e.name, e.job_id, e.salary);


    参考答案：B

  • 第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题：

    如果存在一张表格表示员工信息 Employees（ID,Name,Gender,ReportsTo），其中 ReportsTo 为外码，用于表示该员工的直接上级领导，那么要查询出结果（ID,Name,LeaderName），SQL 是Select ID, Name, u.Name As LeaderName From Employees e JOIN Empoyees u ON e.ID = u.ReportsTo


    错误

  • 第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题：

    查询“选课表”中成绩大于或等于90分的选课记录，使用SQL命令（)。

    A．INSERT * FROM 选课表 WHERE 成绩＞=90

    B．UPDATE * FROM 选课表 WHERE 成绩＞=90

    C．DELETE * FROM 选课表 WHERE 成绩＞=90

    D．SELECT * FROM 选课表 WHERE 成绩＞=90


    D

  • 第6题：

    查询“选课表”中成绩大于或等于90分的选课记录，使用SQL命令（）

    A．INSERT * FROM 选课表 WHERE 成绩＞=90

    B．UPDATE * FROM 选课表 WHERE 成绩＞=90

    C．DELETE * FROM 选课表 WHERE 成绩＞=90

    D．SELECT * FROM 选课表 WHERE 成绩＞=90


    D

相关内容