A13
B11
C17
D15
第1题:
A. It’s true. Our bank consists of many departments.
B. Thank you, our bank is a small one.
C. You are kidding! Our bank is a small one.
第2题:
Examine the data in the EMPLOYEES and DEPARTMENTS tables:Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:On the EMPLOYEES table, EMPLOYEE_ID is the primary key.MGR_ID is the ID of managers and refers to the EMPLOYEE_ID.DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table.On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.Examine this DELETE statement:What happens when you execute the DELETE statement?()
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.
第3题:
A.today of designers
B.today’s designers
C.today’s of designers
D.today designers
第4题:
Which is one of the largest government departments that deal with education?
It is the Ministry of Education.
略
第5题:
[A] alike [B] alone [C] altogether [D] apart
第6题:
A、Wholly
B、Entirely
C、Completely
D、Altogether
第7题:
A.var today;today=new Date( );
document.write("今天是"+today.getYear( )+"年"
+(today.getMonth( )+1)+"月"+today.getDay( )+"日");
B.var today; today=new Date( );
document.write("今天是"+today.getFullYear( )+"年"
+(today.getMonth( )+1)+"月"+today.getDay( )+"日");
C.var today;
Today=new Day( );
document.write("今天是"+today.getFullYear( )+"年"
+(today.getMonth( )+1)+"月"+today.getDate( )+"日");
D.var today;
today=new Date( );
document.write("今天是"+today.getFullYear( )+"年"
+(today.getMonth( )+1)+"月"+today.getDate( )+"日");
第8题:
A.没有给表employees和表departments加别名
B.没有给列department_id加别名
C.不能用employees.department_id=departments.department_id作为条件
D.SELECT后面的department_id没有指定是哪个表
第9题:
第10题:
What day is it today?()
AIt's March
BIt's a fine day today.
CIt's March today.
DIt's Monday.