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
A
His 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．Ken
B．Jordan
C． Ken Jordan
D． Eli
相关考题：
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);
Review the definition of the phone_list view.CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= ‘root‘@localhost‘ SQL SECURITY DEFINER VIEW ‘phone_list‘ AS SELECTe . 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
Theaccountsreceivabledepartmentrequestedanaccountsstatustoallowuserstoentereitheracustomername,customernumber,customerphonenumberandthendisplaythecustomeroutstandingbalance.Youwanttorestrictthedataretrievedbasedonvaluesenteredbytheusers.Whichwhereclausewouldyouwriteinthequerytoselectstatementtoaccomplishthistask?（）A.p_where_clauseB.:p_where_clauseC.WHERECUST_ID=P_CUST_IDorcust_name=:p_cust_nameorcust_phone=:p_cust_phoneD.Wherecust_ID=p_custidcust_name=p_cust_nameorcust_phone=p_cust_phone
在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
姜华华客人的姓名正确录入方式为（）A．Last Name:Jiang; First:Huahua; Alt. Name:姜华华B．Last Name: 姜; First: 华华; Alt. Name: Jiang HuahuaC．Last Name:jiang; First:huahua; Alt. Name:姜华华D．Last Name: 姜; First: 华华; Alt. Name: jiang huahua
4、姜华华客人的姓名正确录入方式为（）A．Last Name:Jiang; First:Huahua; Alt. Name:姜华华B．Last Name: 姜; First: 华华; Alt. Name: Jiang HuahuaC．Last Name:jiang; First:huahua; Alt. Name:姜华华D．Last Name: 姜; First: 华华; Alt. Name: jiang huahua
88、姜华华客人的姓名正确录入方式为（）A．Last Name:Jiang; First:Huahua; Alt. Name:姜华华B．Last Name: 姜; First: 华华; Alt. Name: Jiang HuahuaC．Last Name:jiang; First:huahua; Alt. Name:姜华华D．Last Name: 姜; First: 华华; Alt. Name: jiang huahua
1.查询hr用户下的EMPLOYEES表，根据输入的first_name，查询拥有相同first_name的雇员信息。 （1）如果没有此first_name，应给出提示。 （2）如果只有1个first_name，应给出提示。 （3）如果有多个first_name相同用户，显示重名的总人数及他们的最高工资。