您要对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

题目

您要对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）

相似考题

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

2.“雇员”表在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、以上都不能；您无法变更索引

3.FACULTY表包含以下各列： FACULTYID VARCHAR2(5) NOT NULL PRIMARY KEY FIRST_NAME VARCHAR2(20) LAST_NAME VARCHAR2(20) ADDRESS VARCHAR2(35) CITY VARCHAR2(15) STATE VARCHAR2(2) ZIP NUMBER(9) TELEPHONE NUMBER(10) STATUS VARCHAR2(2) NOT NULL COURSE 表包含以下各列： COURSEID VARCHAR2(5) NOT NULL PRIMARY KEY SUBJECT VARCHAR2(5) TERM VARCHAR2(6 FACULTYID VARCHAR2(5) NOT NULL FOREIGN KEY 您需要制定一个报表，用于确定在下学期任教的所有副教授。您要创建一个视图来简化报表的创建过程。以下哪条CREATE VIEW语句将完成此任务（）A、CREATE VIEW（SELECT first_name，last_name，status，courseid，subject，term FROM faculty，course WHERE facultyid=facultyid）B、CREATE VIEW pt_view ON（SELEC Tfirst_name，last_name，status，courseid，subject，term FROM faculty f and coursec WHERE f.facultyid=c.facultyid）C、CREATE VIEW pt_view IN（SELECT first_name，last_name，status，courseid，subject，term FROM faculty course）D、CREATE VIEW pt_view AS（SELECT first_name，last_name，status，courseid，subject，term FROM facultyf，coursec WHERE f.facultyid=c.facultyid）

4.在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(______)

更多“您要对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 ”相关问题

第1题：

“雇员”表包含以下列： EMPLOYEE_ID NOT NULL, Primary Key SSNUM NOT NULL, Unique LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER 部门表中 DEPARTMENT_ID 列的外键 SALARY NUMBER(8,2) 如果执行以下语句： CREATE INDEX emp_name_idx ON employees(last_name, first_name); 以下哪个说法是的（）
- A、此语句会创建一个基于函数的索引
- B、因为语法错误，此语句将失败
- C、该语句将创建一个组合唯一索引
- D、该语句将创建一个组合非唯一索引
正确答案:D
第2题：

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');
正确答案:A
第3题：

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);
正确答案:F
第4题：

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 UNIQUE(dept_id) FROM employees WHERE last_name='Smith';
正确答案:D
第5题：

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;
正确答案:D
第6题：

单选题
You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees; （）
A
You get an error because of a primary key violation.
B
The data and structure of the EMPLOYEES table are deleted.
C
The data in the EMPLOYEES table is deleted but not the structure.
D
You get an error because the statement is not syntactically correct.

正确答案： D
解析：暂无解析
第7题：

单选题
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 UNIQUE(dept_id) FROM employees WHERE last_name='Smith';

正确答案： B
解析：暂无解析
第8题：

多选题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert 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', ' ');

正确答案： C,E
解析：暂无解析
第9题：

单选题
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;

正确答案： C
解析：暂无解析
第10题：

单选题
“雇员”表在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
以上都不能；您无法变更索引

正确答案： D
解析：暂无解析
第11题：

单选题
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');

正确答案： A
解析：暂无解析
第12题：

单选题
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);

正确答案： F
解析：暂无解析
第13题：

评估此CREATE VIEW 语句： CREATE VIEW pt_view AS (SELECT first_name, last_name, status, courseid, subject, term FROM faculty f, course c WHERE f.facultyid = c.facultyid); 此语句将创建什么类型的视图（）
- A、嵌套
- B、简单
- C、内嵌
- D、复杂
正确答案:B
第14题：

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',");
正确答案:C,E,F
第15题：

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’,‘’);
正确答案:C,E,F
第16题：

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);
正确答案:E
第17题：

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;
正确答案:D
第18题：

单选题
“雇员”表包含以下列： EMPLOYEE_ID NOT NULL, Primary Key SSNUM NOT NULL, Unique LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER 部门表中 DEPARTMENT_ID 列的外键 SALARY NUMBER(8,2) 如果执行以下语句： CREATE INDEX emp_name_idx ON employees(last_name, first_name); 以下哪个说法是的（）
A
此语句会创建一个基于函数的索引
B
因为语法错误，此语句将失败
C
该语句将创建一个组合唯一索引
D
该语句将创建一个组合非唯一索引

正确答案： C
解析：暂无解析
第19题：

多选题
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’,‘’);

正确答案： D,B
解析：暂无解析
第20题：

单选题
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;

正确答案： D
解析：暂无解析
第21题：

单选题
评估此CREATE VIEW 语句： CREATE VIEW pt_view AS (SELECT first_name, last_name, status, courseid, subject, term FROM faculty f, course c WHERE f.facultyid = c.facultyid); 此语句将创建什么类型的视图（）
A
嵌套
B
简单
C
内嵌
D
复杂

正确答案： C
解析：暂无解析
第22题：

单选题
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;

正确答案： A
解析：暂无解析
第23题：

多选题
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',);

正确答案： E,D
解析：暂无解析

题目

相似考题

相关内容