网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
The surname MacDonald in Scotland was probably first used to name Donald's_____.
A、uncle
B、son
C、nephew
D、daughter
参考答案
更多 “ The surname MacDonald in Scotland was probably first used to name Donald's_____. A、uncleB、sonC、nephewD、daughter ” 相关考题
考题
Youworkattheregionalsalesoffice.YouareresponsibleforimportingandexportingdatainSQLServer2005databases.Themainofficeasksyoutosendthematextfilethatcontainsupdatedcontactinformationforthecustomersinyourregion.ThedatabaseadministratorinthemainofficeasksthatthedatabesortedbytheStateProvince，Surname，andFirstNamecolumns.Youneedtosatisfytheserequirementsbyusingtheleastamountofeffort.Whatshouldyoudo？（）A.SpecifyStateProvince，Surname，andFirstNameintheORDERhintinthebcpoutcommand.B.Createaformatfilefortheexportoperation.C.SpecifyStateProvince，Surname，andFirstNameintheORDERBYclauseinthebcpqueryoutcommand.D.CopythedataintoanewtablethathasaclusteredindexonStateProvince，Surname，andFirstName.Exportthedata.
考题
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);
考题
在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(______)
考题
某企业职工关系EMP(E_no，E_name，DEPT，E_addr，E_tel)中的属性分别表示职工号、姓名、部门、地址和电话；经费关系FUNDS(E_no,E_limit，E_used)中的属性分别表示职工号、总经费金额和己花费金额。若要查询部门为"开发部"且职工号为"03015"的职工姓名及其经费余额，则相应的SQL语句应为: SELECT(60) FROM(61) WHERE(62)A.EMP.E_no,E_limit-E_usedB.EMP.E_name,E_used-E_limitC.EMP.E_no,E_used-E_limitD.EMP.E_name,E_limit-E_used
考题
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
考题
某企业职工关系EMP（E_no，E_name，DEPT，E_addr，E_tel）中的属性分别表示职工号、姓名、部门、地址和电话；经费关系FUNDS（E_no，E_limit，E_used）中的属性分别表示职工号、总经费金额和己花费金额。若要查询部门为"开发部"且职工号为"03015"的职工姓名及其经费余额，则相应的SQL语句应为:SELECT（请作答此空）FROM（ ）WHERE（ ）A.EMP.E_no,E_limit-E_used
B.EMP.E_name,E_used-E_limit
C.EMP.E_no,E_used-E_limit
D.EMP.E_name,E_limit-E_used
考题
姜华华客人的姓名正确录入方式为（）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相同用户，显示重名的总人数及他们的最高工资。
热门标签
最新试卷
