itgle.com

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 Jo

题目

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

相似考题

1.在HIS上出现”OFFSCALE”信息,表示:().A、地图超出HIS的显示范围B、TCAS超出HIS的显示范围C、气象雷达超出HIS的显示范围

2.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

3.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

4.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);

更多“AHis name is Ken Jordan. His first name is Ken. His family name is Jordam His phone number ”相关问题

  • 第1题：

    在SQL Server 2000中，现要在employees表的first_name和last_name列上建立一个唯一的非聚集复合索引，其中first_name列数据的重复率是5%，last_name列数据的重复率是10%。请补全下列语句使以first_name和last_name列作为条件的查询效率最高。

    CREATE UNIQUE NONCLUSTERED INDEX Idx_Name

    ON employees(______)


    正确答案：first_nameASClast_nameDESC
    first_nameASC，last_nameDESC

  • 第2题：

    姜华华客人的姓名正确录入方式为（）

    A．Last Name:Jiang; First:Huahua; Alt. Name:姜华华

    B．Last Name: 姜; First: 华华; Alt. Name: Jiang Huahua

    C．Last Name:jiang; First:huahua; Alt. Name:姜华华

    D．Last Name: 姜; First: 华华; Alt. Name: jiang huahua


    经口感染

  • 第3题：

    88、姜华华客人的姓名正确录入方式为（）

    A．Last Name:Jiang; First:Huahua; Alt. Name:姜华华

    B．Last Name: 姜; First: 华华; Alt. Name: Jiang Huahua

    C．Last Name:jiang; First:huahua; Alt. Name:姜华华

    D．Last Name: 姜; First: 华华; Alt. Name: jiang huahua


    Last Name:jiang; First:huahua; Alt. Name:姜华华

  • 第4题：

    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_name

    B.SORT BY age DESC, last_name

    C.ORDER BY age DESC, last_name

    D.ORDER BY age ASC, last_name


    参考答案：C

  • 第5题：

    4、姜华华客人的姓名正确录入方式为（）

    A．Last Name:Jiang; First:Huahua; Alt. Name:姜华华

    B．Last Name: 姜; First: 华华; Alt. Name: Jiang Huahua

    C．Last Name:jiang; First:huahua; Alt. Name:姜华华

    D．Last Name: 姜; First: 华华; Alt. Name: jiang huahua


    Last Name:jiang; First:huahua; Alt. Name:姜华华

  • 第6题：

    1.查询hr用户下的EMPLOYEES表，根据输入的first_name，查询拥有相同first_name的雇员信息。 （1）如果没有此first_name，应给出提示。 （2）如果只有1个first_name，应给出提示。 （3）如果有多个first_name相同用户，显示重名的总人数及他们的最高工资。


    错误

相关内容