网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
3．In China，the________ is behind________
A． first name ;last name
B． last name; family name
C． family name; first name
D． last name; first name
参考答案
更多 “ 3．In China，the________ is behind________A． first name ;last nameB． last name; family nameC． family name; first nameD． last name; first name ” 相关考题
考题
AHis name is Ken Jordan． His first name is Ken． His family name is Jordam His phone number is 303-6574． This is his basketball． What's that? It's a notebook．It isn't his notebook． It-s Eli-s notebook． '( )21． His last name is________A．KenB．JordanC． Ken JordanD． Eli
考题
What are the components of Chinese names?
A、Given name and middle namesB、Family nameC、Family name and given nameD、Last name and surname
考题
It's very interesting to study names of different countries.Chinese names are different (1) foreign names.Once an English lady came to visit me.When I was introduced to her she said, “ Glad to meet you, Miss Ping.” Then she gave me her name card with three words on it:"Betty J.Black.So I said, “Thank you, Miss Betty.” We looked at each other and laughed heartily.Later I found that the English people (2)their family names last and the given names first, while their middle names are not used very much.I explained to her that the Chinese family name comes first, the given name last, so she(3) never call me Miss Ping.She asked if we Chinese had a middle name.I told her we didn't.but people may often find three wordson a Chinese name card.In this case the family name still come first, and the other words after it(4)a two-word given name.it is quite usual in China.My sister is Li Xiaofang.She has two words in her given name instead (5) just one like mine.(完型填空)A.PutB.FromC.ShouldD.ofE.are
考题
Examine the structure of the EMPLOYEES table:Column name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyLAST_NAME VARCNAR2(30)FIRST_NAME VARCNAR2(30)JOB_ID NUMBERSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBERYou 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);
考题
YouneedtogeneratealistofallcustomerlastnameswiththeircreditlimitsfromtheCUSTOMERStable.Thosecustomerswhodonothaveacreditlimitshouldappearlastinthelist.Whichtwoquerieswouldachievetherequiredresult?()
A.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitDESCB.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitC.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitNULLSLASTD.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_last_name,cust_credit_limitNULLSLAST
考题
下面哪些句子可以表示"您贵姓?"()
A、What's your last name?B、What's your family name?C、What's your name?D、What's your first name?
考题
在SQL Server 2000中，现要在employees表的first_name和last_name列上建立一个唯一的非聚集复合索引，其中first_name列数据的重复率是5%，last_name列数据的重复率是10%。请补全下列语句使以first_name和last_name列作为条件的查询效率最高。CREATE UNIQUE NONCLUSTERED INDEX Idx_NameON employees(______)
考题
Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age >40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?（）A.SORT BY age ASC, last_nameB.SORT BY age DESC, last_nameC.ORDER BY age DESC, last_nameD.ORDER BY age ASC, last_name
考题
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 nameBtitle+titleCtitle aloneDfirst name+last name+title
考题
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 nameB、title+titleC、title aloneD、first name+last name+title
考题
您要对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）
考题
证件上同时出现“Name”、“Full name”和“First name”，且无护照资料页下方的机读码可供参照的，则（）。A、“Name”或“Full name”为其姓，“First name”为名B、“Name”或“Full name”为其名，“First name”为姓C、全输入英文姓中D、全输入英文名中
考题
下面的文件正确吗？为什么？用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＞
考题
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');
考题
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',");
考题
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’,‘’);
考题
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%'
考题
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);
考题
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
考题
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;
考题
单选题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 nameB
title+titleC
title aloneD
first name+last name+title
考题
单选题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 = 'Smoth' WHERE employee_id = 180;C
UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;D
UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;
考题
单选题评估EMPLOYEE表的结构： EMPLOYEE_IDNUMBER（9） LAST_NAMEVARCHAR2（25） FIRST_NAMEVARCHAR2（25） DEPARTMENT_IDNUMBER（9） MANAGER_IDNUMBER（9） SALARYNUMBER（7，2） 您使用以下哪条语句可将LAST_NAME列（当前包含200条记录）的长度增加到35个字节（）A
ALTER employee TABLEAL TERCOLUMN（last_name VARCHAR2（35））B
ALTER TABLE employee RENAME last_name VARCHAR2（35）C
ALTER TABLE employee MODIFY（last_name VARCHAR2（35））D
不能增大LAST_NAME列的宽度
考题
单选题“雇员”表在LAST_NAME列上有一个名为LN_IDX的索引。您要将此索引更改为FIRST_NAME列的索引。以下哪条SQL语句将实现此操作（）A
ALTER INDEX ln_idx ON employees（first_name）B
ALTER INDEX ln_idx TO employees（first_name）C
ALTER INDEX ln_idx TO fn_idx ON employees（first_name）D
以上都不能；您无法变更索引
考题
多选题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? （）AINSERT INTO employees VALUES (NULL, 'JOHN','Smith');BINSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');CINSERT INTO employees VALUES ('1000','JOHN','NULL');DINSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');EINSERT INTO employees (employee_id) VALUES (1000);FINSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',);
热门标签
最新试卷