A、select firstname+’.’+lastnameas’name’from employee
B、select firstname+’.’+lastname=’name’from employee
C、select’name’=firstname+’.’+lastnamefrom employee
D、select firstname，lastname from employee
更多“现有表Employee，字段：id（int）、firstname（varchar）、lastname（varchar）；以下sql语句错误的是（）”相关的问题
A、一个名为“employee”的SQL Server数据库，在其中创建一个存放员工基本情况的employee表（包括编号、姓名、性别、部门4个字段）和存放员工工资数据的pay表（包括编号、基本工资、职务工资、补贴、奖金、扣税6个字段），并向表中添加一些数据。 使用以上创建的Access数据库中的信息，写出实现下列要求的SQL语句。
A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees); B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees); C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey'); D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees); B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees); C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ('Carrey')' D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = ('Carrey')'
A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees); B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_employees); C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name ='Carrey'); D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_name ='Carrey');
A、A. DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees); B、B. DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees); C、C. DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ('Carrey')' D、D. DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = ('Carrey')'
A、创建一个从Employee表返回非秘密信息的存储过程，用XML来格式化。 B、创建一个从Employee表返回非秘密信息的用户自定义函数，用XML来格式化。 C、从employee表创建视图，仅包含非秘密的信息。给予它外部操作的权限来阻止视图的提交查询。 D、在Employee表上设置column-level权限来阻止外部操作查看秘密的字段。给予它外部操作的权限来阻止视图的提交查询。
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.
A、A. There is no row with dept_id 90 in the EMPLOYEES table. B、B. You cannot delete the JOB_ID column because it is a NOT NULL column. C、C. You cannot specify column names in the DELETE clause of the DELETE statement. D、D. You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.
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.
客服
TOP
查看正确答案
