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列(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)
在执行语句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没有指定是哪个表
3．In China，the________ is behind________A． first name ;last nameB． last name; family nameC． family name; first nameD． last name; first name
You’re going to have a quiz ( )by another two in the ( )month. A. followed,followedB. followed,followingC. following,followedD. following,following
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);
已知下列员工关系表。Employees对该表的工资属性和完整性约束为：2000≤工资≤5000 现将如下2个操作组织为事务T，操作1先执行，操作2后执行。 操作1：INSERT INTO Employees VALUES(‘03650’，‘研发’，‘4600’) 操作2：UPDATE Employees SET工资=工资1.2 WHERE部门=‘市场OR部门=研发’事务T执行完毕后，关系表Employees．的数据是
YouneedtoimportalldefinitionsofobjectsbelongingtotheTS_EMPLOYEEStablespacebyusingtheexportfileexpdat.dmp.Whichimportstatementiscorrect?() A.imphr/hrTABLES=（ts_employees）rows=yB.impsystem/managerFROMUSER=hrfile=expdat.dmpC.imphr/hrTRANSPORT_TABLESPACE=yfile=expdat.dmpD.impsystem/managerTRANSPORT_TABLESPACE=yTABLESPACE=ts_employees
查询“选课表”中成绩大于或等于90分的选课记录，使用SQL命令（)。A．INSERT * FROM 选课表 WHERE 成绩＞=90B．UPDATE * FROM 选课表 WHERE 成绩＞=90C．DELETE * FROM 选课表 WHERE 成绩＞=90D．SELECT * FROM 选课表 WHERE 成绩＞=90
如果存在一张表格表示员工信息 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
查询“选课表”中成绩大于或等于90分的选课记录，使用SQL命令（）A．INSERT * FROM 选课表 WHERE 成绩＞=90B．UPDATE * FROM 选课表 WHERE 成绩＞=90C．DELETE * FROM 选课表 WHERE 成绩＞=90D．SELECT * FROM 选课表 WHERE 成绩＞=90