3．In China，the________ is behind________A． first name ;last nameB． last name; family nameC． family name; first nameD． last name; first name

第1题：

第2题：

第3题：

第4题：

The way in which people address each other depends on their age, sex, social group and personal relationship. The English system of address forms frequently used includes first name, last name, title+last name, （）, and kin term.

• A、title+first name
• B、title+title
• C、title alone
• D、first name+last name+title

第5题：

证件上同时出现“Name”、“Full name”和“First name”，且无护照资料页下方的机读码可供参照的，则（）。

• A、“Name”或“Full name”为其姓，“First name”为名
• B、“Name”或“Full name”为其名，“First name”为姓
• C、全输入英文姓中
• D、全输入英文名中

第6题：

在网管上创建新账户需添加哪些基本信息（）

• A、Login name
• B、Password
• C、First name
• D、Last name

第7题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? （）

• A、INSERT INTO employees VALUES (NULL, 'JOHN','Smith');
• B、INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');
• C、INSERT INTO employees VALUES ('1000','JOHN','NULL');
• D、INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');
• E、INSERT INTO employees (employee_id) VALUES (1000);
• F、INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");

第8题：

You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? （）

• A、SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
• B、SELECT last_name FROM EMP WHERE last name ='*A%'
• C、SELECT last_name FROM EMP WHERE last name ='_A%';
• D、SELECT last_name FROM EMP WHERE last name LIKE '*A%'

第9题：

Review the definition of the phone_list view. CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= 'root'@localhost' SQL SECURITY DEFINER VIEW 'phone_list' AS SELECT e . id as id 'e . first_name AS 'first_name' 'e . last_name AS 'last_name' 'coalesce ( ph1.phone_no, ' – ') AS 'office_no' 'coalesce (ph2 .phone_no, ' – ') AS 'cell_no' FROM employees e LEFT JOIN employee_phone ph1 ON ph1.emp_id = e.id AND ph1.type = 'office' LEFT JOIN employee_phone ph2 ON ph2 .emp_id = e.id AND ph2 .type = 'mobile' The tables employees and employee_phone are InnoDB tables; all columns are used in this view. The contents of the phone_list view are as follows: Mysql> select * from phone_list; 1 row in set (0.00 sec) Which method can you use to change the cell_no value to '555-8888' for John Doe?（）

• A、INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, '555-8888','mobile')
• B、UPDATE phone_list SET cell_name '555-8888' WHERE first_name= 'John' and last_name= 'Doe'
• C、DELETE FROM phone_list WHERE first_name= 'John' and last_name= 'Doe'; INSERT INTO phone_list (first_name, last_name, office_no, cell_no) VALUES ('John' , 'Doe' , 'x1234' , '555-8888)
• D、UPDATE employee_phone SET phone_no= '555-8888' where emp_id=1

第10题：

第11题：

第12题：

第13题：

第14题：

第15题：

The way in which people address each other depends on their age, sex, social group and personal relationship. The English system of address forms frequently used includes first name, last name, title+last name, （）, and kin term.

Atitle+first name

Btitle+title

Ctitle alone

Dfirst name+last name+title

第16题：

您要对EMPLOYEES表的FIRST_NAME和LAST_NAME列创建一个组合索引。以下哪条语句将完成此任务（）

• A、CREATE INDEXfl_idx ON employees（first_name last_name）
• B、CREATE INDEXfl_idx ON employees（first_name），employees（last_name）
• C、CREATE INDEXfl_idx ON employees（first_name，last_name）
• D、CREATE INDEXfl_idx ON employees（first_name）；CREATE INDEXfl_idx ON employees（last_name）

第17题：

下面的文件正确吗？为什么？用IE和本章中的解析器验证你的结论。 mes.dtd ＜!ELEMENT message ANY＞ ＜!ELEMENT persion (name,age?,lxfs)＞ ＜!ELEMENT lxfs (#PCDATA,tel|email)*＞ ＜!ELEMENT name (first,last)＞ ＜!ATTLIST name sex (male|female) "male"＞ ＜!ELEMENT first %pc; ＞ ＜!ELEMENT last %pc;＞ ＜!ELEMENT age %pc;＞ ＜!ELEMENT tel %pc;＞ ＜!ELEMENT email %pc;＞ ＜!ENTITY % pc “(#PCDATA)”＞ ＜!ELEMENT emergency EMPTY＞ ＜!ATTLIST emergency fire CDATA #FIXED "119" police CDATA #FIXED "110" hospital CDATA #FIXED "120" ＞ mes.xml ＜?xml version="1.0" encoding="gb2312"?＞ ＜!DOCTYPE SYSTEM "mes.dtd"＞ ＜message＞ ＜persion＞ ＜name sex="男"＞ ＜first＞li＜/first＞ ＜last＞xiao＜/last＞ ＜/name＞ ＜age＞25＜/age＞ ＜lxfs＞ ＜tel＞123456＜/tel＞ ＜/lxfs＞ ＜/persion＞ ＜persion＞ ＜name＞ ＜first＞wang＜/first＞ ＜last＞xiao＜/last＞ ＜/name＞ ＜lxfs＞＜/lxfs＞ ＜/persion＞ ＜emergency fire="120" police="110" /＞ ＜/message＞

第18题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which INSERT statement is valid?（）

• A、INSERT INTO employees (employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01/01/01);
• B、INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01 january 01');
• C、INSERT INTO employees(employee_id, first_name, last_name, Hire_date) VALUES (1000, 'John', 'smith', To_ date ('01/01/01));
• D、INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01-Jan-01');

第19题：

Which three statements inserts a row into the table?（）

• A、INSERT INTO employees   VALUES ( NULL, ‘John’,‘Smith’);
• B、INSERT INTO employees( first_name, last_name)   VALUES(‘John’,‘Smith’);
• C、INSERT INTO employees   VALUES (‘1000’,‘John’,NULL);
• D、INSERT INTO employees(first_name,last_name, employee_id)   VALUES ( 1000, ‘John’,‘Smith’);
• E、INSERT INTO employees (employee_id)   VALUES (1000);
• F、INSERT INTO employees (employee_id, first_name, last_name)   VALUES ( 1000, ‘John’,‘’);

第20题：

Examine the structure of the EMPLOYEES table: Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key LAST_NAME VARCNAR2(30) FIRST_NAME VARCNAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task? （）

• A、CREATE INDEX NAME _IDX (first_name, last_name);
• B、CREATE INDEX NAME _IDX (first_name, AND last_name)
• C、CREATE INDEX NAME_IDX ON (First_name, last_name);
• D、CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);
• E、CREATE INDEX NAME_IDX ON employees (First_name, last_name);
• F、CREATE INDEX NAME_IDX FOR employees (First_name, last_name);

第21题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which UPDATE statement is valid?（）

• A、UPDATE employees SET first_name = 'John' SET last_name ='Smith' WHERE employee_id = 180;
• B、UPDATE employees SET first_name = 'John', SET last_name ='Smith' WHERE employee_id = 180;
• C、UPDATE employees SET first_name = 'John' AND last_name ='Smith' WHERE employee_id = 180;
• D、UPDATE employees SET first_name = 'John', last_name ='Smith' WHERE employee_id = 180;

第22题：

第23题：