EMPLOYEE | |||||||||||||||||||||||||||||||
EMPLOYEE_ID | NUMBER | NOT NULL, Primary Key | |||||||||||||||||||||||||||||
EMP_LNAME | VARCHAR2(25) | ||||||||||||||||||||||||||||||
EMP_FNAME | VARCHAR2(25) | ||||||||||||||||||||||||||||||
DEPT_ID | NUMBER | Foreign key to DEPT ID column of the DEPARTMENT table | |||||||||||||||||||||||||||||
JOB_ID | NUMBER | Foreign key to JOB ID column of the JOB tableA. CREATE INDEX employee(emp_lname);
B. CREATE INDEX employee(emp_lname) employee_emp_lname_idx; C. CREATE INDEX employee_emp_lname_idx D. CREATE INDEX employeeemp_lname_idx [填空题]A CONDENSED EMPLOYEE LIFE CYCLE
An employee life cycle is the steps the employees go through from the time they enter a company until they leave. Often Human Resources professionals focus their attention on the steps in this process in hopes of making an impact on the company’s bottom line. That is a good thing for them to do. Their goal is to reduce the company’s cost per employee hired. Employees are one of a company’s largest expenses these days. Unlike other major capital costs (buildings, machinery, technology, etc.) human capital is highly volatile. You, as a manager, are in a key position to reduce that volatility using the condensed employee life cycle of HIAR ( pronounced hire)--Hire, Inspire, Admire, Retire. Hire: This first step is probably the most important. It is important to hire the best people you can find. (8) The cost of replacing a bad hire far exceeds the marginal additional cost of hiring the best person in the first place. Inspire: Once [单项选择]Samuel was obliged to compromise on lesser questions.（）
A. was compelled B. was delighted C. was prepared D. was only too ready [单项选择]These graduates are more than obliged to the college for the happy four years of college life.（ ）
A. obligatory B. reluctant C. indifferent D. grateful [单项选择]请看如下的创建employee表的DDL语句：
CREATE TABLE employee (employee_id VARCHAR2 PRIMARY KEY); 基于这个DDL语句，在以下有关employee表的陈述中，哪一个是正确的 A. employee表将使用本地管理的区段 B. 数据将存储在基于主键值的表中 C. employee表中的所有数据必须存放在一个表空间中 D. 直到向employee表插入数据之前，Oracle不会为这个表分配区段 [单项选择]The Seller is obliged to provide the Buyer with all spare parts necessary for operation of the equipment.
A. 卖方被强迫提供给买方操作设备时需要的全部部分。 B. 卖方有责任向买方提供为了操作设备需要用到的全部闲散部分。 C. 卖方有义务向买方提供操作设备时所需的全部零件。 D. 卖方有义务提供给买方操纵设备的全部零件。 [填空题]We are obliged to thank you for your kind attention in this matter．
[单项选择]以下是EMPLOYEE表的详细定义，其中也包括了约束的描述。
| |||||||||||||||||||||||||||||
