网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
1、Last Name是指？
A．客人的姓氏
B．客人的名字
C．客人的付款方式
D．客人租车服务
参考答案和解析
姓氏
更多 “1、Last Name是指？A．客人的姓氏B．客人的名字C．客人的付款方式D．客人租车服务” 相关考题
考题
3．In China，the________ is behind________A． first name ;last nameB． last name; family nameC． family name; first nameD． last name; first name
考题
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
考题
ExhibitExamine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees‘ last names, along with their manager‘s last names and their department names. Which query would you use?（）A. SELECT last_name, manager_id, department_name FROM employees e FULL OUTER JOIN department d ON (e.department_id = d.department_id);B. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.managaer_id = m.employee_id) LEFT OUTER JOIN department d ON (e.department_id = d.department_id);C. SELECT e.last_name, m.last_name, department_name FROM employees e RIGT OUTER JOIN employees m on ( e.manager_id = m.employee_id) FULL OUTER JOIN department d ON (e.department_id = d.department_id);D. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGT OUTER JOIN department d ON (e.department_id = d.department_id);E. SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id)F. SELECT last_name, manager_id, department_name FROM employees e JOIN department d ON (e.department_id = d.department_id);
考题
在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(______)
考题
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）
考题
单选题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
考题
单选题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%'
考题
单选题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
考题
单选题Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?（）A
SELECT 1, 2 FROM 3 WHERE last_name = '8';B
SELECT 1, '2' FROM 3 WHERE ' last_name = '8';C
SELECT 1, 2 FROM 3 WHERE last_name = '8';D
SELECT 1, '2' FROM EMP WHERE last_name = '8';
考题
单选题Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith? （）A
SELECT COUNT (*) FROM employees WHERE last _name='smith';B
SELECT COUNT (dept_id) FROM employees WHERE last _name='smith';C
SELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name='smith';D
SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith';E
SELECT UNIQE (dept_id) FROM employees WHERE last _name='smith';
考题
单选题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;
考题
多选题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',);
考题
单选题Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?（）A
SELECT last_name, department_name FROM employees NATURAL JOIN departments;B
SELECT last_name, department_name FROM employees JOIN departments ;C
SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);D
SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);E
SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);F
SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
考题
单选题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: 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);
热门标签
最新试卷
