it was the name of the plant where the study was conducted
it was the name suggested by the Harvard researchers
it was the name of the principal experimenter
There were Hawthorne plants growing at Western Electric where the study was conducted.
第1题:
查找条件为:姓名不是NULL的记录( )
A.WHERE NAME ! NULL
B.WHERE NAME NOT NULL
C.WHERE NAME IS NOT NULL
D.WHERE NAME!=NULL
第2题:
哪些是正确的 like 运算表达式?
A.select * from net_46 where s_name like ’晓’
B.select * from net_46 where s_name like ’&晓&’
C.select * from net_46 where s_name like ’$晓$’
D.select * from net_46 where s_name like ’%晓%’
第3题:
A.select employeesno,ename Name,job from employees where ename=‘SMITH’
B.select employeesno,ename ‘Name’,job from employees where ename=SMITH
C.select employeesno,ename “Name”,job from employees where ename=‘SMITH’
D.select employeesno,ename ‘Name’,job frome mployees wheree name=‘SMITH’
第4题:
public class Plant { private String name; public Plant(String name) { this.name = name; } public String getName() { return name; } } public class Tree extends Plant { public void growFruit() { } public void dropLeaves() { } } Which is true?()
第5题:
第6题:
以下删除记录正确的( )
A.delete from emp where name='dony';
B.Delete * from emp where name='dony';
C.Drop from emp where name='dony';
D.Drop * from emp where name='dony';
第7题:
第8题:
●已知有关系模式R(S_NO,S_NAME,AGE),其中S-NO表示学生的学号,类型为Char[8],前4位表示入学年份。查询所有2005年入学的学生姓名(S_NAME),SQL语句是 (24) 。
(24) A.SELECT S_NAME FROM R WHERE S_NO=′2005%′
B.SELECT S_NAME FROM R WHERE S_NO LIKE ′2005%′
C.SELECT S_NAME FROM R WHERE S_NO=′2005%′
D.SELECT S_NAME FROM R WHERE S_NO ′2005%′
第9题:
下列哪个语句查出雇员表(employees)里的雇员名字(ename)是‘SMITH’的信息,并且给雇员名字(ename)列定义一个别名Name()。
第10题:
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?()