[单项选择]For economy reasons, employees travelling to France will fly overnight to Paris rather than Cannes.Employees flying to France will

[单项选择] Examine the data in the EMPLOYEES table. EMPLOYEES EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith 40 110 AD.ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EK_DIR 8000 120 Revi 20 110 SA_DIR 6500 On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column. Evaluate this DELETE statement: DELETE employee_id, salary, job_id FROM employees WHERE dept_id = 90; Why does the DELETE statement fail when you execute it?（）
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.

[单项选择] Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID) EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 HR_MGR 5000 106 Bryan 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA_DIR 6500 Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000?（）
A. SELECT employee_id "Emp_id", emp_name "Employee", salary, employee_id "Mgr_id", emp_name "Manager" FROM employees WHERE salary > 4000;
B. SELECT e.employee_id "Emp_id", e.emp_name "Employee",
C. salary,
D. employee_id "Mgr_id", m.emp_name "Manager" FROM employees e, employees m WHERE e.mgr_id = m.mgr_id AND e.salary > 4000;

[单项选择] EMPLOYEES and DEPARTMENTS data: EMPLOYEES DEMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_I 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA_DIR 6500 DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME 10 Admin 20 Education 30 IT 40 Human Resources On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID managers and refers to the EMPLOYEE_ID. On the DEPARTMENTS table DEPARTMENT_ID is the primary key. Evaluate this UPDATE statement. UPDATE employees SET mgr_id = (SELECT mgr_id FROM employees WHERE dept_id= (SELECT department_id FROM departments WHERE department_name = 'Administration')), Salary = (SELECT salary FROM employees WHERE emp_name = 'Smith') WHERE job_id = 'IT_ADMIN'; What happens when the statement is executed?（）
A. The statement executes successfully, leaves the manager ID as the existing value, and changes the salary to 4000 for the employees with ID 103 and 105.
B. The statement executes successfully, changes the manager ID to NULL, and changes the salary to 4000 for the employees with ID 103 and 105.
C. The statement executes successfully, changes the manager ID to NULL, and changes the salary to 3000 for the employees with ID 103 and 105.
D. The statement fails because there is more than one row matching the employee name Smith.
E. The statement fails because there is more than one row matching the IT_ADMIN job ID in the EMPLOYEES table.
F. The statement fails because there is no 'Administration' department in the DEPARTMENTS table.

[单项选择]The German war plan for a rapid victory over France was based on the ______ that Germany could temporarily protect its eastern frontier against the much larger Russian forces.
A. gamble
B. galaxy
C. garment
D. giggle

[单项选择]Travelling companions are a disadvantage, according to the writer, because they ______.
A. give you the wrong impression about the journey
B. distract you from your reading
C. intrude on your private observations
D. prevent you from saying what you think

[单项选择]The knowledge one gains by travelling in a foreign country is often ______.
A. from second --hand information
B. gathered more from other sources than (from)its inhabitants
C. gained from the arguments about the country
D. different from what one had before the travel

[单项选择]When travelling, you are advised to take travellers' checks, which provide a secure ______ to carrying your money in cash.
A. substitute
B. selection
C. preference
D. alternative

[单项选择]Luxembourg lies________ Belgium, Germany and France.
A. among
B. within
C. between
D. inside

[单项选择]By travelling, reading and studying, the scholar devoted all his time to the ______ of knowledge.
A. acquisition
B. vocation
C. replacement
D. criterion

[单项选择]

It’ s not much , but it’ s home. Francis Chan, an engineer, lives in Hampstead, north London, in a flat that’s just 4ft wide by 21ft long. He loves it. Tiny though it is, it has got all the comforts. Peter Baynes, Chan’s architect (建筑师),has achieved a clever piece of design,according to architectural experts. The Chan mini-house was built on what was once a path down the side of a big Victarian house. Not an inch of space is wasted. When you step in through the front door, you’re standing in the shower, on Britain’ s only self-cleansing doormat (自动清洁门垫). A door opens on to an equally tiny toilet with washbasin. Two steps further in comes the kitchen, complete with full-sized cooker and fridge, and washer/ drier. A worktop folds down from the wall. Another step and you’re into the dining/ office area. Four people can sit here for dinner, says Chan as he sets the table-top into place. He even has a fold-down drawing-board for when he’
A. is cheap
B. has cheap furniture
C. has a simple design
D. is fairly small

[单项选择]John was fed up with travelling. All he wanted now was a wife, family, home and a ______ job.
A. safe
B. secure
C. certain
D. guaranteed

[单项选择]The modern people like travelling now because ______.
A. it can bring us more knowledge
B. it can make us rich
C. they have too much money
D. it is a good idea

[单项选择] Combien de cha nes de télévision y a-t-il en France
A. Quatre
B. Cinq
C. Trois
D. Six

[单项选择]The relationship between employers and employees has been studied ______.
A. originally
B. extremely
C. violently
D. intensively

[单项选择]已知下列员工关系表。Employees
A. 员工号
B. 部门
C. 工资
D. 04501
E. 财务
F. 3000
G. 05601
H. 市场
I. 4000
J. 03020
K. 研发
L. 3500